Oracle Database XE 11gR2 Jump Start Guide


Oracle Database XE 11gR2 Jump Start Guide
eBook: $17.99
Formats: PDF, PacktLib, ePub and Mobi formats
$15.29
save 15%!
Print + free eBook + free PacktLib access to the book: $47.98    Print cover: $29.99
$29.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 146 pages [ 235mm x 191mm ]
Release Date : July 2012
ISBN : 1849686742
ISBN 13 : 9781849686747
Author(s) : Asif Momen
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Applications, Oracle Database, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Database Editions and Oracle Database XE
Chapter 2: Installing and Uninstalling Oracle Database XE
Chapter 3: Connecting and Configuring Oracle Database 11g XE
Chapter 4: Accessing Table Data, DML Statements, and Transactions
Chapter 5: Creating and Managing Schema Objects
Chapter 6: Developing Stored Subprograms and Triggers
Chapter 7: Building a Sample Application with Oracle Application Express
Chapter 8: Managing Database and Database Storage
Chapter 9: Moving Data between Oracle Databases
Chapter 10: Upgrading Oracle Database 11g XE to Other Database Editions
Chapter 11: Backup and Recovery
Chapter 12: Tuning Oracle Database 11g XE
Appendix: Features Available with Oracle Database 11g XE
Index
    • Chapter 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
      • Chapter 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
        • 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 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
                • Chapter 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
                  • Chapter 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
                      • Chapter 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
                        • Chapter 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

                            Asif Momen

                            Asif Momen has been working with Oracle technologies for over 12 years and has expertise in Database Architecture, Performance Tuning, and High Availability. He has a Master's degree in Software Systems from Birla Institute of Technology & Science (BITS), Pilani. Asif is honored by the prestigious Oracle ACE award from Oracle Technology Network. He has the following certifications: OCP 11g DBA, OCP 9i Forms Developer and is an Oracle Certified Expert in RAC 10g. Asif is a presenter for conferences like Oracle OpenWorld-2010, All India Oracle User Group (AIOUG), and Brain Surface. In addition, he is the Member of Editorial Board of "Oracle Connect"—the quarterly publication of AIOUG and “Select” magazine of the United Kingdom Oracle User Group (UKOUG) His articles have also appeared in Oracle Support - Customer Knowledge Exchange . His particular interests are Database & SQL tuning, Oracle RAC and Backup & Recovery. He posts his ideas and opinions on “The Momen Blog” (http://momendba.blogspot.com). Asif can be reached at asif.momen@gmail.com.

                            Code Downloads

                            Download the code and support files for this book.


                            Submit Errata

                            Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                            Sample chapters

                            You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                            Frequently bought together

                            Oracle Database XE 11gR2 Jump Start Guide +    OpenStack Cloud Computing Cookbook - Second Edition =
                            50% Off
                            the second eBook
                            Price for both: $34.50

                            Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                            What you will learn from this book

                            • 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.

                            Approach

                            This book discusses concepts and tasks through real-world examples. The author uses simple language, screenshots, and a step-by-step approach to get you started with Oracle Database administration.

                            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.

                            Code Download and Errata
                            Packt Anytime, Anywhere
                            Register Books
                            Print Upgrades
                            eBook Downloads
                            Video Support
                            Contact Us
                            Awards Voting Nominations Previous Winners
                            Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                            Resources
                            Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software