High Performance SQL Server 2005 on 7 CD-ROMs

High Performance SQL Server 2005 on 7 CD-ROMs Review

High Performance SQL Server 2005 on 7 CD-ROMs Feature

• 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

High Performance SQL Server 2005 on 7 CD-ROMs Overview

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 Strategies10. 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 Indexes4. Nonkey Columns in Indexes for Covered Queries 5. Online & Parallel Indexes for 24/7 Operations 6. XML Indexes - Primary & Secondary

Available at Amazon Check Price Now!

*** Product Information and Prices Stored: Jan 26, 2011 06:35:02