Managing Oracle Cloud Autonomous Databases

Compare on-premises data centers with cloud computing, examining costs, benefits, challenges, service and deployment models, and cooling, ups, monitoring, and security components.

Explore cloud computing as a web-based service for provisioning servers, storage, and applications with scalable, cost effective resources; understand IaaS, PaaS, SaaS and autonomous databases in cloud services.

Compare public, private, hybrid, and community cloud models, including pay-as-you-go services and on-premises data centers, and explore how management, costs, and service models shape cloud adoption.

Learn how Oracle cloud infrastructure (oci) implements cloud service models, regions and availability domains, and core components like compute instances, object storage, networking, and identity and access management.

Explore Oracle cloud services, including regions, availability domains, virtual and bare metal instances, compartments, and the console, as you learn core OCI terminology and free trial basics.

Sign up for Oracle Cloud by creating a Gmail account and an OCI account with a valid email, mobile number, and credit card to access the service.

Introduce Oracle database services, compare fully user managed, cloud service, bare metal, exudate cloud service, and autonomous options, and note shared versus dedicated infrastructure.

Learn how Oracle autonomous databases automate backups, upgrades, tuning, and security, reducing maintenance and cost. Explore the three workloads: data warehouse, transaction processing, and JSON database, and key restrictions.

Examine the Oracle Autonomous Database features, certification paths, and data movement realities, and learn how automation reshapes DBA roles toward data analysis, modeling, and development.

Provision autonomous databases in Oracle Cloud via the OCI console and CLI or API by configuring compartment, database name, workload, cpu, storage, admin password, network access, and license type.

Provision an autonomous database in the OCI interface, set workload and always free, configure admin credentials, and use sequel developer to execute statements and monitor progress via work requests.

Provision, scale up or down, and manage autonomous databases in Oracle Cloud Infrastructure using Cloud Shell and the OCI CLI, including auto scaling and querying database details.

Manage users on autonomous databases by creating, altering, and deleting accounts, granting privileges, enforcing password complexity with hardened profiles, configuring workspaces, and enabling SQL Developer Web access.

Create and manage application users on autonomous databases by provisioning users, granting schema privileges, assigning dedicated profiles, and enabling access to SQL Developer Web.

Learn how to connect to autonomous databases using wallet files, enabling encrypted connections, downloading regional wallets from OCI, and applying service names with Sequel developer.

Learn how to connect to autonomous databases using sequelae plus and SQL Developer, configure wallet files, and test cloud wallet connections to ATP/ADB with DBRS in a practical setup.

Download the Oracle instant client and install basic, sqlplus, and tools packages, set up and source environment variables, and verify connections to autonomous databases with sqlplus.

Learn to send emails from Oracle autonomous databases using the utl_smtp package and OCI email delivery service, including creating SMTP credentials, approved senders, and access grants.

Learn to enable email delivery from Oracle Autonomous Databases by configuring SMTP, creating credentials and an approved sender, and deploying a PL/SQL procedure to send emails.

Learn the fundamentals of Oracle Cloud object storage, including hot versus archival storage, namespace and buckets, and how to upload, download, and delete objects using the console or CLI.

Explore object storage fundamentals, deleting single and bulk objects by prefix or folder, reference objects in buckets using native, swift, and pre authenticated request uri formats, and set time-bound access.

Learn to manage directories in autonomous databases with the DBMS cloud package, create root and subdirectories, and move files using get_object and put_object between object storage and database directories.

Learn to manage database directories in autonomous databases, create and use auth tokens for OCI users, and deploy credentials with dbms_cloud to copy files between databases and object storage.

Practice managing directories in autonomous databases by creating and listing directory objects, uploading a file to object storage, and copying it to the staging directory using generated tokens and credentials.

Learn how to move data to autonomous databases using data pump export/import, move to autonomous database, sequel developer, and Golden Gate, with object storage checksums.

Explore moving data to autonomous databases using data pump, transform perimeter settings, and data load verification via checksums; configure encryption, index naming, and external table creation.

Learn to migrate data to autonomous databases with data pump utilities, SQL Developer, MV to EDB tool, and Golden Gate, including loading CSB files and verifying transfers to object storage.

Practice 8 guides you to migrate core schema to the autonomous database ATP or Adibi, then load data from CSB files and use data pump and schema advisor tools.

Upload dump files to the staging bucket, verify integrity with checksums, then create preauthenticated requests and import the data into the autonomous database using data pump.

Practice moving data to autonomous databases by preparing a csv file, uploading to the staging bucket, loading into the target table, and using load operation logs for error diagnosis.

Move data from autonomous databases by exporting dump files with data pump, storing in object storage, and importing them into the destination database, considering the time zone file version.

Move data from autonomous databases using data pump utilities and cloud export data, explain time zone file version issues with data pump import, and implement external tables for migration.

Explore exporting data between Oracle Autonomous Databases using Data Pump, object storage, and DBMS Cloud; upgrade time zone files and recreate schemas before importing into a local database.

Export data from autonomous databases using data pump utilities into object storage. Download the dumps, then import them into pdb1 and validate with an external table.

Learn to monitor autonomous DBRS performance with the performance page and performance hub, using matrix charts for CBO utilization, storage utilization, sessions, and executions, and set alarms.

Explore how to stress test an autonomous database CPU and read performance charts in the OCI console; use AWR reports to diagnose blocking sessions and high wait events.

Learn how autonomous database maintenance windows schedule patches and upgrades in Oracle cloud. Discover how to monitor patch history, set upgrade notifications, and consider cloning or downtime.

Explore how autonomous databases patch and upgrade within maintenance windows, review DBRS timing, and learn to query, view, and adjust internal automated tasks and schedules.

Monitor work requests, configure alerts on metrics, and configure notifications on events for autonomous databases.

Explore how to use work requests, alarms, events, and notifications to monitor and manage an autonomous database, including restarting it and configuring a 95 percent cpu alert with email notifications.

Test alarms and notifications for Oracle Cloud autonomous databases by creating and validating alerts, email notifications, and rules for events like startup, shutdown, and CPU stress.