Certification MCITP SQL Server 2008 Certification Number of exam(s) 1 Exam

Course Length 8 Weeks Locations Liverpool Street  London Bridge Moorgate

Delivery Instructor led hands-on Includes Books, CDs, Manual, Notes, Unlimited Lab Access & VAT

Reserve Your Place or Book Online Time Table of MCITP SQL 2008 Certification or   ENQUIRE

Detailed Syllabus

Exam Number	Exam Details
Exam 70- 432	Microsoft SQL Server 2008 - Implementation and Maintenance
Exam 70- 450	Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Microsoft SQL Server 2008, Implementation and Maintenance

Introduction to SQL Server 2008 and its Toolset

• Introduction to SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services
• Verify SQL Server Component Installation
• Alter Service Accounts for New Instance
• Enable Named Pipes Protocol for Both Instances
• Create Aliases for AdventureWorks and Proseware
• Ensure SQL Browser is Disabled and Configure a Fixed TCP/IP Port

Preparing Systems for SQL Server 2008

• Describe the SQL Server architecture
• Plan for server resource requirements
• Conduct pre-installation stress testing for SQL Server

Installing and Configuring SQL Server 2008

• Review installation requirements
• Install the SQL Server instance
• Perform Post-installation Setup and Checks
• Configure Server Memory

Working with Databases

• Adjust tempdb configuration
• Create the RateTracking database
• Attach the OldProspects database
• Add multiple files to tempdb
• Describe the role and structure of SQL Server databases
• Work with files and filegroups
• Move database files within servers and between servers

Understanding SQL Server 2008 Recovery Models

• Backup Strategies
• Understanding SQL Server Transaction Logging
• Planning a SQL Server Backup Strategy
• Plan a backup strategy
• Configure recovery models
• Review recovery models and strategy

Backup of SQL Server 2008 Databases

• Back up databases and transaction logs
• Manage database backups
• Work with more advanced backup options

Restoring SQL Server 2008 Databases

• Understand the restore process
• Restore databases
• Work with Point-in-time Recovery
• Restore system databases and individual files

Importing and Exporting Data

• Import the Excel spreadsheet
• Import the CSV file
• Create and test an extraction package
• Compare loading performance

Authenticating and Authorizing Users

• Authenticating Connections to SQL Server
• Authorizing Logins to Access Databases
• Authorization Across Servers
• Create Logins
• Correct an Application Login Issue
• Create Database Users
• Correct Access to Restored Database

Assigning Server and Database Roles

• Work with server roles
• Work with fixed database roles
• Create user-defined database roles

Authorizing Users to Access Resources

• Authorizing User Access to Objects
• Authorizing Users to Execute Code
• Configuring Permissions at the Schema Level

Auditing SQL Server Environments

• Options for Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit

Automating SQL Server 2008 Management

• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs

Configuring Security for SQL Server Agent

• Explain SQL Server Agent security
• Configure credentials
• Configure Proxy accounts

Monitoring SQL Server 2008 with Alerts and Notifications

• Configure database mail
• Monitor SQL Server errors
• Configure operators, alerts and notifications

Performing Ongoing Database Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance
• Check database integrity using DBCC CHECKDB
• Correct index fragmentation
• Create a database maintenance plan
• Investigate table lock performance

Tracing Access to SQL Server 2008

• Capturing Activity using SQL Server Profiler
• Improving Performance with the Database Engine Tuning Advisor
• Working with Tracing Options

Monitoring SQL Server 2008

• Monitoring Activity
• Capturing and Managing Performance Data
• Analyzing Collected Performance Data
• Investigating DMVs
• Configure Management Data Warehouse
• Configure Instances for Data Collection
• Work with Data Collector Reports

Managing Multiple Servers

• Working with Multiple Servers
• Virtualizing SQL Server
• Deploying and Upgrading Data-Tier Applications
• Configure CMS and execute multi-server queries
• Deploy a data-tier application
• Register and extract a data-tier application
• Upgrade a data-tier application

Troubleshooting Common SQL Server 2008 Administrative Issues

• SQL Server Troubleshooting Methodology
• Resolving Service-related Issues
• Resolving Concurrency Issues
• Resolving Login and Connectivity Issues

Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

Designing an Administrative Solution for SQL Server 2008

• Overview of SQL Server 2008  
• Designing an Administrative Solution
• Developing and Deploying an Administrative Solution for SQL Server 2008
• Implementing an Administrative Solution in SQL Server Management Studio (SSMS)
• Designing an Administrative Solution
• Using SQL PowerShell to Automate SQL Server Configuration
• Creating SQL Server PowerShell Scripts
• Configuring FILESTREAM Support in SQL Server 2008

Deploying SQL Server 2008

• System Requirements for SQL Server 2008
• Upgrading and Migrating to SQL Server 2008
• Configuring Instances in SQL Server 2008
•  

Designing the Physical Structure of SQL Server 2008

• Introduction to the Physical Structure of a Database
• Planning for Partitioning
• Planning for Full-Text Indexing

Designing a Strategy for Maintaining a Database in SQL Server 2008

• Designing a Strategy for Maintaining Statistics for a Database
• Designing a Strategy for Maintaining Indexes
• Designing a Strategy for Database Compression

Designing Solutions for Managing SQL Server 2008

• Designing a Policy-Based Management Strategy
• Controlling Resource Usage by using Resource Governor
• Auditing Database Changes

Automating the Database Management Strategy for SQL Server 2008

• Managing SQL Server Agent
• Automating Administrative Tasks in SQL Server
• Monitoring Events in SQL Server

Designing a Strategy for Securing SQL Server 2008

• Securing SQL Server 2008 Instances
• Planning Database Security
• Managing Certificate and Keys in SQL Server 2008
• Implementing Database Encryption
• Designing a strategy for Database Security
• Configuring Security in SQL Server
• Enabling Database Encryption

Designing a Strategy for Monitoring SQL Server 2008

• Overview of Monitoring SQL Server 2008
• Monitoring SQL Server Instances
• Monitoring SQL Server Databases
• Monitoring Multiple SQL Servers by Using Data Collection

Designing a Strategy for Content Distribution in SQL Server 2008

• Distributing Data in SQL Server 2008
• Working with Distributed Queries
• Managing Distributed Content by Using Distributed Transactions
• Managing SQL Server Integration Services (SSIS) Packages
• Setting Up Scalable Shared Databases
• Selecting a Content Distribution Technology
• Performing a Remote Query
• Monitoring an SSIS Package

Designing a Strategy for Replication in SQL Server 2008

• Designing a Database Replication Strategy
• Implementing Content Distribution by using Replication
• Configuring a High-Availability Solution by Using Replication
• Designing a Replication Strategy
• Setting up Snapshot Replication
• Setting up Peer-To-Peer Replication

Designing a High-Availability Solution for SQL Server 2008

• Introduction to High Availability
• Implementing Log Shipping
• Implementing Database Mirroring
• Implementing Failover Clustering
• Designing a High-Availability Strategy

Designing a Backup and Recovery Strategy for SQL Server 2008

• Planning a Backup Strategy
• Planning a Recovery strategy
• Designing a Backup and Recovery Strategy
• Implementing a Repair Strategy
• Designing a Backup and Recovery Solution
• Backing up a Database
• Restoring a Database by Using Online Operations
• Restoring a System Database