illustration for Get Started With PostgreSQL

Get Started With PostgreSQL

Instructor

Brett Cassette
41m
Updated:
4 years ago
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
4.3
536
people completed
Bookmark
Download
RSS

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 Gutierrez
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What 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 Gutierrez
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What 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.

  • Learner
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What was your strongest take away from this course?

    good overview of ways to interact with data in postgres.

  • Mario Andres
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What did you like about this course?

    Straight to the point. It was easy to follow with a basic understanding of SQL

  • Kyle Redding
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What was your strongest take away from this course?

    Pretty basic sql course. Only useful if you have never seen sql before.

  • Dan DeWald
    2 years ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    How 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

41m • 14 lessons

    You might also like these courses:

    illustration for Introduction to Cloudflare Workers

    Introduction to Cloudflare Workers

    Kristian Freeman・36m・Course

    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.

    illustration for Create an eCommerce Store with Next.js and Stripe Checkout

    Create an eCommerce Store with Next.js and Stripe Checkout

    Colby Fayock・1h 4m・Course

    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

    illustration for Practical Git for Everyday Professional Use

    Practical Git for Everyday Professional Use

    Trevor Miller・1h・Course

    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.