High Performance SQL Server 2005 on 7 CD-ROMs by SQLUSA

Description

CD-ROM 1 – THE SCIENCE OF TUNING (2 hours 46 minutes)
1. Welcome to Performance Tuning & Optimization
2. High Performance Begins with Database Design
3. The All Important Indexes, Statistics & Locking
4. Tuning & Optimizing Queries and Stored Procedures
5. Enemies of Performance: Locking, Blocking and Deadlocks
6. Dynamic Management Views (DMV) & Functions (DMF)
7. Diagnosing & Fixing Common Performance Problems
8. Benchmarking and Establishing Performance Baselines
9. Data Warehouse, Data Mart, ETL & OLAP Cubes
10. Computer Management Utility & System Properties
11. SQL Server Management Studio
12. SQL Server 2005 Performance Dashboard Reports
13. Business Intelligence Development Studio
14. SQL Server Profiler & SQL Server Agent
15. Performance Monitor & Configuration Tools
16. Database Engine Tuning Advisor

CD-ROM 2 -TABLE DESIGN (2 hours 49 minutes)
1. Referential Integrity: Primary & Foreign Keys
2. Surrogate Primary Key and Natural Key
3. 3NF – Third Normal Form Design
4. 3NF Conversion of AW – AdventureWorks3NF
5. OLTP versus OLAP Design: Dimensional Modeling
6. Table Layout and Naming Conventions
7. Speedy Thin Tables with Thin Columns
8. Vertical Partitioning by Usage Frequency
9. Horizontal Partitioning Strategies
10. Quasi Real-Time Flat Reporting Tables
11. Auditing, History & Staging Tables
12. Star and Snowflake Schemas
13. Dimension and Fact Tables
14. High Performance Physical Database Design
15. Database Growing and Shrinking Options
16. Database Management DMVs & DMFs

CD-ROM 3 – INDEXING (2 hours 47 minutes)
1. Clustered Indexes – Heap Table – New Features
2. Non-clustered & Partitioned Index – FILL FACTOR
3. PK, FK and Unique Constraint Indexes
4. Nonkey Columns in Indexes for Covered Queries
5. Online & Parallel Indexes for 24/7 Operations
6. XML Indexes – Primary & Secondary

Platforms

Windows

Product Features

• Screen image video with audio narration
• Stop video lesson anytime to practice along
• Instruction by industry expert trainer
• Learn database optimization
• Learn SQL Server performance tuning