Optimization of SQL query Tuning and Performance
Completed by Elie Andrianarisolo
July 8, 2024
1 hours (approximately)
Elie Andrianarisolo's account is verified. Coursera certifies their successful completion of Optimization of SQL query Tuning and Performance
What you will learn
Create tables, insert data and execute and plan times of the queries using Explain and Explain Analyze.
Apply different types of indexes to improve performance.
Apply the hash, merge and nest loop join strategies.
Skills you will gain
- Category: Database Management
- Category: Data Access
- Category: SQL
- Category: Databases
- Category: PostgreSQL
- Category: Query Languages
- Category: Performance Tuning
- Category: Database Design
