| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Dec 9, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 5 | $3,695 USD | Purchase |
| Jan 27, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 5 | $3,695 USD | Purchase |
| Mar 17, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $3,695 USD | Purchase |
| Apr 28, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $3,695 USD | Purchase |
| Jun 23, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 5 | $3,695 USD | Purchase |
Administering a SQL Database Infrastructure
This instructor-led course provides those who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.
Duration: 5 Days
Prerequisites
- Professional experience
- 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
Audience
- Individuals who administer and maintain SQL Server databases
- Individuals who develop applications that deliver content from SQL Server databases
Learning Objectives
- 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
Topics
- SQL Server Security
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Protecting Data with Encryption and Auditing
- Recovery Models and Backup Strategies
- Backing Up SQL Server Databases
- Restoring SQL Server Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SQL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server with Extended Events
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data
