Advanced SQL for Query Tuning and Performance Optimization
- Offered byLinkedin Learning
Advanced SQL for Query Tuning and Performance Optimization at Linkedin Learning Overview
Duration | 2 hours |
Total fee | ₹1,400 |
Mode of learning | Online |
Difficulty level | Advanced |
Credential | Certificate |
Advanced SQL for Query Tuning and Performance Optimization at Linkedin Learning Highlights
- 1 exercise file
- Access on tablet and phone
Advanced SQL for Query Tuning and Performance Optimization at Linkedin Learning Course details
- SQL queries can be fast and highly efficient, but they can also be slow and demand excessive CPU and memory resources
- In this course, Dan Sullivan shows developers how to analyze query execution plans and use data modeling strategies to boost query performance
- Dan describes how SQL queries are executed; highlights different types of indexes and how they factor in query tuning; covers several methods for performing joins; and discusses how to use partitioning and materialized views to improve performance
Advanced SQL for Query Tuning and Performance Optimization at Linkedin Learning Curriculum
Introduction
Reduce query reponse time with query tuning
What you should know
How SQL Executes a Query
From declarative SQL to a procedural execution plan
Scanning tables and indexes
Joining tables
Partitioning data
PostgreSQL Tools for Tuning
Installing PostgreSQL
Overview of pgAdmin
Explain and analyze
Example plan: Selecting with a WHERE clause
Indexes
Types of Indexes
Indexing
B-tree indexes
B-tree index example plan
Bitmap indexes
Bitmap index example plan
Hash indexes
Hash index example plan
PostgreSQL-specific indexes
Tuning Joins
What affects joins performance?
Nested loops
Nested loop example plan
Hash joins
Hash join example plan
Merge joins
Merge join example
Subqueries vs. joins
Partitioning Data
Horizontal vs. vertical partitioning
Partition by range
Partition by range example
Partition by list
Partition by list example
Partition by hash
Partition by hash example
Materialized Views
Materialized views
Creating materialized views
Refreshing materialized views
Other Optimization Techniques
Collect statistics about data in tables
Hints to the query optimizer
Parallel query execution
Miscellaneous tips
Conclusion
Next steps
Other courses offered by Linkedin Learning
Student Forum
Anything you would want to ask experts?