Skip to content
EdindxEdindx
  • Courses
      • Data Engineering and Analytics
      • Microsoft Dynamics 365
      • Animation Tools
      • Network and Security
      • Professional Development
      • Marketing
      • Graphic Design
      • Sales
      • Oracle Cloud
      • Communication Skills
      • IT Trending Courses
      • Cyber Security
      • Full Stack Engineer
      • E-Commerce
      • Data Engineering and Analytics
      • Programming
  • Career Path
  • Instructor Registration
Login/Register
EdindxEdindx
  • Courses
      • Data Engineering and Analytics
      • Microsoft Dynamics 365
      • Animation Tools
      • Network and Security
      • Professional Development
      • Marketing
      • Graphic Design
      • Sales
      • Oracle Cloud
      • Communication Skills
      • IT Trending Courses
      • Cyber Security
      • Full Stack Engineer
      • E-Commerce
      • Data Engineering and Analytics
      • Programming
  • Career Path
  • Instructor Registration
SQL for Data Engineers Designing and Building Data Pipelines Advanced DDL: ALTER, DROP, and RENAME
SQL for Data Engineers Designing and Building Data Pipelines
0% Completed
Section 1 – Introduction to SQL and DDL Basics
Understanding SQL Intuition and DDL Basics
Video - 00:8:17 mins
Authorization and DDL Commands
Video - 00:6:16 mins
Advanced DDL: ALTER, DROP, and RENAME
Video - 00:8:34 mins
Section 2 – Deep Dive into DDL and Constraints
Comprehensive DDL Concepts
Video - 00:8:7 mins
DDL Commands: Read, Insert, and Update Authorization
Video - 00:4:56 mins
Primary Key Constraints and Auto-Increment
Video - 00:5:10 mins
Section 3 – Data Manipulation and Table Alterations
Table and Column Alterations
Video - 00:5:27 mins
Data Manipulation Language (DML) Basics
Video - 00:4:45 mins
SELECT Command: Advantages, Limitations, and Challenges
Reading
Section 4 – DML Commands: INSERT, UPDATE, DELETE
INSERT Command: Pros and Cons
Video - 00:6:13 mins
UPDATE and DELETE Commands: Pros and Cons
Video - 00:7:19 mins
Transaction Control Language: COMMIT, ROLLBACK, SAVEPOINT
Video - 00:6:27 mins
Section 5 – Data Control Language and Constraints
DCL and Domain Constraints
Video - 00:6:44 mins
Check Constraints and Table Constraints
Video - 00:8:25 mins
Primary and Foreign Key Constraints
Video - 00:8:32 mins
Section 6 – Advanced SQL Operations
Foreign Key vs. Primary Key and TRUNCATE vs. DELETE
Video - 00:7:21 mins
SQL Procedures and Set Operations
Video - 00:6:54 mins
Group By, Where, Fetch, Limit, and Distinct
Video - 00:7:46 mins
Section 7 – Advanced Filtering and Examples
HAVING vs. WHERE with Examples
Video - 00:6:7 mins
Match and Offset Functions
Video - 00:6:47 mins
MIN, MAX, IN, and NOT IN Operations
Video - 00:6:33 mins
Section 8 – Logical Operations and Grouping
AND, OR, NOT Operations
Video - 00:5:21 mins
Grouping Sets and LIKE Operation
Video - 00:6:35 mins
Advanced Grouping and Join Operations
Video - 00:7:8 mins
Section 9 – Limit and Offset Operations
LIMIT and OFFSET Clauses
Video - 00:8:49 mins
IN, NOT IN, and NULL Operations
Video - 00:7:41 mins
Join Operations: LEFT and RIGHT
Video - 00:5:48 mins
Section 10 – Advanced Join Techniques
Inner and Outer Joins
Video - 00:6:43 mins
Full Outer and Cross Joins
Video - 00:5:43 mins
Hands-On: RANK and ROW_NUMBER
Video - 00:6:30 mins
Section 11 – Views and Triggers
Dense Rank: Advantages and Limitations
Video - 00:7:10 mins
SQL Views: Creation, Updating, and Dropping
Video - 00:5:45 mins
SQL Triggers: Row Level vs. Statement Level
Video - 00:6:21 mins
Section 12 – Subqueries and Optimization
Deleting Triggers and Complex Subqueries
Video - 00:6:58 mins
Subqueries and Query Optimization
Video - 00:6:58 mins
Comparison Operations and Introduction to Stored Procedures
Video - 00:6:25 mins
Section13 – Stored Procedures and Indexing
Stored Procedures with Parameters and Indexing in SQL
Video - 00:5:54 mins
Announcements Reviews Course Info
PreviousNext
Edindx-5

Email: info@edindx.com

Online Platform

Links

  • News & Articles

Contacts

Enter your email address to register to our newsletter subscription

  • Privacy Policy
  • Terms & Conditions
Facebook Instagram Youtube Linkedin
Copyright 2026 Edindx All Rights Reserved
EdindxEdindx
Sign inSign up

Sign in

Don’t have an account? Sign up
Lost your password?

Sign up

Already have an account? Sign in