Oracle Database XE 11gR2 Jump Start Guide
eBook:
$17.99
Formats:
Formats:
$15.29
save 15%!
save 15%!
Print + free eBook + free PacktLib access to the book:
$47.98
Print cover: $29.99
$29.99
save 37%!
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
| Also available on: |
|
- 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 : EnglishPaperback : 146 pages [ 235mm x 191mm ]
Release Date : July 2012
ISBN : 1849686742
ISBN 13 : 9781849686747
Author(s) : Asif Momen
Topics and Technologies : All Books, Oracle Applications, Oracle Database, Enterprise, Oracle
Table of Contents
PrefaceChapter 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 1: Database Editions and Oracle Database XE
- About Oracle
- Available database editions
- 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)
- 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 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
- 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 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
- 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
- Appendix: Features Available with Oracle Database 11g XE
- Features available
- Features not available
Asif Momen
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
+
=
50% Off
the eBooks
the eBooks
Buy both these recommended eBooks together and get 50% off the total price
- 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
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.
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.
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.
