About this course
Learn how to optimize your Postgres databases with our Optimizing Postgres Databases for Data Engineering.
In this course, you’ll explore Postgres Internals to discover how Postgres manages meta information about databases and tables. Along with discovering how Postgres manages its metadata, you’ll also discover what a Postgres is and how to create a description of a database. You’ll also learn how to debug your Postgres queries using the EXPLAIN clause.
You’ll also learn how to measure estimated and actual execution times of your queries and find out which SQL clause is the most computationally expensive to perform and biggest cause for long-running queries.
In addition to learning Postgres’ internal and how to debug Postgres queries, you’ll learn such concepts such as indexing and how indexing can greatly reduce querying speed. You will learn some advanced features of indexes such as multi-index, ordered index, and more.
You’ll also learn what it means to vacuum a Postgres database, how it reduces query speeds and how to vacuum a database, and what ACID means for database transactions and why it’s important for transaction blocks.
By the end of this course, you’ll be able to:
- Understand how to debug Postgres queries and find bottlenecks.
- Use indexes to speed up Postgres query.
- Understand the fundamentals of Postgres’ internal tooling.
Lessons in this course
Loading lessons.... |
---|
Thousands of learners have changed their careers with Dataquest
97%
Learners who recommend
Dataquest for career advancement
4.9 stars
Dataquest rating on
G2Crowd and SwitchUp
$30k
Average salary boost
for learners who complete a path
Join a community of 1M+ data learners on Dataquest
Sign up for a free account
Get access to hundreds of free lessons.
Choose a course or path
Start anywhere, from beginner topics to advanced concepts.
Learn with hands-on exercises
Learn with real data and build your experience.
Apply your skills
Create projects, build your portfolio, and build your career.