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
Reviews
There are no reviews yet.