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.
Duration: 60 minutes
Release Date: 25-JUN-2013
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.
This tutorial introduces you to Oracle Enterprise Manager Database Express, a Web-based interface for managing an Oracle database.
Duration: 30 minutes
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.