Complete Intro to SQL & PostgreSQL

Brian Holt

Brian Holt

SQLite Cloud
7 hours, 20 minutes CC
Complete Intro to SQL & PostgreSQL

Course Description

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.

Preview
Close

Course Details

Published: October 3, 2022

Learning Paths

Learn Straight from the Experts Who Shape the Modern Web

Your Path to Senior Developer and Beyond
  • 200+ In-depth courses
  • 18 Learning Paths
  • Industry Leading Experts
  • Live Interactive Workshops
Get Unlimited Access Now

Table of Contents

Introduction

Section Duration: 20 minutes

Databases and Tables

Section Duration: 34 minutes

SQL Commands

Section Duration: 1 hour, 15 minutes

Joins and Constraints

Section Duration: 1 hour, 14 minutes

JSONB

Section Duration: 25 minutes

Aggregation

Section Duration: 12 minutes
  • Understanding Aggregation
    Brian demonstrates the COUNT aggregation function. Rather than return rows of results, the COUNT function can be used to total the number of rows returned by a query or total the number of occurrences of a value in a specific column. Combining COUNT with the GROUP BY clause allows the sum to be displayed along with the specific value.
  • Filtering Aggregates with HAVING
    Brian explains how WHERE clauses are executed before aggregate functions. This means WHERE clauses cannot be used to filter aggregated results. The HAVING statement behaves like a WHERE clause, but is executed after the aggregation has occurred. This enables a filter to be applied to the returned data.

Functions Triggers and Procedures

Section Duration: 30 minutes

The Movie Database

Section Duration: 46 minutes

Query Performance

Section Duration: 49 minutes

Views, Subqueries & Arrays

Section Duration: 38 minutes

Transactions, Window Functions, and Self Join

Section Duration: 28 minutes
  • Transactions
    Brian demonstrates how transactions ensure multiple queries run successfully before committing the changes to the database. If any of the queries within the transaction fail, the changes are rolled back. Using functions within a transaction is also demonstrated in this lesson.
  • Window Functions
    Brian explains window function performs a calculation across a set of table rows that are related to the current row. This is comparable to the type of calculation that can be done with an aggregate function. But unlike regular aggregate functions, the use of a window function does not cause rows to become grouped into a single output row.
  • Self Join
    Brian demonstrates how to create a self join by joining a table to itself.

Wrapping Up

Section Duration: 3 minutes
  • Wrapping Up
    Brian concludes the course by explaining how knowledge about SQL translates to other areas of development and providing some resources for using the movie database to create a project website.
I just completed "Complete Intro to SQL & PostgreSQL" by Brian Holt on Frontend Masters! Excellent course, I learned a ton ✨
Cinder | シンダー

Cinder | シンダー

cinderscorner

I just completed "Complete Intro to SQL & PostgreSQL" by Briant Holt on Frontend Masters! A great refresher course for Postgres and lay down the foundation for ORM.
Connie Leung

Connie Leung

connieleung404

Learn Straight from the Experts Who Shape the Modern Web

  • In-depth Courses
  • Industry Leading Experts
  • Learning Paths
  • Live Interactive Workshops
Get Unlimited Access Now