Duration
2 days
OVERVIEW
This course teaches you how to perform common, day-to-day administrative tasks that are required of an Oracle database administrator (DBA).
The course covers the following topics:
- Install the Oracle Database Software and Create a Database
- Use Enterprise Manager Database Express
- Use SQL*Plus and SQL Developer
- Use the Listener Control Utility
- Use SQL Developer to Shut Down and Restart a Database
- View Initialization Parameters
- Manage the Database Storage Structures
- Administer Users and Security
- Create Application Tables and Load Database
- Perform Backup and Recovery
- Monitor Database Performance
SKILLS COVERED
After completing this course, you will be able to:
- Install Oracle Database 19c software and create a database.
- Use Enterprise Manager Database Express to manage the database.
- Manage database storage structures and schema objects.
- Administer users and security.
- Backup and recover the Oracle Database.
- Monitor the database and use the Advisors.
- Gain an understanding of the Oracle Database Cloud Service.
WHO SHOULD ATTEND?
This course intended for Database Administrator, Database Developer, System Administrator.
PREREQUISITES
Basic knowledge of computers.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.