SQL + DBMS
Relational Database Design, Query Optimization & Data Architecture
A practical 1.5-month foundation course designed to turn beginners into confident database designers and SQL query experts.
Understand relational database management systems (RDBMS), relational schemas, primary and foreign keys, and normalization principles.
Write clean, powerful SQL queries—from fundamental SELECT statements and multi-table JOINs to aggregations, subqueries, and views.
Design, populate, and optimize a real-world relational database in an end-to-end mini capstone project.
Program Details
Program Roadmap
DBMS Fundamentals
Understand database design principles, relational models, and normalization concepts.
- ●Database Concepts and Architecture: File Systems vs RDBMS
- ●Relational Model Foundations: Relations, Attributes, and Domains
- ●Keys in RDBMS: Primary, Foreign, Candidate, and Unique Keys
- ●Entity-Relationship (ER) Modeling and Schema Diagram Translation
- ●Database Normalization Principles: 1NF, 2NF, and 3NF Standards
SQL Basics
Write clean, foundational SQL queries to retrieve and filter data with precision.
- ●Data Definition Language (DDL) and Data Manipulation Language (DML)
- ●Creating, Altering, and Dropping Tables with Constraints
- ●Data Retrieval with SELECT Statements and Column Aliasing
- ●Row-Level Filtering using WHERE Clauses and Comparison Operators
- ●Sorting Results with ORDER BY and Restricting Rows with LIMIT
Joins & Relationships
Query across multiple relational tables with confidence and accuracy.
- ●Understanding Table Relationships: One-to-One, One-to-Many, Many-to-Many
- ●Foreign Key Constraints and Enforcing Referential Integrity
- ●Inner Joins, Left Outer Joins, and Right Outer Joins
- ●Full Outer Joins, Cross Joins, and Self Joins for Hierarchical Data
- ●Multi-Table Query Design Across Complex Business Schemas
Aggregation & Grouping
Summarize, aggregate, and extract actionable business insights from dataset rows.
- ●SQL Aggregate Functions: Count, Sum, Average, Minimum, and Maximum
- ●Categorical Data Grouping with the GROUP BY Clause
- ●Post-Aggregation Filtering using HAVING vs Row Filtering with WHERE
- ●Combining Aggregations with Multi-Table Joins for Analytical Reports
- ●Handling Null Values and Edge Cases in Analytical Summaries
Subqueries & Views
Build modular, readable, and reusable complex SQL queries.
- ●Nested Subqueries in WHERE, FROM, and SELECT Clauses
- ●Correlated Subqueries and Subquery Operators
- ●Creating, Updating, and Querying Database Views
- ●Data Security, Encapsulation, and Query Abstraction via Views
- ●Introduction to Common Table Expressions for Modular Query Design
Mini Project
Apply DBMS and SQL skills end-to-end by designing and querying a real-world relational database.
- ●Business Problem Decomposition and Relational Schema Blueprinting
- ●DDL Implementation with Primary Keys, Foreign Keys, and Constraints
- ●Realistic Mock Data Seeding and Data Ingestion
- ●Authoring Analytical Queries with Joins, Grouping, and Views
- ●Schema Validation, Documentation, and Portfolio Presentation
From Learning to Production
What You'll Gain
Comprehensive DBMS foundation
RDBMS architecture, relational models, primary/foreign keys, and data integrity
Database normalization mastery
normal forms (1NF, 2NF, 3NF) for scalable schema design
Core SQL querying fluency
SELECT, WHERE, ORDER BY, operators, filtering, and sorting
Multi-table relational joins
inner, outer, left, and right joins to connect complex business data
Analytical grouping & aggregations
GROUP BY, HAVING, and essential SQL aggregate functions
Advanced modular queries
subqueries, views, and introduction to Common Table Expressions (CTEs)
End-to-end database mini project
design and implement a complete relational database for your portfolio