Oracle 19C Database Administration is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies.
Learning Objectives:
- Describe Oracle Database architecture
- Describe Oracle Database Cloud Service (DBCS) architecture and features
- Create and manage DBCS database deployments
- Configure the database to support your applications
- Manage database security and implement auditing
- Implement basic backup and recovery procedures
- Move data between databases and files
- Employ basic monitoring procedures and manage performance
Who Should Go For This Training?
This hands-on course is geared for experienced DBAs new to Oracle 19c.
Course Outline:
- Introduction
- Exploring Oracle Database Architecture
- Oracle Database Management Tools
- Managing the Database Instance
- Administering User Security
- Managing Database Storage Structures
- Managing Space
- Implementing Oracle Database Auditing
- Backup and Recovery: Concepts
- Backup and Recovery: Configuration
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Database Maintenance
- Managing Performance: SQL Tuning
- SQL Tuning
Learn more about Oracle Database 19c: Administration at NetCom Learning.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.