Excel Bookstore
 Location:  Home» Office Software » Training & Tutorials » High Performance SQL Server 2005 on 7 CD-ROMs  
Other Locales
  • Canada
  • U.K.
  • USA
    • Categories
    •Bill Jelen Books
    •Excel Books
    •Excel 2007 Books
    •VBA Books
    •Pivot Table Books
    •Charting Books
    •Access Books
    •Office Books
    •Holy Macro! Books
    •Office Software
    •Computers
    •Kindle
    Related Categories
    • Training & Tutorials
    Business & Office
    Categories
    Software
    • Training & Tutorials
    Programming
    Categories
    Software
    • Microsoft Windows
    Operating System (operating_system_browse-bin)
    Browse Refinements
    Refinements
    Software
    Subcategories
    Training & Tutorials
    •Business Application Training
    •Graphic Application Training
    •New to Computers

    High Performance SQL Server 2005 on 7 CD-ROMs

    High Performance SQL Server 2005 on 7 CD-ROMs

    enlarge 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 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

    Thank you for browsing ExcelBookstore.com!