Duration
5 days
Module 1: Introduction to SQL Server 2012 and its Toolset
Lessons
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
Module 4: Working with Databases
Lessons
- Overview of SQL Server Databases
- Working with Files and Filegroups
- Moving Database Files
Module 5: Understanding SQL Server 2012 Recovery Models
Lessons
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
Module 6: Backup of SQL Server 2012 Databases
Lessons
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
Module 7: Restoring SQL Server 2012 Databases
Lessons
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-time recovery
- Restoring System Databases and Individual Files
Module 8: Importing and Exporting Data
Lessons
- Transferring Data To/From SQL Server
- Importing & Exporting Table Data
- Inserting Data in Bulk
Module 9: Authenticating and Authorizing Users
Lessons
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
Module 10: Assigning Server and Database Roles
Lessons
- Working with Server Roles
- Working with Fixed Database Roles
- Creating User-defined Database Roles
Module 11: Authorizing Users to Access Resources
Lessons
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
Module 12: Auditing SQL Server Environments
Lessons
- Options for Auditing Data Access in SQL
- Implementing SQL Server Audit
- Managing SQL Server Audit
Module 13: Automating SQL Server 2012 Management
Lessons
- Automating SQL Server Management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
Module 14: Configuring Security for SQL Server Agent
Lessons
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
Module 15: Monitoring SQL Server 2012 with Alerts and Notifications
Lessons
- Configuration of Database Mail
- Monitoring SQL Server Errors
- Configuring Operators, Alerts and Notifications
Module 16: Performing Ongoing Database Maintenance
This module covers database maintenance plans.
Lessons
- Ensuring Database Integrity
- Maintaining Indexes
Module 17: Tracing Access to SQL Server 2012
Lessons
- Capturing Activity using SQL Server Profiler
- Improving Performance with the Database Engine Tuning Advisor
- Working with Tracing Options
Module 18: Monitoring SQL Server 2012
Lessons
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
Module 19: Managing Multiple Servers
Lessons
- Working with Multiple Servers
- Virtualizing SQL Server
- Deploying and Upgrading Data-Tier Applications
Module 20: Troubleshooting Common SQL Server 2012 Administrative Issues
Lessons
- SQL Server Troubleshooting Methodology
- Resolving Service-related Issues
- Resolving Concurrency Issues
- Resolving Login and Connectivity Issues
Additional Topics
Programme scope, delivery arrangements and suitability are confirmed during enquiry.