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.
Release Date: 08-NOV-2016
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 minutes
This tutorial introduces you to Oracle Enterprise Manager 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 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 minutes
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 minutes