Microsoft SQL Server 2012 Administration

Pre-Requisites: : Basic knowledge of the Microsoft Windows operating system and its core functionality. – Working knowledge of Transact-SQL. – Working knowledge of relational databases. – Some experience with database design.


Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance
  • Explores the skills you’ll need on the job as a SQL Server 2012 DBA
  • Discusses designing and implementing database solutions
  • Walks you through administrating, maintaining, and securing SQL Server 2012
  • Addresses implementing high availability and data distribution
  • Exam objectives for those seeking MSCA: SQL Server 2012 certification


As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this course will be perfect class for you. From understanding SQL Server’s roles to implementing business intelligence and reporting, this class explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them. 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. Students will be prepared for MCSA: SQL Server 2012 exams (70-461, 70-462, and 70-463).

  • Introducing SQL Server 2012
  • Installing SQL Server 2012
  • Working with the Administration Tools
  • SQL Server Command-Line Administration
  • Querying SQL Server
  • Designing Database Solutions
  • Database Concepts and Terminology
  • ERD and Capacity Planning
  • Normalization and Other Design Issues
  • Creating Tables
  • Triggers and Stored Procedures
  • Implementing Advanced Features
  • Administering and Maintaining SQL Server 2012
  • Creating Jobs, Operators, and Alerts
  • Performance Monitoring and Tuning
  • Policy-Based Management
  • Backup and Restoration
  • SQL Server Security
  • Security Threats and Principles
  • Authentication and Encryption
  • Security Best Practices
  • Implementing High Availability and Data Distribution
  • Always On and High Availability
  • SQL Server Failover Clustering
  • Database Mirroring and Snapshots
  • Implementing Replication
  • Implementing Business Intelligence and Reporting
  • Data Warehousing
  • SQL Server Integration Services
  • Data Quality Solutions

Course Number : MCTS-0-0432

Duration : 56 hours

1 Step 1

Request Information!

Who you are?

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

reCaptcha v3