|
 See larger picture | High Performance SQL Server 2005 on 7 CD-ROMs
by SQLUSAAvailability:
This item is currently not available by this merchant.
|
- 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
|
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 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
|
|
|