| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Call for In Class or Live Virtual Dates | 5 | $3,695 USD | Purchase |
Administering a SQL Database
This instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, you will learn to carry out these important tasks.
Duration: 5 Days
Prerequisites
- Experience using applications on Windows Servers
- Experience working with SQL Server or another RDMS
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
- Use encryption and auditing features to protect data
- Describe recovery models and backup strategies
- Backup and 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
