nobody Have a Question?HelpLogin

Oracle Database 12c New Features

Attend this new OU course!

Oracle Multitenant Architecure

Attend this new OU course!

 

2-Day DBA

  • 1 - Installing Oracle Database Software and Creating a Database

    1 - Installing Oracle Database Software and Creating a Database

    This tutorial shows you how to use the Oracle Universal Installer (OUI) to install Oracle Database software and create a database. You also learn how you can use the Database Configuration Assistant (DBCA) to create additional databases.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 2 - Getting Started with Oracle Enterprise Manager Express

    2 - Getting Started with Oracle Enterprise Manager Express

    This tutorial introduces you to Oracle Enterprise Manager Database Express, a Web-based interface for managing an Oracle database.

    Duration: 30 mins

    Type: OBE

    Released: 10 months ago

  • 3 - Using the Listener Control Utility to Manage the Listener

    3 - Using the Listener Control Utility to Manage the Listener

    This tutorial introduces you to the Listener Control utility which enables you to administer the listener.

    Duration: 30 mins

    Type: OBE

    Released: 10 months ago

  • 4 - Managing the Oracle Instance

    4 - Managing the Oracle Instance

    This tutorial provides information on starting up and shutting down the database instance. You learn how to view and modify initialization parameters. You also learn how to manage memory management settings.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 5 - Managing Database Storage Structure

    5 - Managing Database Storage Structure

    In this tutorial you will learn how to use Enterprise Manager Express to explore the structure of your database. In addition, you will learn how to make a number of changes to your database storage structure.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 6 - Administering User Accounts and Security

    6 - Administering User Accounts and Security

    In this tutorial you learn how to use Enterprise Manager Express to administer user accounts and roles, which are named groups of related system and object privileges.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 7 - Managing Schema Objects

    7 - Managing Schema Objects

    In this tutorial you learn how to use SQL Developer to manage tables, indexes, and views. You also learn how to manage program code that is stored in the database.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 8 - Performing Backup and Recovery

    8 - Performing Backup and Recovery

    In this tutorial you configure your database for backup and recovery operations. You use Recovery Manager (RMAN) to perform backups and recover the database. You also use Oracle Flashback Table and Oracle Flashback Drop to rewind changes to a table and recover a table.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 9 - Monitoring and Tuning the Database

    9 - Monitoring and Tuning the Database

    In this tutorial you learn how to use Enterprise Manager Express to monitor the database. You also learn how to configure and use the Automatic SQL Tuning Advisor, and to run the SQL Tuning Advisor.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

  • 10 - Managing Oracle Database Software

    10 - Managing Oracle Database Software

    This tutorial shows you how to upgrade an existing Oracle Database to Oracle Database 12c Release 1.

    Duration: 60 mins

    Type: OBE

    Released: 10 months ago

Oracle Multitenant Architecture

Information Lifecycle Management

Security

Performance Tuning

  • Monitoring Performance Using EM Express

    Monitoring Performance Using EM Express

    Type: OBE

    Released: 10 months ago

  • Monitoring Real-Time Database Operations Using EM Express

    Monitoring Real-Time Database Operations Using EM Express

    Type: OBE

    Released: 10 months ago

  • Oracle Database 12c: What's New in Partitioning?

    Oracle Database 12c: What's New in Partitioning?

    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

    Duration: 60 mins

    Type: OBE

    Released: 6 months ago

SQL & PL/SQL

  • Oracle Database Quickstart

    Oracle Database Quickstart

    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

    Type: OBE

    Released: 4 months ago

  • Using SQL Pattern Matching - Series

    Using SQL Pattern Matching - Series

    This series features an OBE and a recorded webcast. Learn how to use  SQL for Pattern Matching. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis.

    Type: OBE

    Released: 10 months ago

  • Setting Up SQL Translation Framework

    Setting Up SQL Translation Framework

    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

    Type: OBE

    Released: 10 months ago

  • Database 12c SQL and PL/SQL OBEs

    Database 12c SQL and PL/SQL OBEs

    Type: OBE

    Released: 10 months ago

  • Oracle Database 12c: Oracle XML DB New Features

    Oracle Database 12c: Oracle XML DB New Features

    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

    Duration: 69 mins

    Type: eCourse

    Released: 4 months ago