Get Started With PostgreSQL
Instructor
Brett Cassette
It’s amazing how much you can accomplish with a basic knowledge of SQL. In this course we’ll learn how to store lots of information (many millions of things!) and answer nearly any question we might have about that information (on the order of milliseconds!)
We’ll learn enough to make you say you “know SQL” -- table creation, inserts, selects, updates, deletes, aggregations, indexes, joins, and constraints. Along the way we’ll model real world problems so that you can see just how powerful SQL will make you!
If you’re interested in the Postgres client that is used in this course you can download it here to check it out and follow along.
Learner Reviews
- Miguel Romero Gutierrez5 years agoWhat did you like about this course?
Excellent explanation about sql basic concepts. I really appreciate this course there was a time that i used a data base but now i have to. It will be great if you would do a course about good practices at time to planning the data base schema.
- Miguel Romero Gutierrez5 years agoWhat did you like about this course?
Excellent explanation about sql basic concepts. I really appreciate this course there was a time that i used a data base but now i have to. It will be great if you would do a course about good practices at time to planning the data base schema.
- Learner5 years agoWhat was your strongest take away from this course?
good overview of ways to interact with data in postgres.
- Mario Andres6 years agoWhat did you like about this course?
Straight to the point. It was easy to follow with a basic understanding of SQL
- Kyle Redding6 years agoWhat was your strongest take away from this course?
Pretty basic sql course. Only useful if you have never seen sql before.
- Dan DeWald6 years agoHow will you use what you learned from this course?
Just starting a new job that uses Postgres and it's been years since I did backend, so I was just looking for a bit of a refresher. What's most useful is having access to the Postgres client and dataset, which I will go back and use. Brett moves too quickly for someone who is trying to learn Postgres for the first time. At least two chapters before the current chapter 1 should be included to introduce the viewer to database basics and should walk the viewer through the creation of the directory system used in the PG client.
Course Content
- 11m 45s
- 41m 55s
- 52m 43s
- 71m 20s
You might also like these resources:
Introduction to Cloudflare Workers
Become familiar with the Workers CLI wrangler that we will use to bootstrap our Worker project. From there you'll understand how a Worker receives and returns requests/Responses. We will also build this serverless function locally for development and deploy it to a custom domain.
Create an eCommerce Store with Next.js and Stripe Checkout
This is a practical project based look at building a working e-commerce store using modern tools and APIs. Excellent for a weekend side-project for your developer project portfolio
Practical Git for Everyday Professional Use
git is a critical component in the modern web developers tool box. This course is a solid introduction and goes beyond the basics with some more advanced git commands you are sure to find useful.