Oracle Cloud DBA – Upgrading from DBA to Cloud DBA
The Oracle Cloud DBA course is designed to equip database administrators with the skills and knowledge required to transition from traditional on-premises database administration to cloud-based administration. Participants will gain hands-on experience through step-by-step labs covering various aspects of Oracle Cloud Database Administration. The course covers topics such as creating and managing virtual cloud networks, accessing user-managed and autonomous databases, administration, monitoring, patching, backup and restore, migration, and bonus modules on machine learning, Oracle Enterprise Manager, and other cloud services.
Database Administrators (DBAs) seeking to upgrade their skills to manage Oracle databases on the cloud.
- IT professionals involved in database administration and management.
- Individuals interested in learning Oracle Cloud Database Administration
Module 1: Database on Cloud: Overview & Options
- Introduction to Oracle Database on Cloud
- Understanding cloud deployment options
- Overview of Oracle Database as a Service (DBaaS)
- Exploring Oracle Autonomous Database
Module 2: OCI & Cloud Concepts for DBAs
- Understanding Oracle Cloud Infrastructure (OCI)
- Networking concepts in the cloud
- Security and access management in OCI
- High availability and disaster recovery options
Module 3: Networking for Cloud DBAs
- Creating Virtual Cloud Networks (VCN)
- Configuring subnets, security lists, gateways, and route tables
- Managing network connectivity
- Networking best practices for cloud DBAs
Module 4: Provisioning & Connecting
- Creating and accessing user-managed databases
- Creating and accessing autonomous databases
- Setting up Exadata DB Systems in OCI
- Database administration tasks (start, stop, clone, scale, manage)
Module 5: Administer Database on Cloud
- Monitoring and managing autonomous databases.
- Utilizing Oracle Machine Learning for SQL statements
- Command line utilities for cloud DBAs (DBaasCli, OCI CLI, DBCLI)
Module 6: Patching
- Patching user-managed databases and VM/BM DB Systems
- Patching Exadata DB Systems and cloud tooling
- Ensuring patching best practices and security updates
Module 7: Backup & Restore
- Backing up and restoring user-managed databases and VM/BM DB Systems
- Backup and restore strategies for autonomous databases
- Performing backup and restore operations on Exadata DB Systems
Module 8: Migrating (Lift & Shift)
- Migrating on-premises databases using standalone backup in OCI
- Transporting tablespaces for on-premises database migration
- Migrating Oracle databases using import/export into Autonomous Data Warehouse
- Loading data into Autonomous Data Warehouse
US$ 2,300 to cover tuition and training materials only.