Every app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database. Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems. This course will teach you everything you need to know about SQL and PostgreSQL to use it on your next big project!
Don’t know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you’ll get practical, hands-on experience working with realistic datasets. You will understand how to store, fetch, and update information with a series of powerful commands.
After gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. You’ll see many different scenarios with different types of data, and understand the pros and cons of several approaches.
This course is packed with practice exercises and quizzes. You’ll get immediate practice on all of the different topics and features that you learn! In addition, you’ll understand exactly where to use each of these features in real and practical projects.
Besides getting practical hands-on experience, you’ll also get a behind-the-scenes look at how PostgreSQL works internally. We’ll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit. This knowledge is invaluable when it comes time to start tuning your queries for performance. By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database.
Here is a partial list of some of the topics that are covered in this course:
