Microsoft SQL Server 2016 – Administration
Microsoft SQL servers are used across many organizations to manage their database across the enterprise. Database administration and management are key in operational efficiency and optimization of resources in companies. A Microsoft SQL Server 2016 Certification can boost one’s career and improve the job opportunities offered in systems and database administration as well as infrastructure specialists.
About This Course
Microsoft SQL Server will provide best practices for implementing database and programmability objects in SQL Server 2016.
Certification training includes under this:
- MCSA SQL Database Administrator 2016 – This Course covers the tasks and tools involved in administering a SQL Server 2016 database infrastructure and also the objectives for exam 70-764: Administering a SQL Database Infrastructure.
Learning Objectives
Configure data access and auditing
Manage backup and restore of databases
Manage and monitor SQL Server instances
Manage high availability and disaster recovery
Target Audience
- Web Developers
- Software Developers
- Programmers
- Anyone who wants to pass Exam 70-764
Curriculum
74 Lessons30h
Encryption
Encryption Features
Transparent Data Encryption
Using Transparent Data Encryption
Configuring Always Encrypted
Encryption with Azure SQL Database
Backup Encryption
Creating an Encrypted Backup
Cell-level Encryption
Configure Connection Encryption
Troubleshooting Encryption
Practical Exercise
Data Access and Permissions
Auditing
Backing Up Databases
Restoring Databases
Managing Database Integrity
Monitoring Database Activity and Queries
SQL Server Instances
Indexes and Statistics
High Availability and Disaster Recovery
