Administering Microsoft SQL Server 2012 Databases

CC004625D: Administering Microsoft SQL Server 2012 Databases (5-Day Class. $2,500.00 per student)

(Microsoft 70-462 Exam Prep)

Please contact us for 2015 dates or to schedule a private session for your group

Description

Overview: Students will gain 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

Audience: The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job

Prerequisite

Students who attend this training should already have the following technical knowledge: – Basic knowledge of the Microsoft Windows operating system and its core functionality. – Working knowledge of Transact-SQL. – Working knowledge of relational databases

Topics Covered

    • Introduction to SQL Server 2012
    • Preparing and Installing SQL Server 2012
    • Working with Databases
    • Understanding Recovery Models
    • Backup and Restore
    • Importing and Exporting Data
    • Authenticating and Authorizing Users
    • Assigning Server and Database Roles
    • Automation of Database jobs
    • Configuring Security
    • Monitoring with Alerts and Notifications
    • Performing Maintenance
    • Database Server tracing
    • Troubleshooting and Performance
    • Managing multiple servers
    • High Availability Overview

Cancellation Policy

We understand that things come up. However, when you register for a class, a spot will be reserved for you! You will receive a full refund if you cancel a week before the training class. 80% of the class fees will be refunded if a cancellation occurs more than 3 days from the day of the class and within a week. Cancellations within 3 days of the class will trigger a 50% refund.