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.
Creating Audits Through Procedures
Primary/Foreign/Candidate Keys
Conceptual/Logical/Physical Models
Creating & Using Temporary Tables
Introduction to Execution Plans
Running the SQL Execution Plan
Using Profiler for the Execution Plan
Clustered vs. Non-Clustered Indexes
Creating a Sustainable Database
Stored Procedures/Functions/Triggers
Creating a Function & When to Use
System vs. Performance Monitor
Examples for sys.dm_io_virtual_file_stats
Database Consistency Checker (DBCC)
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.