The 70-462: Administering Microsoft SQL Server 2012 online training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.
Intermediate
70-462: Administering Microsoft SQL Server 2012
Curriculum
- 20 Sections
- 63 Lessons
- 13h Duration
Introduction to SQL Server 2012 and Its Toolset
3 Lessons
- Introduction to the SQL Server Platform
- Working with SQL Server Tools
- Configuring SQL Server Services
Preparing Systems for SQL Server 2012
3 Lessons
- Overview of SQL Server Architecture
- Planning Server Resource Requirements
- Pre-installation Testing for SQL Server
Installing and Configuring SQL Server 2012
3 Lessons
- Preparing to Install SQL Server
- Installing SQL Server
- Upgrading and Automating Installation
Working with Databases
3 Lessons
- Overview of SQL Server Databases
- Working with Files and File groups
- Moving Database Files
Understanding SQL Server 2012 Recovery Models
3 Lessons
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
Backup of SQL Server 2012 Databases
3 Lessons
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
Restoring SQL Server 2012 Databases
4 Lessons
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-time Recovery
- Restoring System Databases and Individual Files
Importing and Exporting Data
3 Lessons
- Transferring Data To/From SQL Server
- Importing & Exporting Table Data
- Inserting Data in Bulk
Authenticating and Authorizing Users
3 Lessons
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
Assigning Server and Database Roles
3 Lessons
- Working with Server Roles
- Working with Fixed Database Roles
- Creating User-defined Database Roles
Authorizing Users to Access Resources
3 Lessons
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
Auditing SQL Server 2012 Environments
3 Lessons
- Options for Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
Automating SQL Server 2012 Management
3 Lessons
- Options for Auditing Data Access in SQL Server
- Implementing SQL Server Audit
- Managing SQL Server Audit
Configuring Security for SQL Server Agent
3 Lessons
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
Monitoring SQL Server 2012 with Alerts and Notifications
4 Lessons
- Overview of Database Mail
- Database Mail Profiles
- Database Mail Security
- Database Mail Logs and Retention
Performing Ongoing Database Maintenance
3 Lessons
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Tracing Access to SQL Server 2012
3 Lessons
- Capturing Activity Using SQL Server Profiler and Extended Events Profiler
- Improving Performance with the Database Engine Tuning Advisor
- Working with Tracing Options
Monitoring SQL Server 2012
3 Lessons
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
Managing Multiple Servers
3 Lessons
- Working with Multiple Servers
- Virtualizing SQL Server
- Deploying and Upgrading Data-tier Applications
Troubleshooting Common SQL Server 2012 Administrative Issues
4 Lessons
- SQL Server Troubleshooting Methodology
- Resolving Service-related Issues
- Resolving Login and Connectivity Issues
- Resolving Concurrency Issues
