Oracle Database XE 11gR2 Jump Start Guide

Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.

Oracle Database XE 11gR2 Jump Start Guide

Starting
Asif Momen

Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.
$17.99
$29.99
RRP $17.99
RRP $29.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849686747
Paperback146 pages

About This Book

  • Install and configure Oracle Database XE on Windows and Linux
  • Develop database applications using Oracle Application Express
  • Back up, restore, and tune your database
  • Includes clear step-by-step instructions and examples

Who This Book Is For

If you are a student or beginner who is learning to administer Oracle Database, then this book is for you. This book is designed to cover the problems that novice DBAs particularly struggle with, so no prior knowledge of Oracle database administration is expected.

Table of Contents

Chapter 1: Database Editions and Oracle Database XE
About Oracle
Oracle Database Express Edition (XE)
Summary
References
Chapter 2: 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)
Summary
Chapter 3: Connecting and Configuring Oracle Database 11g XE
Local database connections
Remote database connections
Changing SGA and PGA sizes
Summary
Chapter 4: Accessing Table Data, DML Statements, and Transactions
Unlocking sample user accounts
Installing SQL Developer
Connecting SQL Developer to Oracle Database 11g XE
About TAB and DUAL
Writing simple queries
Selecting data from multiple tables
Exploring common functions
What are Transaction Control Statements?
Understanding DML statements
Summary
References
Chapter 5: Creating and Managing Schema Objects
Data Definition Language
Creating and managing tables
Creating and managing indexes
Integrity constraints
Creating and managing views
Creating and managing synonyms
Creating and managing sequences
Gathering statistics
Summary
References
Chapter 6: Developing Stored Subprograms and Triggers
PL/SQL data types
Stored subprograms
Creating stored subprograms
About packages
Exception handling
Wrapping up the PL/SQL stored programs
PL/SQL triggers
Summary
References
Chapter 7: Building a Sample Application with Oracle Application Express
What is Oracle Application Express (APEX)?
Creating application users
Loading and unloading data to a text file
Application Express Dashboard
Summary
References
Chapter 8: Managing Database and Database Storage
Memory structure
Automatic Memory Management
Important background processes
Physical and logical database structures
Managing the Flash Recovery Area
Summary
Chapter 9: Moving Data between Oracle Databases
Exporting and importing data
Moving data between Oracle Database 10g XE and Oracle Database 11g XE
Exporting data using SQL Developer
Summary
Chapter 10: Upgrading Oracle Database 11g XE to Other Database Editions
Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
Summary
Chapter 11: Backup and Recovery
Introduction to backup and recovery
Recovery Manager
Connecting to Oracle Database XE using RMAN
The ARCHIVELOG mode
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
Summary
References
Chapter 12: Tuning Oracle Database 11g XE
Performance tuning
Performance tuning approach
Avoiding common pitfalls
Autotrace utility
Explain Plan
Using indexes
Dynamic performance views
Statspack
Summary
References

What You Will Learn

  • Install and uninstall Oracle Database XE on Windows and Linux environment
  • Set up local and remote database connections and resize Oracle SGA
  • Install SQL Developer, access table data, modify table data, understand transaction control statements and most commonly used SQL functions
  • Create and manage database objects like tables, indexes, constraints, views, sequences, and synonyms
  • Develop PL/SQL stored subprograms
  • Create rich and responsive applications using Oracle Application Express
  • Understand Oracle logical and physical components such as SGA, PGA, Tablespaces, and Flash Recovery Area
  • Move data between different Oracle Database XE versions
  • Upgrade Oracle Database Express Edition to other Oracle Database Editions
  • Protect and recover your database
  • Tune the database for optimal performance

In Detail

Oracle Database XE 11gR2 is an excellent beginner-level database and is a great platform to learn database concepts.

"Oracle Database XE 11gR2 Jump Start Guide" helps you to install, administer, maintain, tune, back up and upgrade your Oracle Database Express Edition. The book also helps you to build custom database applications using Oracle Application Express.

Using this book, you will be able to install Oracle Database XE on Windows/Linux operating system.

This book helps you understand different database editions and it guides you through the installation procedure with the aid of screenshots. You will learn to interact with the database objects. You will gain a solid understanding of stored sub-programs which is followed by an introduction to Oracle Application Express (APEX). Solid database performance tuning strategies are also discussed in this book followed by backup and recovery scenarios.

All in all, "Oracle Database XE 11gR2 Jump Start Guide" delivers everything that you should know to get started with Oracle Database administration.

Authors

Table of Contents

Chapter 1: Database Editions and Oracle Database XE
About Oracle
Oracle Database Express Edition (XE)
Summary
References
Chapter 2: 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)
Summary
Chapter 3: Connecting and Configuring Oracle Database 11g XE
Local database connections
Remote database connections
Changing SGA and PGA sizes
Summary
Chapter 4: Accessing Table Data, DML Statements, and Transactions
Unlocking sample user accounts
Installing SQL Developer
Connecting SQL Developer to Oracle Database 11g XE
About TAB and DUAL
Writing simple queries
Selecting data from multiple tables
Exploring common functions
What are Transaction Control Statements?
Understanding DML statements
Summary
References
Chapter 5: Creating and Managing Schema Objects
Data Definition Language
Creating and managing tables
Creating and managing indexes
Integrity constraints
Creating and managing views
Creating and managing synonyms
Creating and managing sequences
Gathering statistics
Summary
References
Chapter 6: Developing Stored Subprograms and Triggers
PL/SQL data types
Stored subprograms
Creating stored subprograms
About packages
Exception handling
Wrapping up the PL/SQL stored programs
PL/SQL triggers
Summary
References
Chapter 7: Building a Sample Application with Oracle Application Express
What is Oracle Application Express (APEX)?
Creating application users
Loading and unloading data to a text file
Application Express Dashboard
Summary
References
Chapter 8: Managing Database and Database Storage
Memory structure
Automatic Memory Management
Important background processes
Physical and logical database structures
Managing the Flash Recovery Area
Summary
Chapter 9: Moving Data between Oracle Databases
Exporting and importing data
Moving data between Oracle Database 10g XE and Oracle Database 11g XE
Exporting data using SQL Developer
Summary
Chapter 10: Upgrading Oracle Database 11g XE to Other Database Editions
Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
Summary
Chapter 11: Backup and Recovery
Introduction to backup and recovery
Recovery Manager
Connecting to Oracle Database XE using RMAN
The ARCHIVELOG mode
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
Summary
References
Chapter 12: Tuning Oracle Database 11g XE
Performance tuning
Performance tuning approach
Avoiding common pitfalls
Autotrace utility
Explain Plan
Using indexes
Dynamic performance views
Statspack
Summary
References

Book Details

ISBN 139781849686747
Paperback146 pages
Read More

Recommended for You

Applied SOA Patterns on the Oracle Platform
$ 35.99