Course Overview
What You Will Learn
This course is a complete, practical guide to mastering databases and SQL—from the fundamentals to advanced real-world applications.
Whether you’re a beginner starting from scratch or a developer looking to strengthen your backend and data skills, this course will take you step by step through how modern data systems are designed, queried, and optimized.
You will begin by understanding how databases work, including relational and NoSQL systems, and then move into writing powerful SQL queries using real-world datasets. As you progress, you will learn how to design efficient database schemas, work with relationships, and analyze data using joins, aggregations, subqueries, and Common Table Expressions (CTEs).
Beyond querying, this course dives into advanced topics such as views, stored procedures, triggers, indexing, and query optimization—skills used in production systems. You will also learn about transactions, ACID properties, normalization, and data warehousing concepts that are critical in enterprise environments.
To give you a modern, well-rounded perspective, the course also introduces NoSQL databases like MongoDB and Redis, along with ORM tools like SQLAlchemy for integrating databases into applications.
By the end of this course, you will not only understand how databases work—you will be able to design, query, and optimize real-world systems confidently.
Program Curriculum
Course Content
Explore the full learning path section by section and preview what is included in this program.
What is Data and Why It Matters
Preview
Text
What is a Database?
Text
Locked
What is a DBMS (Database Management System)?
Text
Locked
Why Databases Matter in Modern Applications
Text
Locked
File Systems vs Databases
Text
Locked
Structured, Semi-Structured, and Unstructured Data
Text
Locked
Overview of Database Types
Text
Locked
How Data Flows in Real Applications
Text
Locked
OLTP vs OLAP
Text
Locked
Choosing the Right Database for a System
Text
Locked
Introduction to the Relational Model
Text
Locked
Tables, Rows, and Columns Explained
Text
Locked
Entities and Attributes
Text
Locked
Introduction to Relationships Between Tables
Text
Locked
Primary Keys – Unique Identification
Text
Locked
Foreign Keys – Connecting Tables
Text
Locked
Composite Keys – Multi-Column Keys
Text
Locked
One-to-One, One-to-Many, and Many-to-Many Relationships
Text
Locked
Junction Tables for Many-to-Many Relationships
Text
Locked
Introduction to ERD (Entity Relationship Diagram)
Text
Locked
Designing a Simple Database from Requirements
Text
Locked
Common Mistakes in Relational Design
Text
Locked
Introduction to SQL
Text
Locked
SQL Syntax Basics
Text
Locked
SELECT Statement – Retrieving Data
Text
Locked
Filtering Data with WHERE
Text
Locked
Logical Operators – AND, OR, NOT
Text
Locked
Pattern Matching with LIKE
Text
Locked
Sorting Data with ORDER BY
Text
Locked
Limiting Results with LIMIT
Text
Locked
INSERT – Adding New Data
Text
Locked
UPDATE – Modifying Existing Data
Text
Locked
DELETE – Removing Data
Text
Locked
IN, BETWEEN, and IS NULL
Text
Locked
DISTINCT – Removing Duplicates
Text
Locked
Aliases with AS
Text
Locked
SQL Data Types Basics
Text
Locked
Introduction to SQL Constraints
Text
Locked
Sakila Practice Queries
Text
Locked
Introduction to SQL Joins
Text
Locked
INNER JOIN – Matching Records Only
Text
Locked
LEFT JOIN – Keeping All Left Rows
Text
Locked
RIGHT JOIN and FULL JOIN
Text
Locked
Joining Multiple Tables
Text
Locked
Self Joins
Text
Locked
GROUP BY – Aggregating Rows
Text
Locked
Aggregate Functions – COUNT, SUM, AVG, MAX, MIN
Text
Locked
HAVING – Filtering Grouped Results
Text
Locked
WHERE vs HAVING
Text
Locked
Subqueries – Queries Inside Queries
Text
Locked
Subqueries in SELECT and FROM
Text
Locked
Introduction to CTEs (WITH Clause)
Text
Locked
Window Functions Overview
Text
Locked
Ranking Functions – ROW_NUMBER and RANK
Text
Locked
Sakila Analysis Examples
Text
Locked
Common Mistakes in Joins and Aggregation
Text
Locked
Introduction to Database Objects
Text
Locked
What is a View?
Text
Locked
Why Views Are Useful
Text
Locked
Creating and Managing Views
Text
Locked
What is a Stored Procedure?
Text
Locked
Stored Procedures with Parameters
Text
Locked
Why Stored Procedures Matter in Production
Text
Locked
What is a Trigger?
Text
Locked
BEFORE vs AFTER Triggers
Text
Locked
Audit Logging with Triggers
Text
Locked
Comparing Views, Procedures, and Triggers
Text
Locked
Best Practices for Database Objects
Text
Locked
Common Mistakes and Pitfalls
Text
Locked
Sakila Examples with Views, Procedures, and Triggers
Text
Locked
Introduction to Database Performance
Text
Locked
What is an Index?
Text
Locked
How Indexes Work Internally
Text
Locked
Types of Indexes
Text
Locked
When to Use Indexes (and When Not To)
Text
Locked
Query Execution with EXPLAIN
Text
Locked
Full Table Scan vs Index Scan
Text
Locked
Optimizing WHERE Clauses
Text
Locked
Optimizing JOIN Operations
Text
Locked
Optimizing SELECT Queries
Text
Locked
Using LIMIT for Performance
Text
Locked
Query Optimization Best Practices
Text
Locked
Indexing Strategy in Real Systems
Text
Locked
Common Performance Mistakes
Text
Locked
Real-World Optimization Example
Text
Locked
Introduction to Query Caching
Text
Locked
Scaling Databases – Basic Concepts
Text
Locked
Introduction to Transactions
Text
Locked
Why Transactions Matter
Text
Locked
ACID Properties Overview
Text
Locked
Atomicity – All or Nothing
Text
Locked
Consistency – Valid Data State
Text
Locked
Isolation – Transactions Don’t Interfere
Text
Locked
Durability – Permanent After Commit
Text
Locked
BEGIN, COMMIT, and ROLLBACK
Text
Locked
Practical Transaction Example
Text
Locked
Handling Errors in Transactions
Text
Locked
Isolation Levels Explained
Text
Locked
Common Concurrency Problems
Text
Locked
Transactions in Real Applications
Text
Locked
Best Practices for Transactions
Text
Locked
Common Mistakes in Transactions
Text
Locked
Transactions vs NoSQL Consistency Models
Text
Locked
Real-World Banking Scenario
Text
Locked
Introduction to Data Modeling
Text
Locked
What is Normalization?
Text
Locked
First Normal Form (1NF)
Text
Locked
Second Normal Form (2NF)
Text
Locked
Third Normal Form (3NF)
Text
Locked
Before vs After Normalization
Text
Locked
Advantages of Normalization
Text
Locked
Disadvantages of Normalization
Text
Locked
Introduction to Denormalization
Text
Locked
When to Use Denormalization
Text
Locked
Introduction to Data Warehousing
Text
Locked
OLTP vs OLAP Systems
Text
Locked
Star Schema and Snowflake Schema
Text
Locked
Real-World Database Design Example
Text
Locked
Choosing Between Normalization and Denormalization
Text
Locked
Common Data Modeling Mistakes
Text
Locked
Best Practices for Database Design
Text
Locked
Introduction to NoSQL Databases
Text
Locked
SQL vs NoSQL – Key Differences
Text
Locked
Types of NoSQL Databases
Text
Locked
Introduction to MongoDB
Text
Locked
MongoDB vs Relational Tables
Text
Locked
CRUD Operations in MongoDB
Text
Locked
Schema Design in MongoDB
Text
Locked
Introduction to Redis
Text
Locked
Redis Data Structures
Text
Locked
Caching Concepts with Redis
Text
Locked
When to Use MongoDB vs Redis
Text
Locked
CAP Theorem
Text
Locked
Eventual Consistency vs Strong Consistency
Text
Locked
Real-World Architecture Example
Text
Locked
Scaling with NoSQL Systems
Text
Locked
Common Mistakes with NoSQL
Text
Locked
Choosing the Right Database
Text
Locked
What is an ORM?
Text
Locked
Why ORMs Are Used in Modern Applications
Text
Locked
Introduction to SQLAlchemy
Text
Locked
Creating a Database Connection
Text
Locked
Defining Models (Tables as Classes)
Text
Locked
Creating Tables from Models
Text
Locked
Sessions and Database Interaction
Text
Locked
Insert Data Using ORM
Text
Locked
Querying Data Using ORM
Text
Locked
Updating Data Using ORM
Text
Locked
Deleting Data Using ORM
Text
Locked
Relationships in ORM
Text
Locked
One-to-Many Relationship Example
Text
Locked
ORM vs Raw SQL
Text
Locked
Integrating ORM with FastAPI
Text
Locked
Integrating ORM with Django
Text
Locked
Transactions in ORM
Text
Locked
Introduction to Real-World Database Design
Text
Locked
Understanding Business Requirements
Text
Locked
Identifying Entities in the System
Text
Locked
Defining Attributes for Each Entity
Text
Locked
Defining Relationships Between Entities
Text
Locked
Creating the ERD
Text
Locked
Designing Tables in SQL
Text
Locked
Designing Order Items and Many-to-Many Handling
Text
Locked
Applying Normalization to the Design
Text
Locked
Adding Constraints and Data Integrity Rules
Text
Locked
Populating Sample Data
Text
Locked
Querying the System
Text
Locked
Handling Transactions in the Case Study
Text
Locked
Performance Considerations in the Design
Text
Locked
Scaling the System (Basic Ideas)
Text
Locked
Common Design Mistakes in Real Systems
Text
Locked
Final Architecture Overview
Text
Locked
Introduction to Advanced Performance Tuning
Text
Locked
Understanding Query Execution Plans Deeply
Text
Locked
Identifying Slow Queries
Text
Locked
Index Optimization Strategies
Text
Locked
Query Refactoring Techniques
Text
Locked
Avoiding the N+1 Query Problem
Text
Locked
Optimizing JOIN Performance
Text
Locked
Using Partitioning for Large Tables
Text
Locked
Caching Strategies for Performance
Text
Locked
Read Replicas and Load Distribution
Text
Locked
Database Connection Pooling
Text
Locked
Batch Processing vs Real-Time Queries
Text
Locked
Denormalization for Performance
Text
Locked
Monitoring Database Performance
Text
Locked
Real-World Optimization Example
Text
Locked
Scaling Strategies for Large Systems
Text
Locked
Performance Optimization Checklist
Text
Locked
Introduction to Database Security
Text
Locked
Common Database Security Threats
Text
Locked
SQL Injection Explained
Text
Locked
Preventing SQL Injection
Text
Locked
Authentication and Authorization
Text
Locked
Database Users and Roles
Text
Locked
Data Encryption Basics
Text
Locked
Hashing vs Encryption
Text
Locked
Protecting Sensitive Data
Text
Locked
Backup and Recovery Strategies
Text
Locked
Database Auditing and Logging
Text
Locked
Securing Database Connections
Text
Locked
Environment Variables and Secret Management
Text
Locked
Common Security Mistakes
Text
Locked
Database Security in Cloud Environments
Text
Locked
Compliance and Data Protection
Text
Locked
Security Best Practices Checklist
Text
Locked
Introduction to Scaling Databases
Text
Locked
Vertical Scaling (Scaling Up)
Text
Locked
Horizontal Scaling (Scaling Out)
Text
Locked
Read Replicas
Text
Locked
Database Sharding
Text
Locked
Partitioning vs Sharding
Text
Locked
Load Balancing in Database Systems
Text
Locked
Caching Layer in Architecture
Text
Locked
Event-Driven Architecture Basics
Text
Locked
Message Queues (Kafka, RabbitMQ)
Text
Locked
CAP Theorem Revisited
Text
Locked
Microservices and Database Design
Text
Locked
API Gateway and Database Interaction
Text
Locked
High Availability and Failover
Text
Locked
Disaster Recovery Strategies
Text
Locked
Polyglot Persistence
Text
Locked
Real-World Architecture Example
Text
Locked
Introduction to Data Warehousing
Text
Locked
OLTP vs OLAP Systems
Text
Locked
Data Warehouse Architecture
Text
Locked
ETL Process (Extract, Transform, Load)
Text
Locked
Data Cleaning and Transformation
Text
Locked
Fact Tables and Dimension Tables
Text
Locked
Star Schema Explained
Text
Locked
Snowflake Schema Explained
Text
Locked
Aggregation and Pre-Computed Data
Text
Locked
Data Warehousing vs Traditional Databases
Text
Locked
Introduction to Business Intelligence (BI)
Text
Locked
Querying Data for Analytics
Text
Locked
Real-World Analytics Example (Sakila)
Text
Locked
Data Pipelines in Modern Systems
Text
Locked
Batch vs Real-Time Analytics
Text
Locked
Common Challenges in Data Warehousing
Text
Locked
Real-World Data Architecture Overview
Text
Locked
Introduction to MongoDB Hands-on
Text
Locked
Installing MongoDB and Tools
Text
Locked
Creating Databases and Collections
Text
Locked
Inserting Documents
Text
Locked
Querying Documents
Text
Locked
Updating Documents
Text
Locked
Deleting Documents
Text
Locked
MongoDB Query Operators
Text
Locked
Sorting and Limiting Results
Text
Locked
Embedded Documents (Nested Data)
Text
Locked
Referencing Documents
Text
Locked
Indexing in MongoDB
Text
Locked
Aggregation Framework Basics
Text
Locked
Real-World E-commerce Example
Text
Locked
MongoDB vs SQL in Practice
Text
Locked
Common Mistakes in MongoDB
Text
Locked
Mini Project – Build a MongoDB App
Text
Locked
Introduction to Redis
Text
Locked
Installing Redis and Tools
Text
Locked
Basic Redis Commands
Text
Locked
Redis Data Types
Text
Locked
Expiration and TTL
Text
Locked
Using Redis for Caching
Text
Locked
Cache-Aside Pattern
Text
Locked
Redis as Session Store
Text
Locked
Redis Lists and Queues
Text
Locked
Redis Pub/Sub
Text
Locked
Redis Hashes
Text
Locked
Rate Limiting with Redis
Text
Locked
Redis vs Traditional Databases
Text
Locked
Integrating Redis with Python
Text
Locked
Real-World API Caching Example
Text
Locked
Common Redis Mistakes
Text
Locked
Mini Project – Redis Caching System
Text
Locked
What is an ORM? (Revisited)
Text
Locked
Why ORMs Matter in Production Backends
Text
Locked
Installing SQLAlchemy
Text
Locked
Creating a Database Connection
Text
Locked
Defining Models with SQLAlchemy
Text
Locked
Creating Tables from Models
Text
Locked
Working with Sessions
Text
Locked
Insert Data with ORM
Text
Locked
Query Data with ORM
Text
Locked
Update Data with ORM
Text
Locked
Delete Data with ORM
Text
Locked
Relationships in SQLAlchemy
Text
Locked
One-to-Many Relationship Example
Text
Locked
ORM vs Raw SQL
Text
Locked
Integrating ORM with FastAPI
Text
Locked
Integrating ORM with Django
Text
Locked
Transactions in ORM
Text
Locked
Common ORM Mistakes
Text
Locked
Mini Project – Build an API with ORM
Text
Locked
ORM in Real-World Systems
Text
Locked
Project Overview and Requirements
Text
Locked
System Design and Architecture
Text
Locked
Database Schema Design
Text
Locked
Creating Tables and Relationships
Text
Locked
Populating Sample Data
Text
Locked
Building CRUD APIs
Text
Locked
Implementing Business Logic
Text
Locked
Using ORM in the Project
Text
Locked
Adding Redis Caching
Text
Locked
Using MongoDB (Optional Catalog Layer)
Text
Locked
Advanced Queries for Analytics
Text
Locked
Transactions in Order Processing
Text
Locked
Error Handling and Validation
Text
Locked
API Security Basics
Text
Locked
Performance Optimization
Text
Locked
Logging and Monitoring
Text
Locked
Deployment Overview
Text
Locked
Testing the System
Text
Locked
Final Project Walkthrough
Text
Locked
Portfolio and Career Guidance
Text
Locked
Final Course Recap
Text
Locked
Final Assessment Overview
Text
Locked
Multiple Choice Exam
Text
Locked
Practical SQL Exam
Text
Locked
Mini System Design Challenge
Text
Locked
Project Submission Guidelines
Text
Locked
Code Review and Best Practices
Text
Locked
Certification Criteria
Text
Locked
Building a Strong Portfolio
Text
Locked
Resume and LinkedIn Optimization
Text
Locked
Interview Preparation
Text
Locked
Real-World Career Paths
Text
Locked
Freelancing and SaaS Opportunities
Text
Locked
Advanced Learning Roadmap
Text
Locked
Common Mistakes to Avoid
Text
Locked
Industry Best Practices Recap
Text
Locked
Course Completion Message
Text
Locked
Instructor Final Message
Text
Locked
Student Feedback and Improvement
Text
Locked
Next Courses and Learning Path
Text
Locked
Master Databases & SQL: From Fundamentals to Advanced Query Design
$45.00
Not enrolled
Category
Database
Instructor
Filimon Shferaw
Lessons
20 Sections
Instructors
Meet the Instructor
No instructor information available yet.