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).
Duration: 60 mins
Released: 4 years ago
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.
Released: 4.5 years ago
This video explains some of the Oracle Database 12c architecture changes. This is an introductory video for the Oracle Database 12c Posters.
Duration: 7 mins
This video shows you the main components of the Oracle Database 12c new multitenant architecture.
Duration: 10 mins
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.
Released: 4.3 years ago
This tutorial covers three important activities to help you manage pluggable databases: creating, modifying, plugging/unplugging
Duration: 45 mins
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.
Released: 4.2 years ago
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.
Duration: 15 mins
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.
Released: 3.8 years ago
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.
Released: 3.4 years ago
Take this Oracle by Example (OBE) tutorial to get up and running with Oracle Database 12c.
After completing the OBEs "Installing Oracle Database Software and Creating a Database." and "Getting Started with Oracle Enterprise Manager Express", you are ready to log into the database and start manipulating and querying data.
You'll learn the basics from this tutorial!
Duration: 105 mins
Oracle Product Manager, Keith Laker, demonstrates how to work with SQL Pattern Matching in Oracle Database 12c in this three-part video series. See Keith's blog for more information.
Released: 4.4 years ago
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.
Duration: 35 mins
Released: 4.1 years ago
Learn the Oracle Database 12c XML DB new features. In this self-study, you will learn about:
Duration: 69 mins
This video shows how to use data redaction in SQL*Plus.
Duration: 3 mins
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:
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
Duration: 150 mins
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.
Duration: 90 mins