This tutorial shows you how to install the Oracle Database 12c software on Microsoft Windows along with a default instance of an Oracle Database that contains example schemas ( including the HR schema).

This introductory series of short Oracle by Example tutorials will help you get started using Oracle Database 12c. These tutorials complement the Oracle Database 12c 2-Day DBA documentation.

This video explains some of the Oracle Database 12c architecture changes. This is an introductory video for the Oracle Database 12c Posters.

This video shows you the main components of the Oracle Database 12c new multitenant architecture.

This is list of videos includes various aspects of backup and recovery operations using the Oracle Recovery Manager (RMAN) for Oracle Database 12c. Most videos are at an introductory level, showing you how to perform a specific set of tasks.

This tutorial covers three important activities to help you manage pluggable databases: creating, modifying, plugging/unplugging

This video explains how to recover a pluggable database.

This demonstration shows you how to create a RAC-enabled CDB stored on ACFS. Then the demonstration shows you how to quickly clone an existing PDB using the SNAPSHOT COPY capability of ACFS.

This demonstration shows you the effect of stopping and starting manually created services on your PDBs in a RAC environment. This is to demo you do not need to create triggers to automatically start PDBs in a RAC environment.
 

This tutorial shows you what is new in partitioning an Oracle Database 12c. Topics include how to:

1. Use Interval Reference Partitioning
2. Perform Cascading TRUNCATE and EXCHANGE Operations
3. Move Partitions Online
4. Maintain Multiple Partitions
5. Maintain Global Indexes Asynchronously
6. Use Partial Indexes

Watch this video series and learn about Oracle Database 12c Advanced Security.

This tutorial covers Oracle Database 12c attribute clusters and zone maps, features designed to offer significant IO reduction for queries that would otherwise perform full table scans.

Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis.Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL.

Learn the Oracle Database 12c XML DB new features. In this self-study, you will learn about:

• XQuery update recommendations
• XQuery full text
• Manageability using DBMS_XMLSCHEMA_ANNOTATE and DBMS_XMLSTORAGE_MANAGE

This video shows how to use data redaction in SQL*Plus.

Oracle Text has many enhancements with the release of Oracle Database 12c. Take this self-study to learn more about Oracle Text new features. Learn about:

• Forward Index
• USER_FILER and Session-Durations SQEs
• Stopclass to support patterns
• XQuery full-text

and many others!

In this tutorial, you will learn how to develop and and deploy fast, scalable, highly available and secure Java applications using new features in JDBC and UCP.
You will experience JDBC support for new database types, UCP, Database Resident Connection Pool, Multitenant Datasource, Transaction Guard, Application Continuity for Java, and Advanced Security Data Encryption and Integrity

The OBE's in this series provide you with instructions on how to perform data mining with Oracle Database 12c, by using Oracle Data Miner 4.0. Oracle Data Miner 4.0 is included as an extension of Oracle SQL Developer, version 4.0.

Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times.

This series teaches you how to use Oracle OLAP in four areas: Creating and querying OLAP Cubes; Using Oracle Application Express (APEX) with OLAP Cubes; Using Microsoft Excel with OLAP Cubes; and Using Oracle Business Intelligence Enterprise Edition with OLAP Cubes.

In this OBE, you will migrate a Sybase ASE database and its associate Java application to Oracle 12c Database using the SQL Translation Framework in SQL Developer.