MCSA: SQL 2016 Database Administration s
This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.Get trained in SQL Server 2016 and gain the skills needed to unite the power of the cloud with the demand for deeper insight into customer data. These courses also prepare you for certification on Microsoft SQL Server.
Course Objectives
Database Administration Fundamentals
- Understand Core Database Concepts
- Create Database Objects
- Manipulate Data
- Understand Data Storage
- Administer a Database
Administering a SQL Database Infrastructure
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Protect data with encryption and auditing
- Describe recovery models and backup strategies
- Backup SQL Server databases
- Restore SQL Server databases
- Automate database management
- Configure security for the SQL Server agent
- Manage alerts and notifications
- Managing SQL Server using PowerShell
- Trace access to SQL Server
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
- Import and export data
Provisioning SQL Databases
- Provision a Database Server
- Upgrade SQL Server
- Configure SQL Server
- Manage Databases and Files (shared)
- Provision, migrate and manage databases in the cloud
Course Content Exam(s)
| Exame Name | Exame Number | Product Version | Exam Cost |
|
70-764 |
SQL Server 2016 |
$ 165 |
|
|
70-765 |
SQL Server 2016 |
$ 165 |
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.