Data Engineering Foundation – Extreme Commerce College

Program overview:

‘Data Engineering Foundation’ is a tailored but specialized course developed to assist potential Students and developers to develop their potential for Data Science and Data Engineering. In this course, you’ll discover how to build an effective data architecture, streamline data processing, and maintain large-scale data systems. In addition to working with Python, you’ll also grow your language skills as you work with SQL, and other tools, to create Data Engineering Foundation pipelines, converging in comprehensive understanding and execution of Data Science, automate common file system tasks, and build a high-performance database.

Who should attend:

Students from CS, IT or Software background can join.
anyone who wants to learn this diverse field.

Objectives:

Imbibe Python Programming Skills
Investigating and perceiving datasets
To analyze and interpret any given data set.
What outcomes may be tabulated from data sets

Learning Outcome:

On successful completion of this program, participants will be able to:

Knowledge

Working knowledge of creation of Tables and Data Sets
Learn critical concepts around data sets and manipulations techniques.
Understanding different data storage options such as SQL.
Learn application scalability in terms of deployment.
Viewpoints and tips from Data professionals on starting a career in this domain.
Identifying patterns and data used for descriptive and predictive analytics.

Skills

Python programming basics including data structures, logic, working with files, invoking APIs, using libraries such as Pandas, NumPy, and Seaborn.
SQL query language, SELECT, INSERT, UPDATE, DELETE statements, database functions, stored procs, working with multiple tables, Joins, & transactions.
Schedule, automate, and monitor data pipelines. Run data quality checks, track data lineage, and work with data pipelines in production.
Identifying matrixes important to stakeholders and creating dashboards to represent.
Creating and hypothecating inferences to be. Highlighting data in the form of descriptive statistics.

Become a Certified Data Science Professional
with this programme

Course Curriculum

Here is what’s included in this Artificial Intelligence Course

What is Data Engineering?

Python from Basics to Intermediate
SQL from Basics to Advanced
Python Data Structures
Working with Data in Python
Basics of Python + Code Best Practices using Python
Tableau would be used for visualization

Introduction to Databases

Relational Database Concepts
Using Relational Databases
MySQL

Databases and SQL for Data Science with Python

- Getting Started with SQL
- Introduction to Relational Databases and Tables
- Intermediate SQL
- Accessing Databases using Python
- Data Science to Data Engineering Foundation