illustration for SQL Fundamentals
pro

SQL Fundamentals

Instructor

Tyler Clark

33m closed-captioning
·
12 lessons
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
4.2
516
people completed
Published 5 years ago
|
Updated 3 years 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

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.