Learn Oracle Data Platform fundamentals and prepare for the 1Z0-1195-25 exam. Explore Autonomous Database, Data Lakehouse, Analytics and OCI data management.

Syllabus

Data Management Introduction

In this track, learn about the Oracle Data Platform 2025 Foundations Associate exam, covering key topics like Autonomous Database, Exadata, Base Database Service, and Converged Database. Focus is on foundational knowledge, multicloud strategies, and performance optimization, helping learners prioritize study efforts for certification success.

Autonomous Database and Tools

This track covers the fundamentals of Oracle Autonomous Database (ADB), including provisioning, deployment models, and scaling. You will explore ATP, ADW, and AJD databases, secure connectivity, data management, and patching. The track emphasizes workload optimization, schema design, analytics, and low-code development with Oracle APEX, preparing users to leverage Oracle Cloud Infrastructure for diverse data-driven applications and real-time analytics.

Exadata and DBCS

This track provides a comprehensive overview of Oracle’s Base Database Service, multitenant architecture with CDBs and PDBs, Exadata engineered systems, advanced networking, and maintenance practices. You will gain practical knowledge in deploying, managing, and optimizing Oracle databases on OCI, including backup, migration, high availability, patching, upgrades, and security, preparing them for real-world cloud database operations.

MySQL and NoSQL

This course introduces Oracle MySQL HeatWave and Oracle NoSQL Database Cloud Service (NDCS), highlighting their capabilities for unified analytics, machine learning, and scalable, low-latency data management. You will explore the evolution of MySQL, HeatWave’s performance features, and NDCS’s flexible data models, high availability, and security, preparing them to leverage modern cloud database solutions for diverse enterprise workloads.

Converged Database

This track explores how Oracle Database evolved into a converged platform, supporting multiple data types and workloads. You will discover native support for structured, semi-structured, and blockchain data, and explore Oracle’s capabilities for text, spatial, and LOB data, as well as robust scaling and protection features.

Resiliency

This track explores Oracle Exadata Cloud@Customer operations, focusing on OpCtl, VM Cluster Node Subsetting, and Oracle Data Safe. You will gain skills in provisioning, patching, resource allocation, security assessments, and efficient database management in complex Exadata environments.

Developing on Oracle Database

This track covers Oracle Autonomous Database integrations, focusing on REST Data Services, web-based management tools, Data Studio for transformation and automation, Graph Studio for analytics, and OML Notebooks for machine learning within a unified data platform.

Data Lake, Data Warehouse and Machine Learning

This track introduces OCI Data Lakehouse and Oracle Machine Learning, focusing on unified data management, analytics, and integrated machine learning. You will learn how to store, process, and analyze diverse data types on Oracle Cloud Infrastructure for advanced insights and efficiency.

Upgrades and Migrations

This track introduces Oracle database migration strategies, tools, and best practices, including logical and physical migrations, automation, rollback safeguards, and performance optimization, ensuring efficient, secure, and reliable transitions to modern Oracle environments.