Register Now for for Next Session start on 14th Jan 2023

Intermediat level
26 hrs duration

What you'll learn

  • Practical Skills on DB
  • Security and Maintenance on Database
  • Performance Optimization
  • Database Design and Implementation

Database Administration

Are you ready to dive into the heart of digital data management? The Database Administrator course is your gateway to mastering the art and science of efficiently handling vast amounts of information.

This course provides a comprehensive understanding of database systems, covering key areas such as database design, SQL proficiency, security implementation, and performance optimization.

  • Data structures and transaction logging
  • SQL Server recovery models
  • How to configure a database's recovery model property
  • Designing a backup strategy
  • Backup types
  • Advanced backup scenarios
  • Using database and log restore
  • Preparing for restore
  • Executing restores
  • Summary
  • Configuring SQL Server service accounts
  • Virtual accounts
  • Managed service accounts
  • gMSAs
  • Built-in system accounts
  • Domain user accounts and local Windows accounts
  • Authentication
  • Authorization
  • Auditing
  • Configuring credentials
  • Transparent Data Encryption
  • Always Encrypted
Load more ...

Quick Enquiry

Captcha : 6x2 = ?
Slide to give answer