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
...
