LinkedIn – Advanced SQL for Query Tuning and Performance Optimization 2023-10

Course Advanced SQL for Query Tuning and Performance Optimization, Dan Sullivan, Download Advanced SQL for Query Tuning and Performance Optimization, Download course Advanced SQL for Query Tuning and Performance Optimization, Free Advanced SQL for Query Tuning and Performance Optimization, Free download Advanced SQL for Query Tuning and Performance Optimization

Join this Course

Responsible	Thanadet Rattanadilok Na Phuket
Last Update	26/09/2024
Completion Time	6 minutes
Members	1

SQL

01 - Introduction

2Lessons · 1 min
- 01 - Reduce query response time with query tuning.mp4
- 02 - What you should know.mp4
02 - 1. How SQL Executes a Query

6Lessons · 3 min
- 01 - From declarative SQL to a procedural execution plan.mp4
- 02 - Scanning tables and indexes.mp4
- 03 - Joining tables.mp4
- 04 - Partitioning data.mp4
- 05 - Challenge Choosing how to partition a table.mp4
- 06 - Solution Choosing how to partition a table.mp4
03 - 2. PostgreSQL Tools for Tuning

6Lessons ·
- 01 - Using PostgreSQL in Codespaces.mp4
- 02 - Explain and analyze.mp4
- 03 - Example plan Selecting with a WHERE clause.mp4
- 04 - Indexes.mp4
- 05 - Challenge Generating a query execution plan.mp4
- 06 - Solution Generating a query execution plan.mp4
04 - 3. Types of Indexes

11Lessons ·
- 01 - Indexing.mp4
- 02 - B-tree indexes.mp4
- 03 - B-tree index example plan.mp4
- 04 - Bitmap indexes.mp4
- 05 - Bitmap index example plan.mp4
- 06 - Hash indexes.mp4
- 07 - Hash index example plan.mp4
- 08 - Bloom filter indexes.mp4
- 09 - PostgreSQL-specific indexes.mp4
- 10 - Challenge Choosing an index.mp4
- 11 - Solution Choosing an index.mp4
05 - 4. Tuning Joins

9Lessons ·
- 01 - Types of joins.mp4
- 02 - Nested loops.mp4
- 04 - Hash joins.mp4
- 05 - Hash join example plan.mp4
- 06 - Merge joins.mp4
- 07 - Merge join example.mp4
- 08 - Subqueries vs. joins.mp4
- 09 - Challenge Designing a join.mp4
- 10 - Solution Designing a join.mp4
06 - 5. Partitioning Data

7Lessons ·
- 01 - Horizontal vs. vertical partitioning.mp4
- 02 - Partition by range.mp4
- 03 - Partition by range example.mp4
- 05 - Partition by list example.mp4
- 06 - Partition by hash.mp4
- 08 - Challenge Partitioning a table.mp4
- 09 - Solution Partitioning a table.mp4
07 - 6. Materialized Views

5Lessons · 2 min
- 01 - Materialized views.mp4
- 02 - Creating materialized views.mp4
- 03 - Refreshing materialized views.mp4
- 04 - Challenge Creating a materialized view.mp4
- 05 - Solution Creating a materialized view.mp4
08 - 7. Database Statistics and Identifying Slow Queries

6Lessons ·
- 01 - Collect statistics about data in tables.mp4
- 02 - Analyzing execution statistics with pg_stat_statements.mp4
- 03 - Reviewing execution plans with the auto_explain module.mp4
- 04 - Additional analysis with other pg_stats data.mp4
- 05 - Challenge Analyze schema statistics.mp4
- 06 - Solution Analyze schema statistics.mp4
09 - 8. Other Optimization Techniques

7Lessons ·
- 01 - Using common table expressions to avoid repetitive computation.mp4
- 02 - Hints to the Query Optimizer.mp4
- 03 - Parallel query execution.mp4
- 04 - Improving cache utilization.mp4
- 05 - Miscellaneous tips.mp4
- 06 - Challenge Design a common table expression.mp4
- 07 - Solution Design a common table expression.mp4
10 - Conclusion

1Lessons ·
- 01 - Next steps.mp4