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
Released: 3.3 years ago
This tutorial introduces you to Oracle Enterprise Manager Database Express, a Web-based interface for managing an Oracle database.
Duration: 30 mins
This tutorial introduces you to the Listener Control utility which enables you to administer the listener.
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.
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.
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.
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.
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.
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.
This tutorial shows you how to upgrade an existing Oracle Database to Oracle Database 12c Release 1.
This tutorial covers three important activities to help you manage pluggable databases: creating, modifying, plugging/unplugging
Duration: 45 mins
This tutorial covers redaction management in Oracle Database 12c or 11g Release 2 Patchset 3 (220.127.116.11) using SQL Developer. Topics include:
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
Released: 3 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
Released: 2.8 years ago
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.
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
Learn the Oracle Database 12c XML DB new features. In this self-study, you will learn about:
Duration: 69 mins