Complete Intro to SQL & PostgreSQL

Brian Holt
Microsoft
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.

Preview
4.9 rating
Really great course, as always! I wanted to take it to get familiar with SQL and I'd say I got much more out of the course, it did exceed my expectations. Loved the practical examples along with all the new concepts, also was great to play around a bit in a NodeJS app to see how all of these concepts look like when you develop an app. I feel like this was foundation course for me to take, as I've been working on web apps for 8 years with only dabbling, and frankly, afraid of DBs. Now I feel well equipped to go build the things which I procrastinated on due to being afraid of SQL and everything near DBs. Thanks to Brian Holt and the entire Master.dev team for another great course, you are doing wonderful educational work.

Course Details

Published: October 3, 2022

Rating

4.9

Learn Straight from the Experts Who Shape the Modern Web

Your Path to Senior Developer and Beyond
  • 300+ In-depth courses
  • 24 Learning Paths
  • Industry Leading Experts
  • Live Interactive Workshops

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