Course Information
Course Objective
This MS SQL Server 2016 - Administering Database course provides participants the knowledge and skills to administer a SQL Server database infrastructure. This course is intended for database professionals who perform installation, maintenance and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently and regularly storing, backing up, and securing data from unauthorized access. Also intended for individuals who develop applications that deliver content from SQL Server databases.
Download course brochure.Course Fees
Course Fee : $2500
Regn Fee : $50
All fees subject to prevailing GST. (Contact Customer Service @ 6333 4843)
Course Prerequisite
Before taking this course, you should have:
• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Working knowledge of relational databases
• Some experience with database design
Course Outline
1.0 SQL Server Security
Download course brochure
2.0 Assigning Server and Database Roles
3.0 Authorizing Users to Access Resources
4.0 Protecting Data with Encryption and Auditing
5.0 Recovery Models and Backup Strategies
6.0 Backing Up SQL Server Databases
7.0 Restoring SQL Server 2016 Databases
8.0 Automating SQL Server Management
9.0 Configuring Security for SQL Server Agent
10.0 Monitoring SQL Server with Alerts and Notifications
11.0 Introduction to Managing SQL Server by using PowerShell
12.0 Tracing Access to SQL Server with Extended events
13.0 Monitoring SQL Server
14.0 Troubleshooting SQL Server
15.0 Importing and Exporting Data