Databases & SQL
50 lessons
Understand databases — relational models, SQL queries, joins, normalization, and NoSQL basics.
-
1 Database Overview
What a database is, why apps need one, and how relational vs NoSQL systems differ.
-
2 The Relational Model
Tables, rows, columns, keys, and the mathematical foundation of relational databases.
-
3 SQL Basics
The SQL language: statements, clauses, data types, and how to read and write queries.
-
4 SELECT Queries
Master the SELECT statement: choosing columns, limiting rows, sorting, and aliases.
-
5 Filtering with WHERE
Use the WHERE clause to filter rows with operators, AND, OR, IN, BETWEEN, and LIKE.
-
6 JOINs
Combine rows from two or more tables using INNER, LEFT, RIGHT, and FULL joins.
-
7 Aggregation Functions
Summarize data with COUNT, SUM, AVG, MIN, and MAX aggregate functions.
-
8 GROUP BY and HAVING
Group rows into buckets, aggregate each group, and filter groups with HAVING.
-
9 Subqueries
Nest queries inside queries: scalar, correlated, IN, EXISTS, and CTEs.
-
10 INSERT, UPDATE, DELETE
Modify data: insert rows, update existing rows, and delete with safety.
-
11 Creating and Altering Tables
Design tables with CREATE TABLE, modify them with ALTER TABLE, and drop safely.
-
12 Constraints
Enforce data integrity with primary keys, foreign keys, unique, check, and not-null.
-
13 Indexes
Speed up queries with indexes: B-tree, unique, composite, and when to avoid them.
-
14 Table Relationships
Model one-to-one, one-to-many, and many-to-many relationships in SQL.
-
15 Normalization
Reduce redundancy and anomalies with 1NF, 2NF, 3NF, and BCNF normal forms.
-
16 Transactions
Group multiple operations into atomic units with BEGIN, COMMIT, and ROLLBACK.
-
17 ACID Properties
Understand Atomicity, Consistency, Isolation, and Durability in database transactions.
-
18 Views
Create virtual tables with views: simplifying queries, security, and materialized views.
-
19 Stored Procedures
Write reusable server-side logic with stored procedures and functions.
-
20 Triggers
Automate actions on row changes with BEFORE, AFTER, and INSTEAD OF triggers.
-
21 NoSQL Overview
Document, key-value, wide-column, and graph databases — when to look beyond SQL.
-
22 MongoDB Basics
Work with MongoDB: collections, documents, CRUD operations, and querying.
-
23 Redis Basics
Use Redis as an in-memory key-value store: strings, lists, hashes, sets, and TTL.
-
24 Database Design
Plan a database from requirements to schema: entities, attributes, and relationships.
-
25 ER Diagrams
Visualize database design with entity-relationship diagrams and notation.
-
26 Database Seeding
Populate databases with initial and test data using seed scripts and fixtures.
-
27 Database Migrations
Evolve your schema safely with versioned, reversible migration scripts.
-
28 Connection Pooling
Manage database connections efficiently with pooling to handle concurrency.
-
29 Query Optimization
Make queries fast with EXPLAIN, indexes, selective joins, and avoiding common pitfalls.
-
30 Database Security
Protect your database: SQL injection, access control, encryption, and auditing.
-
31 Normalization Forms 1NF to BCNF
A comprehensive guide to Normalization Forms 1NF to BCNF in database systems, covering core concepts, implementation details, and practical examples.
-
32 Denormalization Strategies
A comprehensive guide to Denormalization Strategies in database systems, covering core concepts, implementation details, and practical examples.
-
33 Index Optimization and Selection
A comprehensive guide to Index Optimization and Selection in database systems, covering core concepts, implementation details, and practical examples.
-
34 Query Execution Plans
A comprehensive guide to Query Execution Plans in database systems, covering core concepts, implementation details, and practical examples.
-
35 ACID Properties Explained
A comprehensive guide to ACID Properties Explained in database systems, covering core concepts, implementation details, and practical examples.
-
36 Transaction Isolation Levels
A comprehensive guide to Transaction Isolation Levels in database systems, covering core concepts, implementation details, and practical examples.
-
37 Deadlocks and Prevention
A comprehensive guide to Deadlocks and Prevention in database systems, covering core concepts, implementation details, and practical examples.
-
38 Connection Pooling
A comprehensive guide to Connection Pooling in database systems, covering core concepts, implementation details, and practical examples.
-
39 Stored Procedures
A comprehensive guide to Stored Procedures in database systems, covering core concepts, implementation details, and practical examples.
-
40 Database Triggers
A comprehensive guide to Database Triggers in database systems, covering core concepts, implementation details, and practical examples.
-
41 Views and Materialized Views
A comprehensive guide to Views and Materialized Views in database systems, covering core concepts, implementation details, and practical examples.
-
42 Table Partitioning
A comprehensive guide to Table Partitioning in database systems, covering core concepts, implementation details, and practical examples.
-
43 Database Sharding
A comprehensive guide to Database Sharding in database systems, covering core concepts, implementation details, and practical examples.
-
44 Replication Strategies
A comprehensive guide to Replication Strategies in database systems, covering core concepts, implementation details, and practical examples.
-
45 Backup and Recovery
A comprehensive guide to Backup and Recovery in database systems, covering core concepts, implementation details, and practical examples.
-
46 N Plus 1 Query Problem
A comprehensive guide to N Plus 1 Query Problem in database systems, covering core concepts, implementation details, and practical examples.
-
47 ORMs vs Query Builders
A comprehensive guide to ORMs vs Query Builders in database systems, covering core concepts, implementation details, and practical examples.
-
48 Database Migrations
A comprehensive guide to Database Migrations in database systems, covering core concepts, implementation details, and practical examples.
-
49 Full-Text Search
A comprehensive guide to Full-Text Search in database systems, covering core concepts, implementation details, and practical examples.
-
50 Time-Series Data Modeling
A comprehensive guide to Time-Series Data Modeling in database systems, covering core concepts, implementation details, and practical examples.
Learning Stages
Est. total: 14h 25m- 1
Foundation
13 lessons · 2h 10mBuild a solid foundation with the essential concepts and syntax.
0/13 Core
13 lessons · 3h 15mDeepen your understanding with core patterns and common use cases.
0/13Intermediate
12 lessons · 4hTackle intermediate topics and start combining concepts fluently.
0/12Advanced
12 lessons · 5hMaster advanced techniques and apply them to real-world problems.
0/12
Completion Standard
Complete 80% lessons, 60% exercises, and 50% projects to master this topic.
- Lessons0 / 200%
- Exercises0 / 1000%
- Projects0 / 100%
Skill Assessment
0 / 20 mastered- Relational ModelFoundation0 / 4 lessons · 0%
- SQL QueriesCore0 / 4 lessons · 0%
- Joins & AggregationsCore0 / 4 lessons · 0%
- Schema DesignIntermediate0 / 5 lessons · 0%
- Transactions & ACIDIntermediate0 / 3 lessons · 0%
- Query OptimizationAdvanced0 / 4 lessons · 0%
- NoSQL DatabasesIntermediate0 / 3 lessons · 0%
- Advanced Database TopicsAdvanced0 / 4 lessons · 0%
+12 more skills
Build real projects
Apply what you learned by building guided projects with starter code and solutions.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.