What You'll Learn
- Authenticate and authorize users.
- Assign server and database roles.
- Authorize users to access resources.
- Protect data with encryption and auditing.
- Recovery models and backup strategies.
- Back up SQL Server databases.
- Restore SQL Server databases.
- Automate database management.
- Configure security for the SQL Server agent.
- Manage alerts and notifications.
- Manage SQL Server using PowerShell.
- Trace access to SQL Server.
- Monitor a SQL Server infrastructure.
- Troubleshoot a SQL Server infrastructure.
- Import and export data.
- 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.
Who Needs To Attend
- Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job.
- Individuals who develop applications that deliver content from SQL Server databases.