TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
SQL Server

70-462: Administering Microsoft SQL Server 2012

ToIT ToIT
0 (0)
Duration

13h

Students

0

Level

Intermediate

Last Updated

November 15, 2024

70-462: Administering Microsoft SQL Server 2012
  • Overview
  • Curriculum
  • Reviews

 

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.

  • 20 Sections
  • 63 Lessons
  • 0 Quizzes
  • 13h Duration
Expand All

Introduction to SQL Server 2012 and Its Toolset

3 Lessons 0 Quizzes
  • Introduction to the SQL Server Platform
  • Working with SQL Server Tools
  • Configuring SQL Server Services

Preparing Systems for SQL Server 2012

3 Lessons 0 Quizzes
  • Overview of SQL Server Architecture
  • Planning Server Resource Requirements
  • Pre-installation Testing for SQL Server

Installing and Configuring SQL Server 2012

3 Lessons 0 Quizzes
  • Preparing to Install SQL Server
  • Installing SQL Server
  • Upgrading and Automating Installation

Working with Databases

3 Lessons 0 Quizzes
  • Overview of SQL Server Databases
  • Working with Files and File groups
  • Moving Database Files

Understanding SQL Server 2012 Recovery Models

3 Lessons 0 Quizzes
  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Backup of SQL Server 2012 Databases

3 Lessons 0 Quizzes
  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Restoring SQL Server 2012 Databases

4 Lessons 0 Quizzes
  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files

Importing and Exporting Data

3 Lessons 0 Quizzes
  • Transferring Data To/From SQL Server
  • Importing & Exporting Table Data
  • Inserting Data in Bulk

Authenticating and Authorizing Users

3 Lessons 0 Quizzes
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers

Assigning Server and Database Roles

3 Lessons 0 Quizzes
  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-defined Database Roles

Authorizing Users to Access Resources

3 Lessons 0 Quizzes
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Auditing SQL Server 2012 Environments

3 Lessons 0 Quizzes
  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Automating SQL Server 2012 Management

3 Lessons 0 Quizzes
  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit

Configuring Security for SQL Server Agent

3 Lessons 0 Quizzes
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts

Monitoring SQL Server 2012 with Alerts and Notifications

4 Lessons 0 Quizzes
  • Overview of Database Mail
  • Database Mail Profiles
  • Database Mail Security
  • Database Mail Logs and Retention

Performing Ongoing Database Maintenance

3 Lessons 0 Quizzes
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Tracing Access to SQL Server 2012

3 Lessons 0 Quizzes
  • 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 0 Quizzes
  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Managing Multiple Servers

3 Lessons 0 Quizzes
  • Working with Multiple Servers
  • Virtualizing SQL Server
  • Deploying and Upgrading Data-tier Applications

Troubleshooting Common SQL Server 2012 Administrative Issues

4 Lessons 0 Quizzes
  • SQL Server Troubleshooting Methodology
  • Resolving Service-related Issues
  • Resolving Login and Connectivity Issues
  • Resolving Concurrency Issues

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases
  • Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration
  • SQL Server 2012 security models, logins and users
  • Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles
  • Partial database containment option provided by SQL Server 2012
  • SQL Profiler
  • Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries
  • Auditing SQL Server 2012 environments
  • Monitoring and maintaining SQL Server 2012 databases
  • Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications

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:

Buy for group

70-462: Administering Microsoft SQL Server 2012
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)
Choose Group(s)
Sync Group(s)
Create a new group Go to Checkout