Optimization of SQL query Tuning and Performance
Completed by Harsh Davda
October 12, 2023
1 hours (approximately)
Harsh Davda'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: PostgreSQL
- Category: Query Languages
- Category: Database Design
- Category: Data Access
- Category: Performance Tuning
- Category: Databases
- Category: SQL
