Practical SQL Server 2008 Administration on 21 CD-ROMs

Practical SQL Server 2008 Administration on 21 CD-ROMs Review

Practical SQL Server 2008 Administration on 21 CD-ROMs Feature

• Practical Microsoft SQL Server 2008 Training on Video & Audio CD-ROMs by database/business intelligence industry expert.
• For database administrators (DBA-s), system administrators, C#, VB, Web, .NET, Java, C++ and database developers; database designers, systems analysts and software engineers.
• Like training one-on-one with an experienced database professional, each unit is presented in full-motion screen image video allowing you to see the steps and hear the explanations.
• Pause the video any time and practice along with your own copy of SQL Server 2008. Lessons and the bonus CD include a great number of practical T-SQL scripts. Cursor movements/clicks are highlighted in the video.
• The CD-ROM based course will allow learners to identify, configure, administer, manage and program all major aspects of a Microsoft SQL Server 2008 RDBMS.

Practical SQL Server 2008 Administration on 21 CD-ROMs Overview

CD-ROM 1 - OVERVIEW (2 hours 50 minutes)1. Introduction and Welcome Notes2. Your First SQL 2008 Email Report to the CEO3. 2008 the Feature-Rich Sequel to 20054. What is New in SQL Server 20085. History of Relational Database Technology & SQL6. Microsoft DBA Career Opportunity7. SQL Server 2008 for Developers8. The Advantages of the SQL Language9. Enterprise Scale, Performance & Responsiveness10. Data Warehousing & Business Intelligence11. Microsoft's New BI Drive: BI for the Masses 12. New SSIS Data Profiling Task & DW Population13. Enhanced OLAP Analysis Scale & Performance14. Enterprise Reporting Engine & MS Word Reports15. Temporal, Spatial Data Types & IntelliSense16. Ten Guidelines for DBA & Developer ExcellenceCD-ROM 2 - MANAGEMENT TOOLS (3 hours 2 minutes) 1. Editions of SQL Server 20082. Installing & Configuring SQL Server 20083. Installing & Configuring Part Two4. Installing & Configuring Part Three5. Program Group & Creating Desktop Shortcuts6. First Look from Management Studio7. SQL Server 2008 Upgrade Advisor8. SQL Server Configuration Manager9. Installing AdventureWorks2008 Database10. SSIS Import and Export Wizard11. Familiarizing with Query Editor12. Books Online & the Graphical Query Designer13. SQL Server Profiler & Tuning Advisor 14. Business Intelligence Development Studio - BIDS15. Analysis Services - SSAS 16. Reporting Services - SSRSCD-ROM 3 - ENTERPRISE SECURITY (3 hours 2 minutes)1. Principals, Securables and Permissions2. Metadata Visibility by Principals3. Setting up Logins with Management Studio4. Setting up Logins, DB Users, Roles with Statements5. Fixed Server Roles and Permissions 6. Policy-Based Management for Better Security7. DB User and Role Management with MS8. Creating Security Accounts in the Enterprise9. SCHEMAs and Security Hierarchy10. Transparent Data Encryption (TDE) of Data11. Extensible Key Management & Data Auditing

Available at Amazon Check Price Now!

*** Product Information and Prices Stored: Dec 01, 2010 13:58:03