Industry Certifications for IT & Management:
Administering Microsoft SQL Server 2014 Databases M20462 Training Course
500 Learners
Foundation
This five-day in-class course provides students who administer and maintain SQL Server databases with the knowledge and skills to help a SQL server database infrastructure. Additionally, it will be helpful to individuals who develop applications that deliver content from SQL Server databases.
Administering Microsoft SQL Server 2014 Databases M20462 Training Course
Accreditation With
Administering Microsoft SQL Server 2014 Databases Training Overview
At a time when data management could be what stands between business success and being overtaken by competitors, businesses are quick to recruit professionals with the capabilities to introduce a new, more desirable system into their organization. This Administering a SQL Database Infrastructure course equips professionals with the ability to do the same.
What You Will Learn?
  • Install and configure
  • Maintain instances and databases
  • Optimise and troubleshoot
  • Manage data
  • Implement security
  • Implement high availability
Course Key Features
  • Train and study for the 70-462 Microsoft SQL Server examination. Microsoft exam preparation guidance, course materials and pre & post-course support.
  • Accredited Microsoft Training provider as a Microsoft Learning Partner.
Training Options
Will be available soon
Administering Microsoft SQL Server 2014 Databases M20462 Training Schedules
You can get this course with 0 training options and 0 venues
Filter:
Corporate Team Training Enquiry
Corporate Team Training Enquiry
Administering Microsoft SQL Server 2014 Databases M20462 Training Curriculum
Eligibility
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their immediate area of responsibility or work in environments where databases play a crucial role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
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 experiences with database design.
Course Content
Section 01 - Module 1: SQL Server Security
Authenticating Connections to SQL Server
Authorizing Logins to Connect to databases
Authorization Across Servers
Partially Contained Databases
Create Logins
Create Database Users
Correct Application Login Issues
Configure Security for Restored Databases
Section 02 - Module 2: Assigning Server and Database Roles
Working with server roles
Working with Fixed Database Roles
Assigning User-Defined Database Roles
Assigning Server Roles
Assigning Fixed Database Roles
Assigning User-Defined Database Roles
Verifying Security
Section 03 - Module 3: Authorizing Users to Access Resources
Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level
Granting, Denying, and Revoking Permissions on Objects
Granting EXECUTE Permissions on Code
Granting Permissions at the Schema Level
Section 04 - odule 4: Protecting Data with Encryption and Auditing
Options for auditing data access in SQL Server
Implementing SQL Server Audit
Managing SQL Server Audit
Protecting Data with Encryption
Working with SQL Server Audit
Encrypt a Column as Always Encrypted
Encrypt a Database using TDE
Section 05 - Module 5: Recovery Models and Backup Strategies
Understanding Backup Strategies
SQL Server Transaction Logs
Planning Backup Strategies
Plan a Backup Strategy
Configure Database Recovery Models
Section 06 - Module 6: Backing Up SQL Server Databases
Backing Up Databases and Transaction Logs
Managing Database Backups
Advanced Database Options
Backing Up Databases
Performing Database, Differential, and Transaction Log Backups
Performing a Partial Backup
Section 07 - Module 7: Restoring SQL Server 2016 Databases
Understanding the Restore Process
Restoring Databases
Advanced Restore Scenarios
Point-in-Time Recovery
Restoring a Database Backup
Restring Database, Differential, and Transaction Log Backups
Performing a Piecemeal Restore
Section 08 - Module 8: Automating SQL Server Management
Automating SQL Server management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Multi-server Management
Create a SQL Server Agent Job
Test a Job
Schedule a Job
Configure Master and Target Servers
Section 09 - Module 9: Configuring Security for SQL Server Agent
Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts
Analyzing Problems in SQL Server Agent
Configuring a Credential
Configuring a Proxy Account
Configuring and testing the Security Context of a Job
Section 10 - Module 10: Monitoring SQL Server with Alerts and Notifications
Monitoring SOL Server Errors
Configuring Database Mail
Operators, Alerts, and Notifications
Alerts in Azure SOL Database
Configuring Database Mail
Configuring Operators
Configuring Alerts and Notifications
Testing Alerts and Notifications
Section 11 - Module 11: Introduction to Managing SQL Server by using PowerShell
Getting Started with Windows PowerShell
Configure SOL Server using PowerShell
Administer and Maintain SOL Server with PowerShell
Managing Azure SOL Databases using PowerShell
Getting Started with PowerShell
Using PowerShell to Change SOL Server settings
Section 12 - Module 12: Tracing Access to SQL Server with Extended events
Extended Events Core Concepts
Working with Extended Events
Using the System_Health Extended Events Session
Tracking Page Splits Using Extended Events
Section 13 - Module 13: Monitoring SQL Server
Monitoring activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data
SQL Server Utility
Section 14 - Module 14: Troubleshooting SQL Server
A Trouble Shooting Methodology for SQL Server
Resolving Service Related Issues
Resolving Connectivity and Log-in issues
Troubleshoot and Resolve a SQL Login Issue
Troubleshoot and Resolve a Service Issue
Troubleshoot and Resolve a Windows Login Issue
Troubleshoot and Resolve a Job Execution Issue
Troubleshoot and Resolve a Performance Issue
Section 15 - Module 15: Importing and Exporting Data T
Transferring Data to and from SQL Server
Importing and Exporting Table Data
Using bcp and BULK INSERT to Import Data
Deploying and Upgrading Data-Tier Application
Import and Excel Data Using the Import Wizard
Import a Delimited Text File Using bcp
Import a Delimited Text File using BULK INSERT
Create and Test an SSIS Package to Extract Data
Deploy a Data-Tier Application
Administering Microsoft SQL Server 2014 Databases M20462 Exam & Certification
On successful completion of this training course, an AVEREST Certificate will be awarded to the delegates
Administering Microsoft SQL Server 2014 Databases M20462 Exam & Certification
You Maybe Interested
Let Us Help You!
Please fill the contact form and we'll get back to you soon.