Scroll to top button

Administering Microsoft SQL Server 2012/2014 Databases (Course & Lab)

ISBN : 9781644590881

Prepare for the Microsoft MCSA 70-462 certification exam with the Administering Microsoft SQL Server 2012/2014 Databases course and lab. The lab can be mapped to any course, textbook, or training, therefore, adding value and hands-on components to training. The course and lab provide complete coverage of the MCSA 70-462 exam objectives and will help you master the skills required for installing SQL server, implementing migration strategies, configuring SQL server components, managing SQL server, managing and configuring databases, collecting and analyzing troubleshooting data, restoring databases, implementing and maintaining indexes, managing database security, troubleshooting security, and implementing replication.

The Microsoft MCSA Administering Microsoft SQL Server 2012/2014 Databases certification validates candidates' expertise to administer Microsoft SQL Server. This certification is designed for professionals who perform installation, maintenance, and configuration tasks on various databases. Professionals who are responsible for setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access, can also take this certification.

Glossary of terms
Pre Assessment Questions
Post Assessment Questions
Performance lab
Learn the real world skills using LiveLab.
Video tutorials
Get interactive learning videos with transcripts and voice-over.
Signify the duration of video tutorials in labs.
Exam related FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE
What is the format of the exam? Single choice, multiple choice, drag-and-drop, active screen, build list, case studies, and short answer.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
Where can I find more information about this exam? To know more about the 70-462-v2, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

Administering Microsoft SQL Server 2012/2014 Databases certification qualifies you for a variety of exciting job roles including:

  • SQL Server Developer
  • SQL Database Administrator
  • SQL Server Database Integrator
  • SQl Server Database Administrator
  • Senior SQl Server Database Administrator
  • Evaluating Installation Requirements
  • Designing Installation of SQL Server
  • Installing Extra Features
  • Identifying Windows Level Security and Service Level Security
  • Benchmarking a Server
  • Selecting the Right Hardware
  • Testing Connectivity to SQL Server
  • Understanding Integration Services
  • Summary
  • Attaching and Detaching Databases
  • Migrating Logins
  • Understanding Migrations
  • Migrating to New Hardware
  • Migrating Data from Other Sources
  • Summary
  • Configuring Analysis Services
  • Configuring Reporting Services
  • Configuring SharePoint Integration
  • Configuring SSIS Security
  • Configuring Full-Text Indexing
  • Configuring FILESTREAM
  • Configuring FileTables
  • Summary
  • Creating a Job using SQL Server Management Studio
  • Creating T-SQL Jobs
  • Creating and Using Operators
  • Creating and Using Alerts
  • Summary
  • Designing Filegroups
  • Configuring and Standardizing Databases
  • Configuring Contained Databases
  • Using Data Compression
  • Configuring Transparent Data Encryption
  • Partitioning Tables and Indexes
  • Managing Log Files
  • Using Database Console Commands
  • Summary
  • Installing Default and Named Instances
  • Configuring SQL Server CPU Utilization
  • Configuring SQL Server
  • Virtualizing SQL Server
  • Configuring MSDTC in a Cluster
  • Setting a Fixed Amount of Memory
  • Setting up Database Mail
  • Introducing Fillfactor
  • Introducing sp_configure
  • Summary
  • Installing a Cluster
  • Removing an Installation
  • Monitoring and Managing a SQL Server Cluster
  • Patching Strategies for SQL Server
  • Managing Resource Utilization using Resource Governor
  • Cycling the SQL Server Error Log
  • Summary
  • Understanding Locks
  • Identifying Blocking
  • Detecting and Correcting Deadlocks
  • Monitoring via DMV
  • Monitoring via SQL Server Profiler
  • Monitoring Performance with System Monitor
  • Identifying Transactional Replication Problems
  • Working with Performance Monitor
  • Using SQL Server Data Collector
  • Summary
  • Implementing a Security Strategy in SQL Server
  • Configuring SQL Server Audit
  • Tracking Changes in SQL Server
  • Introducing Policy-Based Management
  • Summary
  • Backing Up a Database
  • Backing Up the Environment
  • Backing Up System Databases
  • Restoring a Database
  • Summary
  • Understanding Indexes
  • Implementing Basic Indexes
  • Understanding Statistics
  • Managing Indexes
  • Summary
  • Using bcp
  • Using SQL Server Integration Services
  • Summary
  • Understanding SQL Server Roles
  • Managing Logins, Users, and Roles
  • Understanding Encryption
  • Auditing SQL Server Activity
  • Summary
  • Introducing AlwaysOn Availability Groups
  • Deploying AlwaysOn Availability Groups
  • Using Availability Groups on Failover Cluster Instances
  • Understanding Failover Clustering
  • Installing a SQL Server Failover Cluster
  • Summary
  • Understanding Replication Architecture
  • Understanding Replication Types
  • Controlling Replication Behaviour
  • Monitoring Replication
  • Summary

Hands on Activities (Labs)

  • Installing SQL Server Integration Services
  • Detaching the Database in the GUI
  • Attaching the Database in the GUI
  • Using the Enable Contained Database feature
  • Migrating a Database to a New Version of SQL Server
  • Migrating Data from Other Sources
  • Installing SQL Server Analysis Services
  • Configuring SharePoint Integration
  • Configuring SSIS Security
  • Configuring Full-Text Indexing
  • Configuring FILESTREAM
  • Defining a SQL Server Operator using SSMS
  • Defining a SQL Server Operator using Transact-SQL
  • Designing Multiple Filegroups
  • Configuring and Standardizing Databases
  • Implementing Contained Databases
  • Configuring CPU and Memory Allocation
  • Configuring SQL Server Engine
  • Managing Resource Utilization by Using Resource Governor
  • Examining Deadlock Issues
  • Monitoring via DMV
  • Gathering Performance Metrics using Activity Monitor
  • Monitoring Data and Server Access
  • Configuring Server Audits
  • Managing Backups
  • Performing Differential Backup
  • Performing System Database Backup
  • Inspecting the Physical Characteristics of Indexes
  • Creating a Column-store Index
  • Creating Full-text Indexes
  • Performing Bulk Copy using the bcp utility
  • Exporting Data with the Import/Export Wizard
  • Managing Access to the Server
  • Managing Login and Server Roles
  • Managing Certificate Logins
  • Configuring Database Security
  • Protecting Objects from being Modified
  • Creating a SQL User without Login
  • Reviewing Certificates and Keys