Administering Microsoft SQL Server 2016 database

This SQL course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining an Access Control or Video Management SQL database in the field.

After completing this course, students will be able to:

Describe core database administration tasks and tools.
Install & configure SQL Server 2016.
Configure SQL Server database & storage.
Plan & implement a backup strategy.
Restore databases from backups.
Import & export data.
Monitor SQL server.
Trace SQL server activity.
Manage SQL server security.
Audit data access & encrypt data.
Perform ongoing database maintenance.
Automate SQL server maintenance with SQL Server Agent Jobs.
Configure Database Mail, alerts & notifications.

Course content

Module 1: Introduction to SQL Server 2016 Database Administration
Module 2: Installing & Configuring SQL Server 2016
Module 3: Working with Databases & Storage
Module 4: Planning & Implementing a Backup Strategy
Module 5: Restoring SQL Server 2016 Databases
Module 6: Importing & Exporting Data
Module 7: Monitoring Microsoft SQL 2016
Module 8: Tracing SQL Server Activity
Module 9: Managing SQL Server Security
Module 10: Auditing Data Access & Encrypting Data
Module 11: Performing Ongoing Database Maintenance
Module 12: Automating SQL Server 2016 Management
Module 13: Monitoring SQL Server 2016 by using Alerts & Notifications

 

Course cost

Individual
R9,900 p/p

Group
R9,100 p/p

Course Duration
Five Days

Every individual that attends this course will receive a comprehensive training manual as well as an attendance certificate. Catering will be provided over the duration of this course

Gallery, coming soon!