About this course
Set up your SQL environment and review foundational concepts.
Before We Begin
1 Parts
- 0:05 Hr
Global Implementations
5 Min
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
Assignment 1
2 Parts
- 0:45 Hr
Build a Customer Order Query System
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
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
3 Parts
- 2:15 Hr
Advanced Joins
45 Min
Subqueries and CTEs
45 Min
Exercise: Complex Sales Query
45 Min
Assignment 2
2 Parts
- 0:45 Hr
Sales Performance Dashboard with Aggregation
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
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
Assignment 3
2 Parts
- 0:45 Hr
Optimize and Secure High-Volume Transaction System
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
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 Project 1
2 Parts
- 50:00 Hr
Secure Customer Relationship Management (CRM) System
3000 Min
Submit Your Project here
Submit Your Project
Min Grade: 40
Capstone Project 2
2 Parts
- 50:00 Hr
Scalable Sales Data Warehouse
3000 Min
Submit Your Project here
Submit Your Project
Min Grade: 40
No Reviews Yet
