1Z0-931- Oracle Autonomous Database Cloud Specialist

Learn to provision an autonomous database and connect via the oci console, including signing up for a free trial, finding and downloading the database credentials, and connecting to the service.

Explore Oracle cloud fundamentals by logging into a free account, navigating the console, managing regions, billing, and provisioning autonomous database services like autonomous transaction processing and autonomous data warehouse.

Explore core Oracle cloud infrastructure services for provisioning and connectivity, including compute, block storage, database, networking, dns, object storage, and security features.

Provision an autonomous data warehouse or autonomous transaction processing in Oracle Cloud, exploring compartments, display name, licensing options, autoscaling, and security controls with the provisioning progress.

Access the database tools, download the wallet, and connect using wallet-based credentials or connect strings. Explore SQL Developer Web, on-prem SQL Developer, Oracle Application Express, and Oracle Machine Learning.

Analyze active sessions and sql details in the performance hub, filter by sql id or hash, and manage resources with ocpu scaling and admin tools like wallet and notebooks.

Connect to the SQL developer web in your tenancy, log in with admin credentials, run a script to create tables, and use data modeler to visualize the schema.

Learn to use the cloud wallet for Oracle Autonomous Database connectivity by extracting wallet files, organizing per database, and testing connections with SQL Developer.

DBAs favor sqlplus for fast connectivity; configure the wallet in sqlnet.ora and set a dns admin variable to connect to the autonomous database using the employee high dns name.

Connect to an Oracle autonomous database via SSL with certificate authentication using a client credential wallet, and manage public keys for API calls across internet or FastConnect.

Establish connectivity to an autonomous database using public internet with ssl encryption or through Fastconnect via a service gateway for private access, ensuring port 1522 is open in the firewall.

Provision and connect to the Oracle autonomous database cloud service using the OCI consoles, download credentials and wallet, and configure the JDBC URL for secure access.

Explore migration options to Oracle Autonomous Database: data pump, GoldenGate, Datasync, Dbms Cloud. Load data via object storage with SQL Developer or Oracle Data Loader, using parquet, json, or csv.

Explore migration approaches to Oracle autonomous database, including data pump upgrades, GoldenGate, and Dbms Cloud with object storage, plus SQL Developer wizard for flat files and Excel.

Learn how Oracle object store serves as a staging area for autonomous database data, supporting multiple file types, enabling external table queries, and using latency tests to choose regions.

Quantify migration transfer time to the autonomous database to ensure operational continuity and sync the source with ADB using Oracle Golden Gate or the data transfer service to object store.

Migrate data to autonomous database tables with automated statistics during direct load operations, or manually gather stats after non-direct path loads, while Exadata optimizes performance with hybrid columnar compression.

Create a cloud Unix client server, install Oracle client, and perform hands-on data loading by configuring an always-free compute instance, a public subnet, and ssh keys for access.

Log in to an Oracle cloud compute instance via putty and install the Oracle client, sqlplus, and data pump tools to enable migration and data loading into the autonomous database.

Set up the environment and connect to the autonomous database using a wallet, mirroring cloud access from a laptop to an Oracle Cloud Infrastructure server by copying the wallet.

Learn how to migrate and load data into an autonomous database by preparing wallet configurations, copying and editing ora files, and validating access with sqlplus.

in this hands-on migration exercise, drop and recreate tables in the autonomous database, then export the employee database with data pump into dump files.

Import encrypted on-prem dump files into the autonomous database using data pump, with a data pump directory and parallelism, while supplying the encryption password and handling existing objects during import.

Migrate to autonomous database using data pump export in schema mode to export selected schemas, leverage parallelism aligned to cpus, and define object storage credentials with dbms cloud create credential.

Export the database with exclude options to prepare for import into autonomous database, then import with 16 parallel threads and credentials for faster transfer.

Set up a cloud database by provisioning a virtual machine-backed system named on prem, then perform a data pump export from on prem to the autonomous database in the cloud.

Learn to migrate and load data from an on-premises Oracle database into an autonomous database by exporting a pluggable database dump, creating a user, and configuring listener services.

Demonstrates migrating data from on-prem pdb to Oracle autonomous database by exporting tables, uploading the dump files to object storage, and loading into the autonomous database.

Practice migrating and loading data into an autonomous database by configuring credentials and wallet, updating sqlnet, preparing a data pump import parameter file, and using object storage.

Execute a data pump workflow by exporting on prem data, staging the dump in object storage, and importing it into the autonomous database via a pre-authenticated URL and PA file.

Migrate on-premises data to the autonomous database with Oracle Goldengate for real-time warehousing or operational reporting, using nonintegrated replicates, staging for downstream ETL, and batch merges of updates as inserts.

Unlock the admin user and create a separate target user with Oracle GoldenGate replication privileges. Prepare the on premise database with extracts, data pumps, and configure wallet and net files.

Configure Oracle Goldengate to migrate data to the Autonomous Database by creating wallets and user aliases, starting the manager, configuring replicate files, and loading data.

Use Datasync to migrate and load data into an Oracle autonomous database, with CSV, Excel, relational sources, etl/elt transformations, and parallel loads. Automate job scheduling and pre/post load processing.

