Open navigation menu
← All Learning Paths

SQL & Databases

A thorough SQL and databases learning path covering queries, joins, indexing, transactions, normalization, NoSQL, and performance tuning for effective data management and analysis.

technicalbeginner12 nodes90h total
  1. 1

    SQL Fundamentals

    Master SELECT, WHERE, ORDER BY, and basic queries

    Completion criteria: Write basic SQL queries to retrieve and filter data

    Next step: Learn joins and subqueries

    ⏱ 8h

  2. 2

    Joins and Subqueries

    Master INNER, LEFT, RIGHT joins and subqueries

    Prerequisites: sq-01

    Completion criteria: Write complex queries joining multiple tables

    Next step: Study aggregation and grouping

    ⏱ 10h

  3. 3

    Aggregation and Grouping

    Use GROUP BY, HAVING, and aggregate functions

    Prerequisites: sq-02

    Completion criteria: Build analytical queries with aggregation

    Next step: Learn window functions

    ⏱ 8h

  4. 4

    Window Functions and CTEs

    Master window functions, RANK, and common table expressions

    Prerequisites: sq-03

    Completion criteria: Write advanced analytical queries with window functions

    Next step: Study database design

    ⏱ 10h

  5. 5

    Database Design and Normalization

    Design normalized schemas with proper keys and constraints

    Prerequisites: sq-04

    Completion criteria: Design a normalized database schema for a real domain

    Next step: Learn indexing

    ⏱ 10h

  6. 6

    Indexing and Query Optimization

    Create effective indexes and analyze query plans

    Prerequisites: sq-05

    Completion criteria: Optimize slow queries using indexes and EXPLAIN

    Next step: Study transactions and ACID

    ⏱ 10h

  7. 7

    Transactions and ACID Properties

    Master transactions, isolation levels, and concurrency control

    Prerequisites: sq-06

    Completion criteria: Implement transaction handling with proper isolation

    Next step: Learn stored procedures

    ⏱ 8h

  8. 8

    Stored Procedures and Functions

    Write stored procedures, functions, and triggers

    Prerequisites: sq-07

    Completion criteria: Create stored procedures for business logic

    Next step: Study PostgreSQL specifics

    ⏱ 8h

  9. 9

    PostgreSQL Advanced Features

    Master PostgreSQL-specific features like JSONB and full-text search

    Prerequisites: sq-08

    Completion criteria: Use PostgreSQL advanced features in a real project

    Next step: Learn NoSQL databases

    ⏱ 8h

  10. 10

    NoSQL Databases

    Understand MongoDB, Redis, and when to use NoSQL

    Prerequisites: sq-09

    Completion criteria: Build a data layer using an appropriate NoSQL database

    Next step: Study database security

    ⏱ 8h

  11. 11

    Database Security and Backup

    Implement database security, backup, and recovery procedures

    Prerequisites: sq-10

    Completion criteria: Set up secure database with backup strategy

    Next step: Build a capstone SQL project

    ⏱ 6h

  12. 12

    Capstone SQL Project

    Design and implement a complete database solution

    Prerequisites: sq-11

    Completion criteria: Deliver a designed, optimized, and documented database

    Next step: Explore data warehousing and database administration

    ⏱ 6h