SQL Server Advanced Administration (2008/2014)
This 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, helps to prepare delegates for the 70-432 Microsoft MCTS exam.
DBA Maintenance Tasks 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 High Availability
Database Mirroring Log Shipping Clustering Dates
Tuesday 26 to Friday 29 September 2017