Pebellslearn by building
RoadmapMatrixCatalogSandboxSign in

SQL

Outline

16 topics and 94 subtopics mapped. This is the ground the track will cover — the lessons aren't written yet.

  1. 01

    Learn the Basics

    1 subtopic
    • SQL vs NoSQL Databases
  2. 02

    Basic SQL Syntax

    7 subtopics
    • SQL Keywords
    • Data Types
    • Operators
    • SELECT
    • INSERT
    • UPDATE
    • DELETE
  3. 03

    Data Definition Language (DDL)

    4 subtopics
    • Truncate Table
    • Alter Table
    • Create Table
    • Drop Table
  4. 04

    Data Manipulation Language (DML)

    10 subtopics
    • Select
    • FROM
    • WHERE
    • ORDER BY
    • GROUP BY
    • HAVING
    • JOINs
    • INSERT
    • UPDATE
    • DELETE
  5. 05

    Aggregate Queries

    7 subtopics
    • SUM
    • COUNT
    • AVG
    • MIN
    • MAX
    • GROUP BY
    • HAVING
  6. 06

    Data Constraints

    5 subtopics
    • Primary Key
    • Foreign Key
    • Unique
    • NOT NULL
    • CHECK
  7. 07

    JOIN Queries

    6 subtopics
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL OUTER JOIN
    • Self Join
    • Cross Join
  8. 08

    Subqueries

    6 subtopics
    • Scalar
    • Column
    • Row
    • Table
    • Nested Subqueries
    • Correlated Subqueries
  9. 09

    Advanced Functions

    19 subtopics
    • FLOOR
    • ABS
    • MOD
    • ROUND
    • CEILING
    • CONCAT
    • LENGTH
    • SUBSTRING
    • REPLACE
    • UPPER
    • LOWER
    • CASE
    • NULLIF
    • COALESCE
    • DATE
    • TIME
    • TIMESTAMP
    • DATEPART
    • DATEADD
  10. 10

    Views

    3 subtopics
    • Creating Views
    • Modifying Views
    • Dropping Views
  11. 11

    Indexes

    2 subtopics
    • Managing Indexes
    • Query Optimization
  12. 12

    Transactions

    6 subtopics
    • BEGIN
    • COMMIT
    • ROLLBACK
    • SAVEPOINT
    • ACID
    • Transaction Isolation Levels
  13. 13

    Data Integrity & Security

    3 subtopics
    • Data Integrity Constraints
    • GRANT and Revoke
    • DB Security Best Practices
  14. 14

    Stored Procedures & Functions

  15. 15

    Performance Optimization

    5 subtopics
    • Using Indexes
    • Optimizing Joins
    • Reducing Subqueries
    • Selective Projection
    • Query Analysis Techniques
  16. 16

    Advanced SQL

    10 subtopics
    • Recursive Queries
    • Pivot / Unpivot Operations
    • Window Functions
    • Common Table Expressions
    • Dynamic SQL
    • Row_number
    • rank
    • dense_rank
    • lead
    • lag