You will learn

• How to design and manage relational databases using SQL
• How to clean and manipulate data using Python
• How to build and automate ETL processes
• How to set up and maintain scalable data architectures
• How to ensure data quality in data-driven environments

Topics

• Introduction to relational databases and SQL
  • Overview of database types
  • Various RDBMS systems and SQL dialects
  • Data types and keys
  • Introduction to SQL
  • Retrieving, sorting, and filtering data
• Writing advanced SQL queries for data engineers
  • Grouping and aggregating data
  • Subqueries
  • Joins
  • Inserting, updating, and deleting data
  • Creating, altering, and dropping tables
• Python fundamentals
  • Introduction to Python for data engineering
  • Variables, data types, lists, and dictionaries
  • Logic, functions, and methods
• Python packages for data engineers
  • Using package NumPy for efficient data structures
  • Using package Pandas for cleaning, manipulating, and automating data

Visualizing data with Matplotlib