Data Engineering Fundamentals Professional Certificate
What you will learn:
- What data engineering is, what the modern data ecosystem looks like, and the data engineering lifecycle. You will also be provided with a taste of a day in the life of a Data Engineer and tips from professionals on starting your career in this discipline.
- The fundamentals of Python programming, including data structures, the use of files, invoking APIs and libraries such as Pandas, NumPy and performing extract, transform and load (ETL) processes.
- The principles of relational databases including Database Design, creating tables, using constraints, and working with MySQL, PostgreSQL & IBM Db2.
- How to use Structured Query Language (SQL) to query a database. Use SELECT, INSERT, UPDATE, and DELETE statements, database functions, stored procedures, work with multiple tables, JOINs, and ACID transactions.
This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand [...]
In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins. This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.
An opportunity to apply your foundational Python skills via a project, using various techniques to collect and work with data. Journey into the realm of becoming a Data Engineer and apply your basic Python knowledge of working with data. You will exercise various techniques in Python to extract data [...]