Optimization of SQL query Tuning and Performance
Completed by Angelo Agcaoili
November 16, 2023
1 hours (approximately)
Angelo Agcaoili'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: Databases
- Category: SQL
- Category: Data Access
- Category: Database Management
- Category: Performance Tuning
- Category: Database Design
- Category: Query Languages
- Category: PostgreSQL