Map source files to target tables in DataSync, configure import options, set a replace data load strategy, and run a job to load three tables from flat files.

Explore Oracle Autonomous Database object store integration for staging and loading data, and perform hands-on steps to create a user, download a wallet, and load or query files.

Connect to an Oracle autonomous database using SQL developer, configure a wallet-based connection, create a new user credential, and generate an authentication token for secure access to object store.

Create and use an object store credential to authorize a new user for running packages and procedures, then stage and upload files to object storage, monitoring progress.

Create tables with primary keys and constraints, then load channels, countries, customers, and demographics data from object store using json format, validating rows with logs.

Use SQL Developer to load data into an Oracle autonomous database cloud by connecting with a wallet, dropping and recreating the user, and running the load script.

Create and own new tables, then load channel data from a local csv file using SQL Developer, mapping columns and choosing an insert import method.

Demonstrates loading data from local and cloud storage into Oracle autonomous database cloud, using cloud file credentials, preview, and pipe-delimited import options with basic cleaning.

Map data by position to load an external table, fix column name mismatches, validate with a test, and complete the load using cloud load or dbms_cloud.

Manage Oracle autonomous database users, privileges, and on-demand start, stop, and scale via APIs. Learn backups, restores, and automation with SQL Developer, command line, and API tools.

Scale the autonomous database on the fly by adjusting CPU and storage, with auto scaling up to six CPU while online. Stop and start conserve resources, taking about 5–10 minutes.

Explore how Oracle Autonomous Database cloud service provides REST APIs for programmable management, enabling templates, version-controlled infrastructure stacks, and secure signed requests over TLS 1.2 using RSA SHA-256.

Connect to the on-prem server and configure a rest api script to manage autonomous databases, updating tenancy id, user id, and key fingerprint, and generate public and private keys.

Generate and secure RSA keys, publish the public key to your tenancy, configure fingerprints, and run an executable OCI script to connect to the autonomous database.

Use rest api calls to start and stop an autonomous database via curl scripts, with region endpoints and scaling scripts for automated resource management.

Configure and manage autonomous database scaling via REST API, updating storage from 1 to 2 terabytes online, and automating start, stop, and scale actions with CLI.

Learn to manage autonomous databases with the OCI cli, a Python tool mirroring rest api functionality across Mac, Windows, and Linux; install with an OCI account and signing key.

install and configure the oci cli with the curl-based installer from github, then run setup config to enter your oci id, tenancy id, region, and generate an rsa key pair.

Upload the public key via the console and use winscp to download it to the home opc directory; create a separate OCI CLI key folder to avoid overwriting existing keys.

Use the OCI CLI to query and create autonomous databases, including data warehouses and ATP, provisioning CPU cores and storage while exposing REST APIs.

Learn to manage autonomous data warehouses on OCI CLI: start, stop, scale CPU cores and storage, provision and delete databases using create and drop commands.

Explore autonomous database for experienced users, where the system configures and optimizes automatically, disabling admin tasks and direct server access while enabling default parallelism, hybrid columnar compression, and Unicode AL32UTF8.

Autonomous database automatically backs up your data for 60 days, enabling point-in-time recovery, while you can create manual backups stored in a cloud object storage bucket.

Create and manage object storage credentials, generate tokens, and set the default credential. Then back up, restore, and restart the database after restoration.

Learn how Oracle SQL Developer, a free IDE, enables end-to-end PL/SQL development, DBA tasks, and migration for autonomous databases, with hands-on guidance on connections and configuration.

Use sql developer to administer your oracle database, manage users and roles with privileges and ddl, and inspect data files and tablespaces across system, temp, and sample schemas.

Monitor autonomous database health, storage use, and CPU via the service console; review monitored SQL, and configure resource management rules and runaway criteria for consumer groups.

Oracle autonomous database automatically gathers optimizer statistics and batch-load hints, while users select a service level (low, medium, high, urgent) mapped to resource manager groups for parallelism and concurrency.

Enable monitoring and management of resource groups to control runaway queries by setting runtime and IO limits, canceling offending statements while keeping sessions connected, and viewing allocations via SQL Developer.

Describe how to connect the autonomous data warehouse with Oracle Analytics Cloud and Data Visualization Desktop using the wallet, OCI, ODBC, and JDBC connections.

Discover how Oracle analytic views simplify complex queries, improve performance with smart query transformation, and store business logic in the database for consistent reporting across multiple sources and time hierarchies.

Explore reporting and analytics with analytic views and hierarchies in Oracle autonomous database, enabling time and geographic comparisons, drill-down level selection, and built-in machine learning workflows.

Perform hands-on tasks in Oracle machine learning, create users, manage workspaces and permissions, build and run notebooks and charts, and share templates.

Execute sql scripts to create and populate a table with 1 to 100 inserts, export and import the script, and view results with charts in a machine learning hands-on session.

Install and launch Oracle Analytics on desktop and cloud, including download and login steps. Create analytics instances and data connections to Oracle Autonomous data warehouse for enterprise analytics.

Create and manage datasets in Oracle Cloud Analytics by connecting to enterprise data, selecting tables, converting data types, and using measures and attributes with Oracle Machine Learning and visualization.