Complete Intro to SQL & PostgreSQL

Complete Intro to SQL & PostgreSQL

Learning Paths:
7 hours, 20 minutes CC

SQL is a timeless skillset you'll find in nearly every modern application! Using the popular PostgreSQL database, you'll learn to set up, model, and query your data through real-world projects. You'll also understand how to model complex relationships in your data and query data from large datasets.

This course and others like it are available as part of our Frontend Masters video subscription.

Published: October 3, 2022
Get Unlimited Access Now
Table of Contents

Introduction

Databases and Tables

SQL Commands

Joins and Constraints

JSONB

Aggregation

Functions Triggers and Procedures

The Movie Database

Query Performance

Views, Subqueries & Arrays

Transactions, Window Functions, and Self Join

Wrapping Up