SQL Server 2008 Advanced Administration Course
Course DescriptionThis course is at aimed at SQL Server 2008 database administrators who wish to build on their basic administration skills and learn how to manage multiple SQL Server deployments and implement some of the more advanced administration and management services.
This course along with the SQL Server 2008 Essential Administration Course help to prepare delegates for the 70-432 Microsoft MCTS exam. |
£1195.00 4 day course Scheduled Dates: 11 June 2012 04 July 2012 18 September 2012 27 November 2012 |
Course pre-requisites:
Delegates attending this course should have SQL Server 2008 administration knowledge up to the level provided by the PTR “SQL Server 2008 Essential Administration Course”.
Topics covered on the 4 day SQL Server 2008 Advanced Administration course
DBA Maintenance Tasks
- Manage Services
- Maintain Security
- User Account Management
- Linked Server Management
- Impersonation
- Index Maintenance
- Index Types
- Spatial
- Clustered/Non-Clustered
- XML
- Filtered
- Include
- Updating & Creating Index & Column Statistics
- Automatic v Manual Update
- Enabling and Disabling Indexes
- Rebuilding and Re-organizing Indexes
- Database Engine Tuning Advisor
- Manage Collations
- Data File Maintenance
- Shrinking Databases and Data Files
- Automatic v Manual
- Data Purging
- Database Maintenance Plans
- Maintain Database Integrity
- CHECKDB
- Suspect Pages
- Performance & Tuning
- Checking Log Files
Command Line Administration Tools
- Using Powershell
- Using sqlcmd
Advanced Database Design
- Partitioning
- Partitioned Tables
- Partitioned Indexes
- Sparse Columns
- Row/Page Compression
- Enabling Filestream Support
- Implementing Full Text Indexing
- Implementing Transparent Database Encryption(TDE)
- Creating Database Snapshots
Transferring Data
- Overview of Data Transfer
- bcp utility
- BULK INSERT
- OPENROWSET
- Import & Export Wizards
- Introduction to SQL Server Integration Services
Implementing Replication
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
Advanced Monitoring of SQL Server
- Monitoring with DDL Triggers
- Logon Triggers
- Using Event Notifications
Performance Tuning Services
- Profiler
- Performance Monitor
- Dynamic Management Views
- Using Resource Governor
- Performance Studio
- Data Collector
Policy-Based Management
- Using Policy-Based Management
Implementing Service Broker
- A sample application
High Availability
- Database Mirroring
- Log Shipping
- Clustering
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Course Fee = £1195.00 (excl.VAT)
Scheduled course dates
11 June 2012 to 14 June 2012
04 July 2012 to 07 July 2012
18 September 2012 to 21 September 2012
27 November 2012 to 30 November 2012
Not the right course? Browse the index of all SQL Server 2008 modules covered across the courses.
View full schedule of Generic courses
View full schedule of SQL Server 2008 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2008 Training and bespoke SQL Server 2008 courses