SQL Fundamentals
Instructor
Tyler Clark
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.
Credits
Maxime Bourgeois (illustration)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 Rao4 years agoWhat 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 Torres4 years agoWhat would make this collection a 7 for you?
Great introduction. Looking forward for the advanced course.
- Nick4 years agoWhat would make this course a 7 for you?
Quick, short intro to SQL fundamentals
- Marcell Ciszek4 years agoWhat 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ín4 years agoWhat did you like about this course?
Clear and simple, and the most advanced topics have a really simple and clear explanation.
- Paul Gerhartz5 years agoHow 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
- 12
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.