Overview
Context
Losing time on slow queries? Hesitant to share your queries with more seasoned coworkers?
In this Improving Query Performance in PostgreSQL course offered by Data Camp, you will explore intertwined data relating Olympic participation, country climate, and gross domestic product, and 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.
Programme Structure
Chapters
- Bringing Together the Data
- Minimizing Results and Decreasing the Load
- Using Database Designed Properties
- Assessing Query Performance
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Software Engineering Data Analytics View 179 other Short Courses in Data Analytics in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
PREREQUISITES:
- Data Manipulation in SQL
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions