Contact Us 978.250.4983

Microsoft SQL Server 2016 Administration

Duration: 35 hours

Prerequisites: Familiarity with database concepts, The SQL Programming course is highly recommended although not required.

Course Description: This course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Students Will Learn:

  • Installing and configuring SQL Server 2016
  • Authenticating and authorizing users
  • 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 database management
  • Configuring security for the SQL Server agent
  • Managing alerts and notifications
  • Tracing access to SQL Server
  • Monitoring a SQL Server infrastructure
  • Troubleshooting a SQL Server infrastructure
  • Importing and exporting data
  • Creating a high availability solution

Related Bootcamps:

Track Duration Price
Master SQL Server Developer 5-course track $6,000
SQL Server Administrator 2-course track
3-course track
SQL Server Business Intelligence Developer 3-course track
4-course track
Copyright© Developer Bootcamp