Skip to main content
Back to course
Log in
Get started
Someone wanted to learn this too, so Grasp built them a personal learning path.
Create your own
Master Laravel, optimized database queries
ยท
Module 5
Database Performance & Optimization
1
SQL Execution Plan Analysis
Analyze MSSQL query performance using execution plans to identify bottlenecks.
2
Optimizing Query Performance with Clustered and Non-Clustered Indexes
Create and manage clustered and non-clustered indexes to optimize query speed.
3
Optimizing Table Scans with Indexing
Resolve inefficient table scans by applying appropriate indexing strategies.
4
Optimizing MSSQL Queries for Sorting, Filtering, and Aggregation
Optimize queries involving sorting, filtering, and aggregation in MSSQL.
5
Efficient Data Processing with Chunking and Cursors
Process large datasets efficiently using 'chunkById' and 'cursor' methods.
6
Optimizing Queries with Caching
Implement query caching to reduce database load on frequently executed queries.
Previous module
MSSQL Integration & Query Building
Next module
API Development: Resources & Versioning