Program Starts
March 6, 2025 - April 24, 2025
Optional Meet Up time Thursdays
6:30 pm : 8 pm cst
The Mentorship session is designed to equip you with the fundamental skills to kickstart your Data Engineering career
How it Works
You will have access to exclusive, curated training videos on SQL and Python, which you can watch at your own pace for six months. However, it is recommended to follow the 8-week curriculum outlined below.
Hi, I’m Mezue your instructor
I am a seasoned Azure Databricks Data Engineer with 10 years of experience. I have worked with various clients, consulting across different industries, and currently, I am employed at Capgemini, a top IT consulting firm
Weekly Topics
Section 1 - Python
Week 1
· Introduction to Python, variables, print() statement and its data structures
· Python Control Structure and Functions
Week 2
· Python Data Structure
· List
· Tuples
· Sets
· Dictionary
Week 3
· Python Lambda functions
· Class concept
· Python Pandas library
Week 4
· Advanced Python – Decorators
· Common algorithms
· Big O notation
Section 2 - SQL
Week 1
· Background of Databases
· Basic Database Operations – CRUD (Create, read, update, delete)
· Select Statement basics
Week 2
· FROM clause
· Where Clause
· Group by
Week 3
· SQL JOIN
· Advanced SQL
· Case statement, String Manipulation
· Subquery and CTE
Week 4
· Advanced SQL
· Case statement, String Manipulation
· Subquery and CTE
· NULL
· Window Functions
· Merge statements
· Database concepts: Index, views, and stored procedures