Skip to content
🗄️

Databases & SQL

50 lessons

Understand databases — relational models, SQL queries, joins, normalization, and NoSQL basics.

  1. 1

    Database Overview

    What a database is, why apps need one, and how relational vs NoSQL systems differ.

  2. 2

    The Relational Model

    Tables, rows, columns, keys, and the mathematical foundation of relational databases.

  3. 3

    SQL Basics

    The SQL language: statements, clauses, data types, and how to read and write queries.

  4. 4

    SELECT Queries

    Master the SELECT statement: choosing columns, limiting rows, sorting, and aliases.

  5. 5

    Filtering with WHERE

    Use the WHERE clause to filter rows with operators, AND, OR, IN, BETWEEN, and LIKE.

  6. 6

    JOINs

    Combine rows from two or more tables using INNER, LEFT, RIGHT, and FULL joins.

  7. 7

    Aggregation Functions

    Summarize data with COUNT, SUM, AVG, MIN, and MAX aggregate functions.

  8. 8

    GROUP BY and HAVING

    Group rows into buckets, aggregate each group, and filter groups with HAVING.

  9. 9

    Subqueries

    Nest queries inside queries: scalar, correlated, IN, EXISTS, and CTEs.

  10. 10

    INSERT, UPDATE, DELETE

    Modify data: insert rows, update existing rows, and delete with safety.

  11. 11

    Creating and Altering Tables

    Design tables with CREATE TABLE, modify them with ALTER TABLE, and drop safely.

  12. 12

    Constraints

    Enforce data integrity with primary keys, foreign keys, unique, check, and not-null.

  13. 13

    Indexes

    Speed up queries with indexes: B-tree, unique, composite, and when to avoid them.

  14. 14

    Table Relationships

    Model one-to-one, one-to-many, and many-to-many relationships in SQL.

  15. 15

    Normalization

    Reduce redundancy and anomalies with 1NF, 2NF, 3NF, and BCNF normal forms.

  16. 16

    Transactions

    Group multiple operations into atomic units with BEGIN, COMMIT, and ROLLBACK.

  17. 17

    ACID Properties

    Understand Atomicity, Consistency, Isolation, and Durability in database transactions.

  18. 18

    Views

    Create virtual tables with views: simplifying queries, security, and materialized views.

  19. 19

    Stored Procedures

    Write reusable server-side logic with stored procedures and functions.

  20. 20

    Triggers

    Automate actions on row changes with BEFORE, AFTER, and INSTEAD OF triggers.

  21. 21

    NoSQL Overview

    Document, key-value, wide-column, and graph databases — when to look beyond SQL.

  22. 22

    MongoDB Basics

    Work with MongoDB: collections, documents, CRUD operations, and querying.

  23. 23

    Redis Basics

    Use Redis as an in-memory key-value store: strings, lists, hashes, sets, and TTL.

  24. 24

    Database Design

    Plan a database from requirements to schema: entities, attributes, and relationships.

  25. 25

    ER Diagrams

    Visualize database design with entity-relationship diagrams and notation.

  26. 26

    Database Seeding

    Populate databases with initial and test data using seed scripts and fixtures.

  27. 27

    Database Migrations

    Evolve your schema safely with versioned, reversible migration scripts.

  28. 28

    Connection Pooling

    Manage database connections efficiently with pooling to handle concurrency.

  29. 29

    Query Optimization

    Make queries fast with EXPLAIN, indexes, selective joins, and avoiding common pitfalls.

  30. 30

    Database Security

    Protect your database: SQL injection, access control, encryption, and auditing.

  31. 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. 32

    Denormalization Strategies

    A comprehensive guide to Denormalization Strategies in database systems, covering core concepts, implementation details, and practical examples.

  33. 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. 34

    Query Execution Plans

    A comprehensive guide to Query Execution Plans in database systems, covering core concepts, implementation details, and practical examples.

  35. 35

    ACID Properties Explained

    A comprehensive guide to ACID Properties Explained in database systems, covering core concepts, implementation details, and practical examples.

  36. 36

    Transaction Isolation Levels

    A comprehensive guide to Transaction Isolation Levels in database systems, covering core concepts, implementation details, and practical examples.

  37. 37

    Deadlocks and Prevention

    A comprehensive guide to Deadlocks and Prevention in database systems, covering core concepts, implementation details, and practical examples.

  38. 38

    Connection Pooling

    A comprehensive guide to Connection Pooling in database systems, covering core concepts, implementation details, and practical examples.

  39. 39

    Stored Procedures

    A comprehensive guide to Stored Procedures in database systems, covering core concepts, implementation details, and practical examples.

  40. 40

    Database Triggers

    A comprehensive guide to Database Triggers in database systems, covering core concepts, implementation details, and practical examples.

  41. 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. 42

    Table Partitioning

    A comprehensive guide to Table Partitioning in database systems, covering core concepts, implementation details, and practical examples.

  43. 43

    Database Sharding

    A comprehensive guide to Database Sharding in database systems, covering core concepts, implementation details, and practical examples.

  44. 44

    Replication Strategies

    A comprehensive guide to Replication Strategies in database systems, covering core concepts, implementation details, and practical examples.

  45. 45

    Backup and Recovery

    A comprehensive guide to Backup and Recovery in database systems, covering core concepts, implementation details, and practical examples.

  46. 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. 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. 48

    Database Migrations

    A comprehensive guide to Database Migrations in database systems, covering core concepts, implementation details, and practical examples.

  49. 49

    Full-Text Search

    A comprehensive guide to Full-Text Search in database systems, covering core concepts, implementation details, and practical examples.

  50. 50

    Time-Series Data Modeling

    A comprehensive guide to Time-Series Data Modeling in database systems, covering core concepts, implementation details, and practical examples.

Completed: 0 / 500%

Learning Stages

Est. total: 14h 25m
  1. 1

    Foundation

    13 lessons · 2h 10m

    Build a solid foundation with the essential concepts and syntax.

    0/13
  2. Core

    13 lessons · 3h 15m

    Deepen your understanding with core patterns and common use cases.

    0/13
  3. Intermediate

    12 lessons · 4h

    Tackle intermediate topics and start combining concepts fluently.

    0/12
  4. Advanced

    12 lessons · 5h

    Master 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.

Overall0%
  • Lessons0 / 200%
  • Exercises0 / 1000%
  • Projects0 / 100%

Skill Assessment

0 / 20 mastered
0 mastered0 in progress20 not started
  • Relational ModelFoundation
    0 / 4 lessons · 0%
  • SQL QueriesCore
    0 / 4 lessons · 0%
  • Joins & AggregationsCore
    0 / 4 lessons · 0%
  • Schema DesignIntermediate
    0 / 5 lessons · 0%
  • Transactions & ACIDIntermediate
    0 / 3 lessons · 0%
  • Query OptimizationAdvanced
    0 / 4 lessons · 0%
  • NoSQL DatabasesIntermediate
    0 / 3 lessons · 0%
  • Advanced Database TopicsAdvanced
    0 / 4 lessons · 0%

+12 more skills

Recommended next: database-overview
20 remaining

Build real projects

Apply what you learned by building guided projects with starter code and solutions.

View projects

Decode error messages

Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.

View errors