SQL Server is a relational database management system -RDBMS that is widely used by a lot of organisations
to store and manage their data.
Database backup and recovery as well as securing the database from unauthorized access are key tasks performed by
Database administrators or anyone that closely works with or looks after databases.
if you are new to using SQL Server, this introductory course is where you want to begin. In
this course , we’ll cover the basics of how backup and recover databases. We will also cover how to implement security
measures that will protect the database from unauthorized access.
One of the things that separate mediocre DBAs from exceptional ones is that exceptional DBAs know how to use the tools available to them effectively.
This course is a practical hands-on that will teach you how to:
• Perform a full database backup
• Perform a database restore and recovery
• View and retrieve historical data using Flashback technology
• Recover and retrieve dropped tables
• Establish security measures to protect the database
• Manage user roles and privileges to the database
• Enabling Archive log mode
• Auditing Oracle Database users
• Predefined Oracle user accounts
After the end of this course , you will know how to :
• Backup and restore a database
• Manage database user access and security
• Recover dropped tables
• Use Oracle flashback technology.