illustration for SQL Fundamentals
pro

SQL Fundamentals

Instructor

Tyler Clark
33m closed-captioning
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
4.2
515
people completed
Published 3 years ago
|
Updated 9 months ago

Most applications rely on databases to store data. Understanding how to create a database and communicate with it unlocks a critical power in your web development career.

In this course, Tyler presents all the building blocks of creating and interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.

After completing this course, you’ll be ready to tackle more challenging SQL topics like proper data modeling, normalizing data, and exploring different database types.

Check out the Community Notes for this course.

What you'll learn:

  • Tables and table relationships
  • Conditional selection
  • Data integrity and data types
  • Aggregate functions
  • Subqueries
  • And more...!

Prerequisites:

  • SQL beginners welcome!
  • Some command line and terminal experience will be helpful

Learner Reviews

  • Ravindra Rao
    10 months ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What did you like about this course?

    Very useful introduction/refresher for PostgreSQL queries. It has refreshed my understanding of SQL queries and also got me started on Postgres. Thank you!

  • Jose Torres
    a year ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What would make this collection a 7 for you?

    Great introduction. Looking forward for the advanced course.

  • Nick
    a year ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What would make this course a 7 for you?

    Quick, short intro to SQL fundamentals

  • Marcell Ciszek
    a year ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What did you like about this course?

    Thank you, Tyler, you're really explaining things so well, and a big plus for all those hand out and exercises, this helped me a lot.

  • Ismael Marín
    a year ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    What did you like about this course?

    Clear and simple, and the most advanced topics have a really simple and clear explanation.

  • Paul Gerhartz
    a year ago
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    Star icon$$$
    How will you use what you learned from this course?

    I took a Database/SQL course a few years back and this was an excellent refresher. Thank you!

    I wish there was a little more time to view the code as you are typing. I found myself not being able to read fast enough before you would hit enter or move onto the next bit of code.

    Thank you for making this course! Well done.

Course Content

33m • 12 lessons

    You might also like these resources:

    illustration for 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
    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
    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.