Optimization of SQL query Tuning and Performance
Completed by Nguyen Trinh Quang Trung
April 4, 2024
1 hours (approximately)
Nguyen Trinh Quang Trung'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: PostgreSQL
- Category: Data Access
- Category: Databases
- Category: Database Management
- Category: SQL
- Category: Query Languages
- Category: Database Design
- Category: Performance Tuning
