Oracle Database XE 11gR2 Jump Start Guide
Database Editions and Oracle Database XE
Oracle Database Express Edition (XE)
Installing and Uninstalling Oracle Database XE
Downloading Oracle Database 11g XE
Installing Oracle Database 11g XE on Windows XP (32-bit)
Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
Connecting and Configuring Oracle Database 11g XE
Accessing Table Data, DML Statements, and Transactions
Unlocking sample user accounts
Connecting SQL Developer to Oracle Database 11g XE
Selecting data from multiple tables
What are Transaction Control Statements?
Creating and Managing Schema Objects
Creating and managing synonyms
Creating and managing sequences
Developing Stored Subprograms and Triggers
Wrapping up the PL/SQL stored programs
Building a Sample Application with Oracle Application Express
What is Oracle Application Express (APEX)?
Loading and unloading data to a text file
Managing Database and Database Storage
Important background processes
Physical and logical database structures
Managing the Flash Recovery Area
Moving Data between Oracle Databases
Moving data between Oracle Database 10g XE and Oracle Database 11g XE
Exporting data using SQL Developer
Upgrading Oracle Database 11g XE to Other Database Editions
Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
Introduction to backup and recovery
Connecting to Oracle Database XE using RMAN
Backing up a database (the NOARCHIVELOG mode)
Simulating a database failure (the NOARCHIVELOG mode)
Restoring the NOARCHIVELOG database
Configuring the RMAN environment
Backing up the ARCHIVELOG database
Simulating a database failure (the ARCHIVELOG mode)
Restoring the ARCHIVELOG database
Features Available with Oracle Database 11g XE