VTC Legacy
Home / Databases

Database Optimization

by Lauri Sowa
111 lessons31 chapters7.8 hReleased 20103 free
Start the free chapter

This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. To begin learning today, simply click on the movie links.

Course content

Introduction3 lessons
Designing for Performance3 lessons
Troubleshooting & Testing3 lessons
Conducting an Audit4 lessons
Relationships & Joins4 lessons
Referential Integrity4 lessons
Data Types & Validations4 lessons
Creating a Data Model4 lessons
Database Normalization4 lessons
Temporary Tables3 lessons
Query/Views Optimization4 lessons
Index Strategies4 lessons
Clustered Indexes3 lessons
More Tuning4 lessons
Data Types & Quality4 lessons
Best Practices3 lessons
Stored Procedures & Triggers4 lessons
Hardware Performance Concepts3 lessons
Applying Performance Concepts5 lessons
Monitoring4 lessons
Database Security4 lessons
Understanding Lifecycles3 lessons
Using Baselines & Profiler4 lessons
Analyzing Slow Performance3 lessons
Optimizing Code5 lessons
Statistics4 lessons
Other Components4 lessons
Checklists5 lessons
Odds & Ends3 lessons
Conclusion1 lessons
Credits1 lessons