In SQL Server 2016 - Administration training course, you will learn the skills required to maintain a Microsoft SQL Server database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent./p>
By attending SQL Server 2016 - Administration workshop delegates will learn 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
- 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.
This SQL Server 2016 - Administration class is intended for IT Professionals & Database Administrators.