SQL for Data Engineering Beginners
Master SQL for data engineering: Learn to extract, transform, and load data, design efficient schemas, and automate data pipelines.
...
Share
SQL Fundamentals for Data Engineering
Unit 1: SQL and Data Engineering
Intro to SQL & DE
SQL vs. NoSQL
Data Warehousing 101
Setting Up Your Env
Basic SQL Syntax
Unit 2: Extracting Data with SELECT
SELECT Basics
Filtering with WHERE
Sorting with ORDER BY
Limiting Results
DISTINCT Values
Unit 3: Data Types, Operators, and Functions
Common Data Types
Arithmetic Operators
String Operators
Date and Time
Conditional Logic
Unit 4: Data Validation with Constraints
Constraints Overview
NOT NULL Constraint
UNIQUE Constraint
PRIMARY KEY Constraint
CHECK Constraint
Data Transformation and Loading with SQL
Unit 1: Data Transformation Fundamentals
Intro to Transformation
SQL Functions: The Basics
Expressions in SQL
Conditional Transformation
Data Type Conversion
Unit 2: Data Loading Techniques
Intro to Data Loading
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Bulk Loading
Unit 3: ETL Implementation with SQL
ETL Overview
Extracting Data with SQL
Transforming Data in ETL
Loading Data in ETL
ETL Orchestration
Unit 4: Data Loading Strategies
Loading Strategies
Full vs Incremental Loads
Change Data Capture
Staging Tables
Data Validation
Database Schema Design for Data Warehousing
Unit 1: Fundamentals of Data Warehouse Schema Design
Intro to Schema Design
Dimensions & Facts
Grain of the Data
Surrogate Keys
ETL's Role in Schemas
Unit 2: Star and Snowflake Schemas
Star Schema: Overview
Star Schema: Example
Snowflake Schema: Intro
Snowflake Schema: Use
Snowflake Schema: Example
Unit 3: Normalization and Denormalization
Normalization: Intro
Denormalization: Intro
Normalization vs. DW
When to Normalize
When to Denormalize
Unit 4: Creating and Managing Database Objects
Creating Tables
Indexes: Why?
Creating Indexes
Views: Intro
Creating Views
Advanced SQL Techniques for Data Engineering
Unit 1: Window Functions for Data Analysis
Window Functions Intro
Ranking with SQL
Value with LAG & LEAD
Aggregate Windows
Ratio to Report
Unit 2: SQL Performance Optimization
Indexing Explained
Query Execution Plans
Rewriting Queries
Partitioning Tables
Stats and Performance
Unit 3: Automating Data Engineering Tasks
SQL Scripting Intro
Scheduling Tools
ETL Automation
Data Validation
Logging and Monitoring
Unit 4: SQL Security Best Practices
SQL Injection
Access Control
Data Masking
Auditing Changes
Encryption