E-book details

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

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

Asif Momen

Ebook
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.
  • Oracle Database XE 11gR2 Jump Start Guide
    • Table of Contents
    • Oracle Database XE 11gR2 Jump Start Guide
    • Credits
    • About the Author
    • Acknowledgement
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
        • Instant Updates on New Packt Books
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code
        • Errata
        • Piracy
        • Questions
    • 1. Database Editions and Oracle Database XE
      • About Oracle
        • Available database editions
      • Oracle Database Express Edition (XE)
      • Summary
      • References
    • 2. Installing and Uninstalling Oracle Database XE
      • Downloading Oracle Database 11g XE
      • Installing Oracle Database 11g XE on Windows XP (32-bit)
        • Starting and stopping Oracle Database XE in Windows
      • Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
      • Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
        • Starting and stopping Oracle Database XE in Linux
      • Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)
      • Summary
    • 3. Connecting and Configuring Oracle Database 11g XE
      • Local database connections
        • Oracle Net Listener
          • Configuring Oracle Net Listener
          • Viewing the status of Oracle Net Listener
          • Starting and stopping the listener
          • Configuring the tnsnames.ora file
      • Remote database connections
      • Changing SGA and PGA sizes
      • Summary
    • 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
    • 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
    • 6. Developing Stored Subprograms and Triggers
      • PL/SQL data types
      • Stored subprograms
      • Creating stored subprograms
      • About packages
        • Creating packages
      • Exception handling
      • Wrapping up the PL/SQL stored programs
      • PL/SQL triggers
      • Summary
      • References
    • 7. Building a Sample Application with Oracle Application Express
      • What is Oracle Application Express (APEX)?
        • Getting started with Oracle Application Express
        • Application Express components
        • Prerequisites for a sample application
        • Creating a sample application
        • Adding a page to the existing application
      • Creating application users
      • Loading and unloading data to a text file
        • Unloading the EMP table to a text file
        • Loading text file to the EMP_LOAD table
      • Application Express Dashboard
      • Summary
      • References
    • 8. Managing Database and Database Storage
      • Memory structure
        • System Global Area
        • Process Global Area
      • Automatic Memory Management
      • Important background processes
      • Physical and logical database structures
        • Creating a tablespace
          • Adding datafiles to a tablespace
        • Dropping a tablespace
        • Viewing the tablespace usage
      • Managing the Flash Recovery Area
      • Summary
    • 9. Moving Data between Oracle Databases
      • Exporting and importing data
        • Traditional Export and Import (exp/imp) utilities
        • Data Pump Export/Import (expdp/impdp) utilities
      • Moving data between Oracle Database 10g XE and Oracle Database 11g XE
      • Exporting data using SQL Developer
      • Summary
    • 10. Upgrading Oracle Database 11g XE to Other Database Editions
      • Upgrading Oracle Database 11g XE to Oracle Database 11g Enterprise Edition
      • Summary
    • 11. Backup and Recovery
      • Introduction to backup and recovery
      • Recovery Manager
      • Connecting to Oracle Database XE using RMAN
      • The ARCHIVELOG mode
        • Placing a database in 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
    • 12. Tuning Oracle Database 11g XE
      • Performance tuning
      • Performance tuning approach
      • Avoiding common pitfalls
        • Database connection management
        • Cursors and the shared pool
        • Suboptimal SQL
        • Incorrect redo log sizing
      • Autotrace utility
      • Explain Plan
      • Using indexes
        • Index monitoring
      • Dynamic performance views
      • Statspack
        • Installing Statspack
        • Gathering statistics
        • Running the statistics report
        • Recommended blogs
      • Summary
      • References
    • A. Features Available with Oracle Database 11g XE
      • Features available
      • Features not available
    • Index
  • Title: 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
  • Author: Asif Momen
  • Original title: 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.
  • ISBN: 9781849686754, 9781849686754
  • Date of issue: 2012-07-10
  • Format: Ebook
  • Item ID: e_3b6f
  • Publisher: Packt Publishing