SQL Fundamentals

ClockIcon33m
postgresPostgreSQL
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
Star icon$$$
4.2
283 people completed
Tyler Clark
By

Tyler Clark

Full-Stack Dev with a Front-end Focus, Dad, Husband, Tech Blogger, Speaker, and Teacher, Sports Fanatic

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.

What you'll learn

  • CheckIconTables and table relationships
  • CheckIconConditional selection
  • CheckIconData integrity and data types
  • CheckIconAggregate functions
  • CheckIconSubqueries
  • CheckIconAnd more...!

Prerequisites

  • ChevronRightIcon

    SQL beginners welcome!

  • ChevronRightIcon

    Some command line and terminal experience will be helpful

Tyler Clark
By

Tyler Clark

Full-Stack Dev with a Front-end Focus, Dad, Husband, Tech Blogger, Speaker, and Teacher, Sports Fanatic