Optimization of SQL query Tuning and Performance
Completed by Pankaj Sharma
August 25, 2024
1 hours (approximately)
Pankaj Sharma'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: Data Access
- Category: Databases
- Category: SQL
- Category: PostgreSQL
- Category: Query Languages
- Category: Performance Tuning
- Category: Database Design
- Category: Database Management
