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
รับผิดชอบ | Thanadet Rattanadilok Na Phuket |
---|---|
อัปเดตครั้งล่าสุด | 26/09/2024 |
เวลาเสร็จสิ้น | 6 นาที |
สมาชิก | 1 |
แชร์หลักสูตรนี้
แชร์ลิงก์
แชร์บนโซเชียลมีเดีย
แชร์ทางอีเมล
กรุณา ล็อกอิน เพื่อแชร์ LinkedIn – Advanced SQL for Query Tuning and Performance Optimization 2023-10 โดยอีเมล
SQL
-
01 - Introduction2Lessons · 1 นาที
-
01 - Reduce query response time with query tuning.mp4
-
02 - What you should know.mp4
-
-
02 - 1. How SQL Executes a Query6Lessons · 3 นาที
-
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 Tuning6Lessons ·
-
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 Indexes11Lessons ·
-
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 Joins9Lessons ·
-
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 Data7Lessons ·
-
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 Views5Lessons · 2 นาที
-
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 Queries6Lessons ·
-
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 Techniques7Lessons ·
-
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 - Conclusion1Lessons ·
-
01 - Next steps.mp4
-