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 Efficiency Tuning & Optimization
2. Excessive Performance Starts Offevolved with Database Design
3. The All Necessary Indexes, Information & Locking
4. Tuning & Optimizing Queries and Saved Procedures
5. Enemies of Efficiency: Locking, Blocking and Deadlocks
6. Dynamic Management Views (DMV) & Capabilities (DMF)
7. Diagnosing & Fixing Standard Efficiency Problems
Eight. Benchmarking and Establishing Performance Baselines
9. Knowledge Warehouse, Knowledge Mart, ETL & OLAP Cubes
10. Computer Administration Utility & Device Houses
11. SQL Server Administration Studio
12. SQL Server 2005 Performance Dashboard Stories
13. Industry Intelligence Construction Studio
14. SQL Server Profiler & SQL Server Agent
15. Efficiency Reveal & Configuration Tools
16. Database Engine Tuning Consultant

CD-ROM 2 -Table DESIGN (2 hours Forty Nine minutes)
1. Referential Integrity: Major & Foreign Keys
2. Surrogate Main Key and Pure Key
3. 3NF – 0.33 Commonplace Form Design
4. 3NF Conversion of AW – AdventureWorks3NF
5. OLTP versus OLAP Design: Dimensional Modeling
6. Table Format and Naming Conventions
7. Speedy Thin Tables with Skinny Columns
Eight. Vertical Partitioning by means of Usage Frequency
9. Horizontal Partitioning Methods
10. Quasi Real-Time Flat Reporting Tables
11. Auditing, History & Staging Tables
12. Star and Snowflake Schemas
13. Dimension and Reality Tables
14. Excessive Performance Physical Database Design
15. Database Growing and Shrinking Options
Sixteen. Database Management DMVs & DMFs

CD-ROM 3 – INDEXING (2 hours Forty Seven minutes)
1. Clustered Indexes – Heap Table – New Features
2. Non-clustered & Partitioned Index – FILL FACTOR
Three. PK, FK and Distinctive Constraint Indexes
4. Nonkey Columns in Indexes for Lined Queries
5. On-line & Parallel Indexes for twenty-four/7 Operations
6. XML Indexes – Main & Secondary

Systems

Home Windows

Product Features

• Monitor picture video with audio narration
• Cease video lesson every time to apply along
• Instruction by using business professional trainer
• Analyze database optimization
• Learn SQL Server Efficiency tuning