This tutorial shows you how to use the Oracle Universal Installer (OUI) to install the Oracle Database 12c software and create a database. You will also learn how you can use the Database Configuration Assistant (DBCA) to create additional databases.
Duration: 60 mins
Released: 9 months ago
This tutorial introduces you to Oracle Enterprise Manager 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 learn how to use Enterprise Manager Express to explore the structure of your database. In addition, you 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, 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 to rewind changes to a table and Oracle Flashback Drop to recover a dropped table.
In this tutorial, you monitor your database using Oracle Enterprise Manager Database Express.
In this tutorial, you learn how to automate the process of analyzing the overall effect of a database change on a SQL workload.
Duration: 20 mins
In this tutorial, you learn how to use the Resource Manager features in Enterprise Manager (EM) Express to manage database resources efficiently.
This tutorial covers managing pluggable databases (PDBs) in a multitenant container database (CDB) using Oracle Enterprise Manager Database Express (EM Express).
This tutorial describes how to keep your Oracle Database software up-to-date.
Duration: 90 mins
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.1 years ago
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 (22.214.171.124) 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.8 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: 3.6 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.
Learn the Oracle Database 12c XML DB new features. In this self-study, you will learn about:
Duration: 69 mins