Advanced
205 Lessons
65h
Certificate of Completion
AI-POWERED
AI-POWERED
This course includes
This course includes
Course Overview
PostgreSQL is a popular and widely used open-source relational database management system. It has gained significant market share in recent years due to its robust features, high performance, and ease of use. Many companies, from small startups to large enterprises, are adopting PostgreSQL as their primary database system, making it a sought-after skill for developers. You will learn PostgreSQL with numerous code examples using different approaches. This course will enable you to seamlessly integrate SQL ...Show More
What You'll Learn
An understanding of PostgreSQL and its applications in managing databases with CRUD operations
Familiarity with the core components of PostgreSQL, such as SQL, REPL, Window functions, and data modeling
Hands-on experience in using SQL queries with PostgreSQL and its extensions
The ability to write and integrate SQL queries into your workflow, enabling efficient data retrieval and manipulation
What You'll Learn
An understanding of PostgreSQL and its applications in managing databases with CRUD operations
See more
Course Content
Part I: Preface
Introduction to PostgreSQL
Part II: Introduction to Structured Query Language
Part III: Writing SQL Queries
Business Logic
A Small Application
5 Lessons
The SQL REPL: An Interactive Setup
8 Lessons
Indexing in PostgreSQL
4 Lessons
Part IV: SQL Toolbox
1 Lesson
SQL Tools
4 Lessons
Managing Output in SQL
9 Lessons
Understanding Nulls
6 Lessons
Window Functions
3 Lessons
Relations and Joins
3 Lessons
Part V: Data Types
1 Lesson
Serialization and Deserialization
6 Lessons
PostgreSQL Data Types 101
12 Lessons
Denormalized Data Types
9 Lessons
Part VI: Data Modeling
1 Lesson
Object Relational Mapping and Tooling for Database Modeling
5 Lessons
Normalization
5 Lessons
Practical Use Case: Geonames
9 Lessons
Modelization Anti-Patterns
4 Lessons
Denormalization
10 Lessons
Not Only SQL
5 Lessons
Part VII: Data Manipulation and Concurrency Control
1 Lesson
Another Small Application
6 Lessons
Isolation and Locking
5 Lessons
Computing and Caching in SQL
6 Lessons
Triggers
4 Lessons
Listen and Notify
4 Lessons
Batch Update, MoMA Collection
4 Lessons
Part VIII: PostgreSQL Extensions
1 Lesson
What’s a PostgreSQL Extension?
3 Lessons
Auditing Changes with hstore
5 Lessons
Million Song Dataset
2 Lessons
Using Trigrams for Typos
6 Lessons
Denormalizing Tags with intarray
3 Lessons
The Most Popular Pub Names
5 Lessons
Geolocation with PostgreSQL
6 Lessons
Counting Distinct Users with HyperLogLog
6 Lessons
Appendix
3 Lessons
Course Author
Trusted by 1.4 million developers working at companies
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
Evan Dunbar
ML Engineer
Carlos Matias La Borde
Software Developer
Souvik Kundu
Front-end Developer
Vinay Krishnaiah
Software Developer
Eric Downs
Musician/Entrepeneur
Kenan Eyvazov
DevOps Engineer
Anthony Walker
@_webarchitect_
Emma Bostian 🐞
@EmmaBostian
See how Educative uses AI to make your learning more immersive than ever before.
Instant Code Feedback
AI-Powered Mock Interviews
Adaptive Learning
Explain with AI
AI Code Mentor