Live Instructor Teaching
Certificate of Completion
Courseware: Print
Free 6 Month Online Retake
Hands-On Learning?: Yes
Software Lab Included?: Yes
Individuals and Groups
@ Your Location
Group Teams
@ Your Organization
You have created databases and executed queries on them. You are now ready to perform database administration tasks such as installation of SQL Server instances, configuration of SQL Server databases and settings, monitoring database performance, controlling user access to databases, and database maintenance. In addition to these tasks, SQL Server provides many advanced features that enable you to manage databases efficiently. By familiarizing yourself with these tasks and features, you can plan, deploy, administer, and maintain SQL Server databases efficiently. In this course, you will perform database administration tasks.
Register Early: Registration Deadline is 2 Weeks Prior to Class Start.
Upon successful completion of this course, students will be able to administer SQL Server databases.
You will:
Course Taught With: 2012 software
SQL Server Versions That Can Attend: 2022, 2019, 2016, 2014, and 2012
This course is designed for Database Administrators who administer and maintain SQL Server databases. This course will be attended by database professionals who are familiar with SQL Server databases and who are responsible for administering and maintaining SQL Server databases as their primary job responsibility. In addition, this course can be attended by individuals who develop applications that access SQL Server database.
Lesson 2: Deploying SQL Server
Lesson 3: Configuring SQL Server
Lesson 4: Managing Databases in SQL Server
Lesson 5: Managing SQL Server Security
Lesson 6: Implementing Advanced Security Settings
Lesson 7: Applying Encryption and Compression
Lesson 8: Working with Indexes and Log Files
Lesson 9: Working with Backup and Restore
Lesson 10: Implementing High Availability
Lesson 11: Optimizing Server Performance
Lesson 12: Troubleshooting Issues and Recovering Databases
Lesson 13: Performing Advanced Database Management Tasks