
- This event has passed.
20764 Administering a SQL Database Infrastructure – Adelaide
February 3, 2020 @ 9:00 am - February 7, 2020 @ 5:00 pm UTC+10
$4100
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Administering a SQL Database Infrastructure
Overview
This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Download Course Outline View Schedule/Book OnlineWho Should Attend
This course is intended for individuals who:
- Administer & maintain SQL Server databases
- Perform database administration & maintenance or work in environments where databases play a key role in their job
- Who develop applications that deliver content from SQL Server databases
Course Objectives
After completing this course, participants will be able to:
- 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
Course Prerequisites
Before attending this course, participants must have, in addition to their professional experience:
- A basic knowledge of the Microsoft Windows operating system
- Working knowledge of Transact-SQL
- Working knowledge of relational databases
- Some experience with database design