Improving Query Performance in PostgreSQL
|
Learn how to structure your PostgreSQL queries to run in a fraction of the time.
Losing time on slow queries? Hesitant to share your queries with more seasoned coworkers? In this course, you will learn how to structure your PostgreSQL to run in a fraction of the time. Exploring intertwined data relating Olympic participation, country climate, and gross domestic product, you will experience firsthand how changes in filtering method and using subqueries impact query performance. You will learn the properties of a row oriented database while also seeing how Hawaii’s volcanos impact air quality. Restructuring your queries with the query planner and the SQL order of operations, you will soon be dazzling your coworkers with your effortless efficiency.
User Reviews
Be the first to review “Improving Query Performance in PostgreSQL”
Related Products
Intermediate SQL
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
Data Scientist Interview Preparation
Prepare for the data science interview process, from navigating job postings to passing the technical interview.
Learn Intermediate SQL for Marketers and Product Managers
Perform data analysis on funnels, churn, and attribution. This course contains advanced SQL content for new Marketers and Product Managers.
Learn SQL: Aggregate Functions
Perform calculations inside SQL queries to answer specific data questions.
Joining Data in SQL
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
There are no reviews yet.