Microsoft SQL Server 2019 Administration
Duration: 35 hours
Prerequisites: Familiarity with database concepts
Students Will Learn:
- Installing and configuring SQL Server 2019
- 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
Course Description:
This course provides students who administer and maintain SQL Server 2019 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.
Course Overview:
Installation and Configuration
|
Authenticating and Authorizing Users
|
Assigning Server and Database Roles
|
Authorizing Users to Access Resources
|
Protecting Data with Encryption and Auditing
|
SQL Server Recovery Models
|
Backup of SQL Server Databases
|
Restoring SQL Server Databases
|
Tracing Access to SQL Server
|
Monitoring SQL Server
|
Troubleshooting SQL Server
|
Importing and Exporting Data
|
Maintaining High Availability of Data
|
Related Bootcamps:
Track | Duration | Price |
---|---|---|
Master SQL Server Developer | 5-course track 6-course track |
$6,000 $7,200 |
SQL Server Administrator | 2-course track 3-course track |
$2,400 $3,600 |