High Performance SQL Server 2005 on 7 CD-ROMs: Software: Online shopping for Computers, Programming, Internet Books, Software, Dowbloads, PDF, ebooks, and more. Get selection of Books, and Software by Subjects, Programming, Home & Office, Computer Science, Software, Web Development, Networking & more at everyday low prices. Technical and computer books. Computer books, some available at half of the cover price. Online computer bookstore featuring books and training. Offers the latest publications on computers and computing, such as information on hardware, software applications, and all other areas of information technology. Offering computer science, computer engineering, computer programming and computer software books. nline shopping for Databases Computers & Internet from a great selection of Books; Subjects, Data Storage & Management, Specific Databases, Oracle & more at everyday low prices. Online shopping for Graphic Design from a great selection of Books; Computers & Internet, Subjects, Desktop Publishing, Web & Multimedia, CAD, Applications, Printing, System Architecture, Microprocessors & System Design, PCs, Macs, Peripherals, Operating Systems, Applications, Development, Certifications, Microsoft, Unix, Linux, Theory, MacOS, OS-2, DOS, Design & Development, Business, Word Processors & Editors, Spreadsheets, File Systems, Internet Commerce, HTML, Graphics, & Design, Security & Encryption & more at everyday low prices. All major publishers like O'Reilly, Microsoft Press Technical Solutions Center, Sybex, Cisco Press & more at everyday low prices.: Online shopping for Computers & Internet from a great selection of Books; Subjects, Programming, Home & Office, Computer Science, Software, Web Development, Networking & more at everyday low prices.

Location: Home » Software » Training & Tutorials » High Performance SQL Server 2005 on 7 CD-ROMs

Tech. Books

Software

PC & Laptops

Electronics

Related Categories

•	Training & Tutorials

Business & Office

Categories

Software

•	Microsoft Windows

Operating System (operating_system_browse-bin)

•

•

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

UPC: 850171001111
EAN: 0850171001111
ASIN: B0018A4OKS

Availability: Usually ships in 1-2 business days
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

Technology Focus