United States Database Optimization Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Database Optimization
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
Introduction
|
|||
| Introduction & Disclaimers | (03:36) | T | |
| Optimizing a Database | (03:42) | T | |
| Some Common Problems | (06:10) | T | |
|
Designing for Performance
|
|||
| Planning & Process Principles | (04:02) | T | |
| Design Principles | (05:33) | T | |
| Client/Server Interaction | (05:04) | T | |
|
Troubleshooting & Testing
|
|||
| What to Look for | (05:31) | T | |
| Types of Testing | (05:19) | T | |
| SQLdiag Tool | (04:18) | T | |
|
Conducting an Audit
|
|||
| Understanding Audits | (03:55) | T | |
| Components of Audits | (03:27) | T | |
| Examples of Components | (04:33) | T | |
| Creating Audits Through Procedures | (04:15) | T | |
|
Relationships & Joins
|
|||
| Relationships | (05:12) | T | |
| Understanding Joins | (05:39) | T | |
| Optimizing Joins | (06:05) | T | |
| Joins & Indexing | (02:15) | T | |
|
Referential Integrity
|
|||
| Proper Use of Integrity | (02:39) | T | |
| Integrity Continued | (06:15) | T | |
| Primary/Foreign/Candidate Keys | (05:31) | T | |
| Troubleshooting Integrity | (05:03) | T | |
|
Data Types & Validations
|
|||
| Unions | (02:02) | T | |
| UNION in SQL | (03:11) | T | |
| Standards | (05:30) | T | |
| Validation | (04:54) | T | |
|
Creating a Data Model
|
|||
| Conceptual/Logical/Physical Models | (05:37) | T | |
| Relational Modeling | (04:41) | T | |
| Entity Model | (03:04) | T | |
| Schemas | (04:23) | T | |
|
Database Normalization
|
|||
| First Normal Form | (04:31) | T | |
| Second Normal Form | (04:39) | T | |
| Third Normal Form | (03:33) | T | |
| Denormalization | (06:26) | T | |
|
Temporary Tables
|
|||
| Creating & Using Temporary Tables | (03:54) | T | |
| Heap & Memory Tables | (03:08) | T | |
| EXPLAIN Statement | (05:16) | T | |
|
Query/Views Optimization
|
|||
| Introduction to Execution Plans | (04:45) | T | |
| Running the SQL Execution Plan | (05:07) | T | |
| Using Profiler for the Execution Plan | (04:41) | T | |
| SET SHOWPLAN_TEXT | (04:15) | T | |
|
Index Strategies
|
|||
| Effective Indexes | (06:31) | T | |
| Short & Distinct Keys | (04:25) | T | |
| Looking at Indexes in SQL | (03:18) | T | |
| Optimizing & Indexes | (05:35) | T | |
|
Clustered Indexes
|
|||
| Clustered vs. Non-Clustered Indexes | (04:42) | T | |
| Tips for Clustered Indexes | (03:47) | T | |
| Significance on Performance | (05:57) | T | |
|
More Tuning
|
|||
| Eliminating Unwanted Data | (05:10) | T | |
| SHRINKFILE Examples | (02:43) | T | |
| Database Tuning Advisor | (02:17) | T | |
| DTA Example | (05:50) | T | |
|
Data Types & Quality
|
|||
| Data Quality | (05:16) | T | |
| Overview of Data Types | (03:08) | T | |
| SQL vs. Oracle Data Types | (03:28) | T | |
| Examples in SQL | (03:09) | T | |
|
Best Practices
|
|||
| Creating a Sustainable Database | (05:08) | T | |
| Documentation | (05:04) | T | |
| Most Common Practices | (04:18) | T | |
|
Stored Procedures & Triggers
|
|||
| Stored Procedures/Functions/Triggers | (04:53) | T | |
| Writing Stored Procedures | (05:18) | T | |
| Creating a Function & When to Use | (04:33) | T | |
| Working with Triggers | (04:43) | T | |
|
Hardware Performance Concepts
|
|||
| CPU & Input/Output | (03:58) | T | |
| Memory Management | (03:57) | T | |
| Network Infrastructure | (04:52) | T | |
|
Applying Performance Concepts
|
|||
| Task Manager | (03:31) | T | |
| System vs. Performance Monitor | (02:20) | T | |
| Performance Monitor | (05:13) | T | |
| SQL Database I/O Report | (02:24) | T | |
| Examples for sys.dm_io_virtual_file_stats | (03:04) | T | |
|
Monitoring
|
|||
| Event Viewer | (05:49) | T | |
| SQL Activity Monitor | (05:41) | T | |
| Locks & Deadlocks | (04:47) | T | |
| Monitoring Services | (03:03) | T | |
|
Database Security
|
|||
| Privileges | (03:56) | T | |
| Role Based Authorization | (04:24) | T | |
| GRANT & REVOKE Statements | (04:19) | T | |
| Reviewing Security in SQL | (03:08) | T | |
|
Understanding Lifecycles
|
|||
| Lifecycle Management | (05:39) | T | |
| The Database Lifecycle | (05:22) | T | |
| Using the SQL Management Plan | (05:06) | T | |
|
Using Baselines & Profiler
|
|||
| Importance of Baselines | (03:34) | T | |
| SQL Profiler | (05:00) | T | |
| Trace & Other Profiler Tools | (03:36) | T | |
| Terminology in Work Files | (01:45) | T | |
|
Analyzing Slow Performance
|
|||
| Database Testing | (05:22) | T | |
| Thoughts on Troubleshooting | (04:57) | T | |
| Generalized Tips | (03:42) | T | |
|
Optimizing Code
|
|||
| Levels of Optimization | (02:46) | T | |
| UNION vs. OR Optimization | (02:17) | T | |
| JOIN vs. WHERE | (02:14) | T | |
| Weak Joins | (02:52) | T | |
| Coding Tips | (04:35) | T | |
|
Statistics
|
|||
| Overview of Statistics | (02:57) | T | |
| Seeing Statistics in SQL | (04:35) | T | |
| Auditing | (03:48) | T | |
| Auditing in SQL | (02:52) | T | |
|
Other Components
|
|||
| Database Consistency Checker (DBCC) | (03:34) | T | |
| DBCC in SQL | (03:03) | T | |
| System Catalog | (02:28) | T | |
| System Catalog in SQL | (03:01) | T | |
|
Checklists
|
|||
| Architecture & Design | (03:34) | T | |
| Constraints & Influences | (04:36) | T | |
| Performance Tuning | (05:17) | T | |
| Index Checklist | (03:52) | T | |
| General Checklist | (03:53) | T | |
|
Odds & Ends
|
|||
| Business Intelligence | (04:16) | T | |
| Archiving | (05:15) | T | |
| ADONET | (03:29) | T | |
|
Conclusion
|
|||
| Wrap Up & Work Files | (03:17) | T | |
|
Credits
|
|||
| About the Author | (01:58) | T | |
Email this Page
Send us FeedbackCourse Information
| Course: | Database Optimization |
| Author: | Lauri Sowa-Matson |
| SKU: | 34078 |
| ISBN: | 1-935320-94-7 |
| Release Date: | 2010-01-06 |
| Duration: | 8 hrs / 111 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.