Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Frontend Masters

Complete Intro to SQL & PostgreSQL

via Frontend Masters

Go to class Write review
Simplilearn Ad

Pass the PMP® Exam on Your First Try — Expert-Led Training

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.

Syllabus

  • Introduction
  • SQL Setup with Docker
  • SQL Overview & Creating a Database
  • Creating & Populating a Table
  • Altering a Table & Postgres Data Types
  • Inserting Data and Managing Conflicts
  • Updating & Deleting Data
  • Selecting, Paginating, & Using Where Clauses
  • Using LIKE, ILIKE, & SQL Functions
  • node-postgres & SQL Injection
  • Ingredients API Exercise
  • Ingredients API Solution
  • Understanding Relationships & Joins
  • Left, Right, & Outer Joins
  • Natural & Cross Joins
  • Foreign Keys & Managing References
  • Many-to-Many Relationships
  • Using the CHECK Constraint
  • Using the DISTINCT Statement
  • Recipes Exercise
  • Recipes Solution
  • JSON vs. JSONB
  • Adding JSONB to Recipes Table
  • When to Use JSONB
  • Understanding Aggregation
  • Filtering Aggregates with HAVING
  • Storing Queries with Functions
  • Functions vs. Procedures
  • Calling Functions with Triggers
  • The Movie Database Setup
  • The Movie Database Exercise
  • The Movie Database Solution: Most Money
  • The Movie Database Solution: Keanu Reeves
  • The Movie Database Solution: Most Revenue
  • The Movie Database Solution: Most Keywords
  • The Movie Database Solution: Most Movies
  • Setup pgAdmin
  • Analyzing Queries with EXPLAIN
  • Identifying what to Index
  • Creating an Index
  • Using a GIN Index
  • Creating a Partial Index
  • Indexing a Derivative Value
  • Creating Views & Inserting Data
  • Joining Between Views
  • Optimizing Queries with Materialized Views
  • Indexing Materialized Views
  • Using Subqueries
  • Creating an Array from a Subquery
  • Transactions
  • Window Functions
  • Self Join
  • Wrapping Up

Taught by

Brian Holt

Reviews

Start your review of Complete Intro to SQL & PostgreSQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.