About this course
Set up your SQL environment and review foundational concepts.
Prerequisites & Readiness Check
2 Parts
- 1:00 Hr
Prerequisites for SQL Mastery
45 Min
SQL Environment Setup Guide
15 Min
Chapter 1: Introduction to Databases & SQL Basics
3 Parts
- 2:00 Hr
Database Fundamentals
45 Min
SQL Syntax Basics
45 Min
Exercise: First SQL Query
30 Min
Chapter 2: Table Creation & Data Types
3 Parts
- 2:00 Hr
Creating Tables
45 Min
Data Types and Constraints
45 Min
Exercise: Customer Table Design
30 Min
Chapter 3: CRUD Operations & Data Handling
3 Parts
- 1:45 Hr
Data Manipulation
45 Min
Data Import/Export
30 Min
Exercise: Employee Data Management
30 Min
Chapter 4: Basic Joins & Aggregate Functions
3 Parts
- 1:45 Hr
Basic Joins
45 Min
Aggregate Functions
30 Min
Exercise: Sales Summary Query
30 Min
Chapter 5: Views & Basic Indexing
3 Parts
- 1:30 Hr
Working with Views
30 Min
Basic Indexes
30 Min
Exercise: Create View for Simplified Reporting
30 Min
Chapter 6: Advanced Joins & Subqueries
2 Parts
- 2:15 Hr
Advanced Joins
45 Min
Subqueries and CTEs
45 Min
Chapter 7: Window Functions & Data Modeling
3 Parts
- 2:15 Hr
Window Functions
45 Min
Intermediate Data Modeling
45 Min
Exercise: Employee Ranking Query
45 Min
Chapter 8: Stored Procedures & Transactions
3 Parts
- 2:15 Hr
Stored Procedures and Triggers
45 Min
Transaction Management
45 Min
Exercise: Inventory Update Procedure
45 Min
Chapter 9: Security & Backup
3 Parts
- 2:15 Hr
User Management and Security
45 Min
Backup and Recovery
45 Min
Exercise: Restrict Data Access by User Role
45 Min
Chapter 10: Query Optimization & Advanced Indexing
3 Parts
- 2:15 Hr
Query Optimization
45 Min
Advanced Indexing
45 Min
Exercise: Optimize JSON Query with GIN Index
45 Min
Chapter 11: Advanced Features: Partitioning, Replication & JSON
3 Parts
- 2:45 Hr
Partitioning and Replication
60 Min
JSON and XML Handling
45 Min
Exercise: Partition Sales Table by Date Range
60 Min
Capstone Projects
2 Parts
- 100:00 Hr
Project 1: Secure Customer Relationship Management (CRM) System
3000 Min
Project 2: Scalable Sales Data Warehouse
3000 Min
No Reviews Yet
