Administering Microsoft SQL Server 2012/14/16 Databases (70-462) Course
Course Features:
Live Instructor Teaching
Certificate of Completion
Courseware: Print
Hands-On Learning?: Yes
Software Lab Included?: Yes
Delivery Methods:
Individuals and Groups
@ Your Location
Group Teams
@ Your Organization
This is an instructor-led course. It is taught by an instructor
live online or at organizations for groups.
For
team training, we can teach onsite at your office or private live online.
How Online Classes Work? - Learn How Our Live Online Classes Work
Course Overview
This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access.
Register Early: Registration Deadline is 2 Weeks Prior to Class Start.
Course Notes
Course Taught With: 2012 software
SQL Server Versions That Can Attend: 2016, 2014, and 2012
Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.
Course Topics
Chapter 1 Planning and Installing SQL Server 2012
Lesson 1: Planning Your Installation
Lesson 2: Installing SQL Server and Related Services
Chapter 2 Configuring and Managing SQL Server Instances
Lesson 1: Configuring SQL Server Instances
Lesson 2: Managing SQL Server Instances
Chapter 3 Configuring SQL Server 2012 Components
Lesson 1: Configuring Additional SQL Server Components
Lesson 2: Managing and Configuring Databases
Chapter 4 Migrating, Importing, and Exporting
Lesson 1: Migrating to SQL Server 2012
Lesson 2: Exporting and Importing Data
Chapter 5 SQL Server Logins, Roles, and Users
Lesson 1: Managing Logins and Server Roles
Lesson 2: Managing Users and Database Roles
Chapter 6 Securing SQL Server 2012
Lesson 1: Managing Database Permissions
Lesson 2: Troubleshooting SQL Server Security
Lesson 3: Auditing SQL Server Instances
Chapter 7 Mirroring and Replication
Lesson 1: Mirroring Databases
Lesson 2: Database Replication
Chapter 8 Clustering and AlwaysOn
Lesson 1: Clustering SQL Server 2012
Lesson 2: AlwaysOn Availability Groups
Chapter 9 Troubleshooting SQL Server 2012
Lesson 1: Working with Performance Monitor
Lesson 2: Working with SQL Server Profiler
Lesson 3: Monitoring SQL Server
Lesson 4: Using the Data Collector Tool
Lesson 5: Identifying Bottlenecks
Chapter 10 Indexes and Concurrency
Lesson 1: Implementing and Maintaining Indexes
Lesson 2: Identifying and Resolving Concurrency Problems
Chapter 11 SQL Server Agent, Backup, and Restore
Lesson 1: Managing SQL Server Agent
Lesson 2: Configuring and Maintaining a Backup Strategy
Lesson 3: Restoring SQL Server Databases
Chapter 12 Code Case Studies
Explore SQL Server Classes Near Me: