TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
Intermediate
SQL Server

70-462: Administering Microsoft SQL Server 2012

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

 

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.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below: