jcg
Database structure design? It’s here. Query tuning and optimization? You’ll master it. Complex queries? Yes indeed!
This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!
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 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 to several approaches.
Specification: SQL and PostgreSQL: The Complete Developer’s Guide
|
8 reviews for SQL and PostgreSQL: The Complete Developer’s Guide
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 22 hours |
| Year | 2022 |
| Level | Beginner |
| Language | English ... |
| Certificate | Yes |
| Quizzes | Yes |
$13.99
Mike Futala –
Always learn new and interesting information from Stephen.
Thomas –
Most parts unnecessary long. I feel like wasting my time. I tried to get a refund. But I couldn’t get a refund. It said I watched too long. I purchased this 2 days ago. I watched 9 Sections.
Pham Anh Tuan –
ok
Adrian Surani –
I was expecting a bit more of a technical deep dive into performance.
Ronald Kurr –
Lots of good information. Being a JVM developer, the JS stuff was less interesting but showed some of the book keeping necessary for programmatic access. I wished the advanced section covered JSON support, especially how expensive the operators are when compared against normal joins and SELECTs.
Raymond Koziel –
Stephen covers an incredible amount of material about Postgres, including how to call Postgres via APIs. His usage of diagrams to explain concepts and the internals of Postgres helps makes things easier to understand.
Oleg Yuzvik –
I took this course to fill in the large gaps in my SQL / Postgres knowledge and I am glad I did! The course material is of a very high quality and Stephen is a truly great instructor that really makes his best to clearly explain things!
Campbell Padgett –
Stephen is an excellent communicator and gives perfect examples and exercises to understand the content