OCP Student Learning Subscription

This subscription includes the complete training program and certifications for technical professionals seeking to become Oracle Certified as Oracle database administrators and developers on both the cloud and on-premises versions of Oracle Database.

This subscription will:

• Prepare you to obtain an Oracle Database Administration 2019 Certified Professional credential (Available only in China)
• Help you navigate the world of database administration in Oracle Cloud
• Teach you how to perform administration tasks related to Oracle databases that are hosted on Oracle Cloud and then help you prepare to earn the Oracle Database Administration Specialist certification credential.

This learning subscription includes the following certifications:

• Oracle Database Administration Specialist (1Z0-912)
• Oracle Database Administration I (1Z0-082-CHN)
• Oracle Database Administration II (1Z0-083-CHN)

This subscription includes the complete training program and certifications for technical professionals seeking to become Oracle Certified on Java and Oracle Visual Builder Studio products. You’ll also be introduced to the world of intelligent digital assistants and learn how you can build them quickly and easily with Oracle Digital Assistant.

You’ll learn to:

• Build applications using Java programming
• Deploy Java applications
• Use Oracle tools to build cloud-based applications
• Build digital assistants quickly and easily with Oracle Digital Assistant

This learning subscription includes the following certifications:

• Java SE 11 Developer (1Z0-819)
• Java SE 11 Developer (1Z0-819-CHS)
• Oracle Cloud Visual Builder Studio 2023 Application Associate (1Z0-1097-23)

This learning subscription includes the complete training program and certifications for technical professionals seeking to become Oracle Certified as MySQL administrators and developers on the MySQL database product, as well as on using SQL and PL/SQL in Oracle Database.

You’ll learn to:

• Develop data-driven applications with MySQL 8.0
• Understand JSON document stores, connectors, error handling, and spatial data and improve the performance of your applications
• Install, configure, monitor, and secure your MySQL 8.0 infrastructure
• Create effective backup strategies and replication topologies, create InnoDB clusters, and optimize your server and cluster performance
• Perform data definition language (DDL) and data manipulation language (DML) statements and employ the powerful SQL programming language, in addition to learning relational database concepts
• Write code snippets using PL/SQL and learn the characteristics of PL/SQL and how it’s used to extend and automate SQL

This learning subscription includes the following certifications:

• MySQL 8.0 Database Developer (1Z0-909)
• MySQL 8.0 Database Administrator (1Z0-908)
• MySQL 8.0 Database Administrator (1Z0-908-CHS)
• Oracle Database SQL Specialist (1Z0-914)
• Oracle Database Program with PL/SQL Specialist (1Z0-913)

This learning subscription includes access to course videos and online student guides that will help you learn how to use Oracle Data Guard and demonstrate how this solution protects your Oracle database against planned and unplanned downtimes.

You’ll learn to:

• Create a physical standby database by using SQL and Oracle Recovery Manager commands
• Manage physical standby files after structural changes to the primary database
• Use Oracle Active Data Guard to offload supported workloads to a read-only standby instance
• Use Oracle Active Data Guard to create far sync instances and for real-time cascading
• Create and manage a snapshot standby database
• Create a logical standby database
• Create and monitor a Data Guard broker configuration
• Configure data protection modes
• Optimize and tune a Data Guard configuration
• Perform role transitions
• Use a flashback database in a Data Guard configuration
• Enable a fast-start failover
• Assess backup and recovery considerations in a Data Guard configuration
• Patch and upgrade databases in a Data Guard configuration

This learning subscription includes access to course videos and online student guides that will help you learn about Oracle Real Application Clusters (RAC) database architecture and take you on a deep dive into global resources and Cache Fusion.

You’ll learn to:

• Install and configure Oracle RAC
• Manage an Oracle RAC database
• Upgrade and patch an Oracle RAC database
• Manage backup and recovery for Oracle RAC
• Monitor and tune an Oracle RAC database
• Manage the high availability of services
• Implement high availability for connections and applications
• Configure an Oracle RAC One Node database
• Implement an Oracle Database In-Memory column store in Oracle RAC
• Configure multitenant architecture in Oracle RAC
• Manage quality of service in Oracle RAC

This learning subscription includes access to course videos and online student guides that will help you learn the new and enhanced features of Oracle Database 19c related to areas such as the database in general, security, availability, performance, big data and warehousing, and diagnosability.

Learn about new features, capabilities, and enhancements related to:

• Oracle Database in general, such as the Oracle Database Configuration Assistant, Oracle Universal Installer, and Data Pump enhancements
• Security, such as key management of encrypted Oracle-managed tablespaces in Transparent Data Encryption, and Oracle Database Vault operations control
• Availability, such as the recovery catalog connection when a user is connected to a target database such as a pluggable database (PDB)
• Performance, such as PDB-level Automatic Database Diagnostic Monitor analysis, Memoptimized Rowstore—Fast Ingest deferred writes, and Real-Time SQL Monitoring
• Data warehousing, such as hybrid partitioned tables and automated indexing
• Diagnosability, such as an end-to-end automated service for fault prediction, detection, and fixation to avoid or minimize human intervention, and new service request data collections that determine the data to collect for crucial errors
• Sharding, such as support for multiple PDB shards in the same container database and support for multiple table families in system-managed sharded databases