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.

Key Features:

Interactive Lessons: Engaging video lectures and interactive exercises to reinforce learning.
Real-World Examples: Practical examples and case studies to illustrate key concepts and their applications.
Expert Instruction: Learn from experienced professionals who bring industry insights and best practices.

Course Content

Section 1 – Introduction to SQL and DDL Basics

Understanding SQL Intuition and DDL Basics

08:17
Authorization and DDL Commands

06:16
Advanced DDL: ALTER, DROP, and RENAME

08:34

Section 2 – Deep Dive into DDL and Constraints

Section 3 – Data Manipulation and Table Alterations

Section 4 – DML Commands: INSERT, UPDATE, DELETE

Section 5 – Data Control Language and Constraints

Section 6 – Advanced SQL Operations

Section 7 – Advanced Filtering and Examples

Section 8 – Logical Operations and Grouping

Section 9 – Limit and Offset Operations

Section 10 – Advanced Join Techniques

Section 11 – Views and Triggers

Section 12 – Subqueries and Optimization

Section13 – Stored Procedures and Indexing

A course by

Akhil Vydyula

Student Ratings & Reviews

No Review Yet

SQL for Data Engineers Designing and Building Data Pipelines

Key Features:

What Will You Learn?

Audience

Course Content

Section 1 – Introduction to SQL and DDL Basics

Understanding SQL Intuition and DDL Basics

Authorization and DDL Commands

Advanced DDL: ALTER, DROP, and RENAME

Section 2 – Deep Dive into DDL and Constraints

Comprehensive DDL Concepts

DDL Commands: Read, Insert, and Update Authorization

Primary Key Constraints and Auto-Increment

Section 3 – Data Manipulation and Table Alterations

Table and Column Alterations

Data Manipulation Language (DML) Basics

SELECT Command: Advantages, Limitations, and Challenges

Section 4 – DML Commands: INSERT, UPDATE, DELETE

INSERT Command: Pros and Cons

UPDATE and DELETE Commands: Pros and Cons

Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT

Section 5 – Data Control Language and Constraints

DCL and Domain Constraints

Check Constraints and Table Constraints

Primary and Foreign Key Constraints

Section 6 – Advanced SQL Operations

Foreign Key vs. Primary Key and TRUNCATE vs. DELETE

SQL Procedures and Set Operations

Group By, Where, Fetch, Limit, and Distinct

Section 7 – Advanced Filtering and Examples

HAVING vs. WHERE with Examples

Match and Offset Functions

MIN, MAX, IN, and NOT IN Operations

Section 8 – Logical Operations and Grouping

AND, OR, NOT Operations

Grouping Sets and LIKE Operation

Advanced Grouping and Join Operations

Section 9 – Limit and Offset Operations

LIMIT and OFFSET Clauses

IN, NOT IN, and NULL Operations

Join Operations: LEFT and RIGHT

Section 10 – Advanced Join Techniques

Inner and Outer Joins

Full Outer and Cross Joins

Hands-On: RANK and ROW_NUMBER

Section 11 – Views and Triggers

Dense Rank: Advantages and Limitations

SQL Views: Creation, Updating, and Dropping

SQL Triggers: Row Level vs. Statement Level

Section 12 – Subqueries and Optimization

Deleting Triggers and Complex Subqueries

Subqueries and Query Optimization

Comparison Operations and Introduction to Stored Procedures

Section13 – Stored Procedures and Indexing

Stored Procedures with Parameters and Indexing in SQL

Tags

A course by

Student Ratings & Reviews

Course Includes:

Share On:

Sign in

Sign up