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

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
SQL
  • 2Lessons · 1 นาที
    • 01 - Reduce query response time with query tuning.mp4
    • 02 - What you should know.mp4
  • 6Lessons · 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
  • 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
  • 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
  • 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
  • 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
  • 5Lessons · 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
  • 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
  • 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
  • 1Lessons ·
    • 01 - Next steps.mp4