SQL for Data Engineers Designing and Building Data Pipelines
This comprehensive course is tailored for data engineers looking to master SQL and build robust data pipelines. Whether you're just starting or aiming to enhance your existing skills, this course will provide you with the knowledge and tools needed to design, implement, and optimise SQL-based data pipelines effectively.
FREE
/CourseBundles(46033)/3266633-sql_pic.jpg)
Course Overview
Schedule of Classes
Course Curriculum
1 Subject
SQL for Data Engineers Designing and Building Data Pipelines
34 Learning Materials
Introduction to SQL and DDL Basics
Understanding SQL Intuition and DDL Basics
Authorization and DDL Commands
Advanced DDL: ALTER, DROP, and RENAME
Deep Dive into DDL and Constraints
Comprehensive DDL Concepts
DDL Commands: Read, Insert, and Update Authorization
Primary Key Constraints and Auto-Increment
Data Manipulation and Table Alterations
Table and Column Alterations
Data Manipulation Language (DML) Basics
SELECT Command: Advantages, Limitations, and Challenges
DML Commands: INSERT, UPDATE, DELETE
INSERT Command: Pros and Cons
UPDATE and DELETE Commands: Pros and Cons
Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT
Data Control Language and Constraints
DCL and Domain Constraints
Check Constraints and Table Constraints
Primary and Foreign Key Constraints
Advanced SQL Operations
Foreign Key vs. Primary Key and TRUNCATE vs. DELETE
SQL Procedures and Set Operations
Group By, Where, Fetch, Limit, and Distinct
Advanced Filtering and Examples
HAVING vs. WHERE with Examples
Match and Offset Functions
MIN, MAX, IN, and NOT IN Operations
Logical Operations and Grouping
AND, OR, NOT Operations
Grouping Sets and LIKE Operation
Advanced Grouping and Join Operations
Limit and Offset Operations
LIMIT and OFFSET Clauses
IN, NOT IN, and NULL Operations
Join Operations: LEFT and RIGHT
Advanced Join Techniques
Inner and Outer Joins
Full Outer and Cross Joins
Hands-On: RANK and ROW_NUMBER
Views and Triggers
Dense Rank: Advantages and Limitations
SQL Views: Creation, Updating, and Dropping
SQL Triggers: Row Level vs. Statement Level
Subqueries and Optimization
Stored Procedures and Indexing
ASSIGNMENT
SQL ASSIGNMENT
Course Instructor
Mentor
45 Courses • 3076 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy