ETL with Python
Production Environment
Snowflake
-
Introduction to Snowflake and Data Warehousing Basics (120:21)
-
Loading Data into Snowflake (116:58)
-
Unloading Data and File Formats (107:48)
-
Snowflake SQL Basics (111:48)
-
Advanced SQL and Data Transformation (117:36)
-
Query Optimization and Resource Monitoring (109:19)
-
Automation with Tasks and Streams (104:31)
-
Final Real-World Project (142:16)
Workflow Orchestration (Airflow)
Analytics Engineering
Spark
AWS
Azure
-
Azure Data Factory: Introduction, Data Ingestion from Blob Storage, HTTP (134:14)
-
Azure Data Factory: Azure Data Flows (148:13)
-
Azure Data Factory: Databricks Activity, Loading to SQL (152:12)
-
Azure Databricks: Setup, Secrets, Mounts (134:55)
-
Azure Databricks: Ingestion, Transformation, Workflows (83:40)
-
Azure Databricks: Spark SQL (123:21)
-
Azure Databricks: Incremental Load (147:31)
-
Azure Databricks: Delta Lake (125:51)
Microsoft Fabric
AI/ML
-
Statistics and Probability
-
Predictive Models, Machine Learning Algorithms (Part 1)
-
Machine Learning Algorithms (Part 2), Recommender Systems
-
ML in the real world, Deep Learning and Neural Networks (Part 1)
-
Deep Learning and Neural Networks (Part 2)
-
Generative AI, The OpenAI API
-
RAG and LLM Agents
-
Final Project
Payroll Project
SQL - 2024
-
Introduce SQL Server (145:25)
-
SQL Query Statements (141:24)
-
Debug, Join & Sub-query in SQL (128:08)
-
Case-When, Window Function & SQL practice (123:51)
-
Pivot Table, UDF and Stored Procedure in SQL (132:55)
-
Basic Optimization SQL Server (127:07)
-
Practice SQL Test Platform (135:09)
-
SQL Graph Basic (122:10)
Python - 2024
-
Introduce to Python & Basic syntax (102:51)
-
Read files & Algorithms (131:04)
-
Basic Data Analysts with Python (113:14)
-
Intermediate Data Analysis with Python (153:20)
-
Automate task with Python (122:32)
-
PySpark & JSON (84:23)
-
Practice Python Test Platform (114:22)
-
APIs and Demo Project Data Analysis with Python (120:55)
