What this book covers

Chapter 1, Database Editions and Oracle Database XE, provides a brief introduction to the various editions of Oracle database and in particular, Oracle Database 11gR2 Express Edition.

Chapter 2, Installing and Uninstalling Oracle Database XE, is about installing and uninstalling Oracle Database XE on Windows and Linux environments.

Chapter 3, Connecting and Configuring Oracle Database 11g XE, focuses on Oracle Listener configuration and establishing client connections to the database, followed by Oracle memory management.

Chapter 4, Accessing Table Data, DML Statements, and Transactions, talks about SQL Developer, accessing table data, modifying table data, understanding transaction control statements, and the most commonly used SQL functions.

Chapter 5, Creating and Managing Schema Objects, deals with creating and managing database objects such as tables, indexes, constraints, views, sequences, and synonyms.

Chapter 6, Developing Stored Subprograms and Triggers, brings you the power of PL/SQL. In this chapter, you will learn to build stored procedures, functions, and triggers.

Chapter 7, Building a Sample Application with Oracle Application Express, provides a brief introduction to Oracle Application Express (APEX). You will learn how to create rich and responsive applications using Oracle Application Express.

Chapter 8, Managing Database and Database Storage, provides background information on Oracle memory management, and explains physical database structure and the Flash Recovery Area.

Chapter 9, Moving Data between Oracle Databases, explains how to move data between different Oracle Database XE versions using Oracle's export/import utilities.

Chapter 10, Upgrading Oracle Database 11g XE to Other Database Editions, explains in detail how to upgrade Oracle Database Express Edition to other Oracle Database Editions.

Chapter 11, Backup and Recovery, provides an insight to Oracle's backup and recovery procedures. Backups are to a database what fire fighters are to a city. In this chapter, you will learn how to protect and recover your database.

Chapter 12, Tuning Oracle Database 11g XE, provides a systematic approach to performance tuning, avoiding many of the most common application design and development mistakes and tracing of SQL statements.

Appendix, Features Available with Oracle Database 11g XE, lists all the features that are available with Oracle Database 11g Express Edition.