Improving Query Performance in PostgreSQL

Name: Improving Query Performance in PostgreSQL
Brand: Careervira
Price: 574 HKD
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Do you waste time answering slow questions? Are you hesitant to share your questions and experiences with other experts? This course will show you how to speed up your PostgreSQL. By exploring interconnected data like country climate, Olympic participation, and gross domestic product, you will learn how query performance can be affected by changing filtering methods. You will learn all about row-oriented databases and how they affect air quality. Your efficiency and ability with the SQL order or query planner will impress your colleagues.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Learn how to structure your PostgreSQL queries to run in a fraction of the time

You will learn the properties of a row oriented database while also seeing how Hawaii's volcanos impact air quality

Course Content

Expand all sections

Module 1: Bringing Together the Data

Module 2: Minimizing Results and Decreasing the Load

Module 3: Using Database Designed Properties

Module 4: Assessing Query Performance

Course Instructors

Amy McCarty

Data Analyst

Amy is a data analyst, policy wonk, and all around data nerd. She has a master's degree in policy analytics from Carnegie Mellon and has worked as an analyst in both the nonprofit and for-profit sect...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%