Practical SQL Server 2008 Administration on 21 CD-ROMs by SQLUSA

Description

CD-ROM 1 – OVERVIEW (2 hours 50 minutes)
1. Introduction and Welcome Notes
2. Your First SQL 2008 Email Report to the CEO
3. 2008 the Feature-Rich Sequel to 2005
4. What is New in SQL Server 2008
5. History of Relational Database Technology & SQL
6. Microsoft DBA Career Opportunity
7. SQL Server 2008 for Developers
8. The Advantages of the SQL Language
9. Enterprise Scale, Performance & Responsiveness
10. Data Warehousing & Business Intelligence
11. Microsoft's New BI Drive: BI for the Masses
12. New SSIS Data Profiling Task & DW Population
13. Enhanced OLAP Analysis Scale & Performance
14. Enterprise Reporting Engine & MS Word Reports
15. Temporal, Spatial Data Types & IntelliSense
16. Ten Guidelines for DBA & Developer Excellence

CD-ROM 2 – MANAGEMENT TOOLS (3 hours 2 minutes)
1. Editions of SQL Server 2008
2. Installing & Configuring SQL Server 2008
3. Installing & Configuring Part Two
4. Installing & Configuring Part Three
5. Program Group & Creating Desktop Shortcuts
6. First Look from Management Studio
7. SQL Server 2008 Upgrade Advisor
8. SQL Server Configuration Manager
9. Installing AdventureWorks2008 Database
10. SSIS Import and Export Wizard
11. Familiarizing with Query Editor
12. Books Online & the Graphical Query Designer
13. SQL Server Profiler & Tuning Advisor
14. Business Intelligence Development Studio – BIDS
15. Analysis Services – SSAS
16. Reporting Services – SSRS

CD-ROM 3 – ENTERPRISE SECURITY (3 hours 2 minutes)
1. Principals, Securables and Permissions
2. Metadata Visibility by Principals
3. Setting up Logins with Management Studio
4. Setting up Logins, DB Users, Roles with Statements
5. Fixed Server Roles and Permissions
6. Policy-Based Management for Better Security
7. DB User and Role Management with MS
8. Creating Security Accounts in the Enterprise
9. SCHEMAs and Security Hierarchy
10. Transparent Data Encryption (TDE) of Data
11. Extensible Key Management & Data Auditing

Platforms

Windows

Product Features

• 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.