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.
Preview in Mapt

Oracle Database XE 11gR2 Jump Start Guide

Asif Momen

Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.
Mapt Subscription
FREE
$20.83/m after trial
eBook
$12.60
RRP $17.99
Save 29%
Print + eBook
$29.99
RRP $29.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$12.60
$29.99
$29.99 p/m after trial
RRP $17.99
RRP $29.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Oracle Database XE 11gR2 Jump Start Guide Book Cover
Oracle Database XE 11gR2 Jump Start Guide
$ 17.99
$ 12.60
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 25.20
Buy 2 for $30.10
Save $23.88
Add to Cart

Book Details

ISBN 139781849686747
Paperback146 pages

Book Description

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.

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

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

Read More Reviews

Recommended for You

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 25.20
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide Book Cover
Getting Started with Oracle WebLogic Server 12c: Developer’s Guide
$ 32.99
$ 23.10
Instant Oracle Database and PowerShell How-to Book Cover
Instant Oracle Database and PowerShell How-to
$ 19.99
$ 14.00
GDI+ Application Custom Controls with Visual C# 2005 Book Cover
GDI+ Application Custom Controls with Visual C# 2005
$ 20.99
$ 14.70
Mastering Windows 8 C++ App Development Book Cover
Mastering Windows 8 C++ App Development
$ 29.99
$ 21.00
Android NDK Beginner’s Guide Book Cover
Android NDK Beginner’s Guide
$ 29.99
$ 21.00