SQL Fundamentals
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.
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
- 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!
Ravindra Rao4 years ago - What would make this collection a 7 for you?
Great introduction. Looking forward for the advanced course.
Jose Torres5 years ago - What would make this course a 7 for you?
Quick, short intro to SQL fundamentals
Nick5 years ago - 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.
Marcell Ciszek5 years ago - What did you like about this course?
Clear and simple, and the most advanced topics have a really simple and clear explanation.
Ismael Marín5 years ago - 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.
Paul Gerhartz5 years ago
Credits
Maxime BourgeoisCourse Content
- 12
