Microsoft 70-462: Administering SQL Server 2012 Databases

    £495.00

    Description

    Description

    This training course was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back-ups stored effectively, and securing data from unauthorized access is also a candidate for this training course on SQL 2012.

    Below is a partial list of job functions associated to this training course:

    • Audit SQL Server instances
    • Back up databases
    • Configure additional SQL Server components, Instances and Services
    • Deploying a SQL Server
    • Implementing strategies, column stores and High-Availability and Disaster Recovery solutions
    • Importing/exporting
    • Install SQL Server and related services.
    • Maintenance
    • Management, configuration, permissions, alerts, logins and roles.
    • Optimization
    • Installation Planning
    • Restoring
    • Troubleshooting

    The SQL 2012 Administering Databases course prepares you for the Microsoft Exam 70-462 – As the participant in the SQL 2012 Administering course will learn:

    • Installation Planning
    • Installing SQL Server and related services
    • Implementation of a migration strategy
    • How to configure additional SQL Server components
    • Managing the SQL Server Agent
    • Database management and configuration
    • How to configure SQL Server instances
    • Implementing a SQL Server clustered instance
    • SQL Server instances management
    • How to properly Identify and resolve concurrency problems
    • The collection of and how to analyze troubleshooting data
    • Auditing SQL Server instances
    • Configure and maintain a back up strategy
    • Database restoration
    • Implementing and maintaining indexes
    • Importing and exporting data
    • Managing logins and server roles
    • Managing database permissions
    • Managing users and database roles
    • Troubleshooting security
    • Implementing AlwaysOn, database mirroring and replication

    Syllabus:

    Module 1

    • Introduction to SQL Server 2012
    • SQL Server
    • SQL Server Tools
    • Management Studio Demo
    • Data Tools
    • Exam Scenarios
    • Module Review

    Module 2

    • Installing SQL Server
    • SQL Architecture
    • Hardware Requirements
    • Software Requirements
    • Installation Process
    • Troubleshooting Installation
    • Upgrading and Unattended Installations
    • Configuration Demo
    • Exam Scenarios
    • Module Review

    Module 3

    • Backup and Restore a Database
    • Database Architecture
    • Database Backup
    • Restoration Process
    • Restoring System Database
    • Backup and Recovery Dem0
    • Exam Scenarios
    • Module Review

    Module 4

    • Tracing Access to SQL Server
    • Auditing Option
    • Introduction to SQL Audit
    • Audit Objects and Implementation
    • Extended Events
    • Tracing Activity Demo
    • Exam Scenarios
    • Module Review

    Module 5

    • Importing and Exporting Data
    • Introduction to Data Transfer
    • ETL Tools
    • Improving Data Transfer
    • Copying Database Methods
    • Transferring Data Demo
    • Exam Scenarios
    • Module Review

    Module 6

    • SQL Server Security
    • Security and Authentication
    • Server and Database Roles
    • Permissions
    • Securing SQL Server Demo
    • Exam Scenarios
    • Module Review

    Module 7

    • Automating SQL Server
    • SQL Server Agent
    • Database Mail
    • Operators, Alerts and Jobs
    • Database Configuration Demo
    • Exam Scenarios
    • Module Review

    Module 8

    • Monitoring SQL Server
    • Dynamic Management Views and Functions
    • Profiler Trace
    • Database Tuning Advisor
    • Activity and Performance Monitor
    • Data Collection
    • Monitoring Demo
    • Exam Scenarios
    • Module Review

    Module 9

    • Maintaining SQL Server
    • Checking Database Integrity
    • Indexing
    • Ongoing Maintenance
    • Managing and Maintaining Demo
    • Exam Scenarios
    • Module Review

    Module 10

    • Troubleshooting SQL Server
    • Service Issues
    • Connectivity Issues
    • Locking Issues
    • Troubleshooting Demo
    • Exam Scenarios
    • Module Review
    • Program Review

    Course Delivery:    Online