|
High Performance SQL Server 2005 on 7 CD-ROMs | 
 enlarge | From: Silico-Magnetic Intelligence Corp.
Category: Software
Buy New: $595.00
Format: Cd-rom
Media: CD-ROM
Operating System: Windows
UPC: 850171001111
EAN: 0850171001111
ASIN: B0018A4OKS
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Condition: Includes 2 textbooks
| |
| 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 |
|
| Editorial Reviews:
Product 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 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
|
|
|
| |
