Complete Intro to SQL

Watch on Frontend Masters

Complete Intro to SQL

and PostgreSQL

author image
Brian Holt
Stripe
course icon
Watch on Frontend Masters

Table of Contents

  1. Welcome

    1. Introduction
    2. Docker

  2. Databases and Tables

    1. Databases
    2. Tables

  3. Data

    1. Inserts
    2. Updates and Deletes
    3. Selects
    4. Like and Functions
    5. Node.js and PostgreSQL
    6. Project

  4. Joins and Constraints

    1. Relationships
    2. Other Types of Joins
    3. Foreign Keys
    4. Many-to-Many Relationships
    5. Constraints
    6. Project

  5. JSONB

    1. Unstructured Data
    2. JSONB
    3. When to Use

  6. Aggregation

    1. Aggregation
    2. HAVING

  7. Functions Triggers and Procedures

    1. Functions
    2. Procedures
    3. Triggers

  8. The Movie Database

    1. Exercises
    2. Answers
    3. pgAdmin

  9. Query Performance

    1. Explain
    2. Indexes
    3. Create an Index
    4. GIN
    5. Partial Indexes
    6. Derivative Value Indexes

  10. Views

    1. Basic Views
    2. Materialized Views

  11. Subqueries

    1. How to Subquery
    2. Arrays

  12. Transactions

    1. Transactions

  13. Window Functions

    1. Window Functions

  14. Self Join

    1. Self Join

  15. Conclusion

    1. Congrats
    2. Project