Home / IT Books / Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

• Application Builder: Using this component, you can build database and websheet applications. Application Developers build applications using database applications. Using websheet applications, end users can manage structured and unstructured data without developer assistance.
• SQL Workshop: This component provides the following tools that enable you to view and manage database objects:
°° Object Browser: This tool allows you to browse database objects. You can also create database objects such as tables, sequences, and triggers.
°° SQL Commands: You can run ad-hoc SQL commands using this tool. The SQL Scripts tool enables you to store and run SQL scripts.
°° Query Builder: Using this tool, you can create SQL queries using drag-and-drop.
°° Utilities: This tool enables you to load and unload data, generate DDLs for the database objects, and supports schema comparison.
• Team Development: This component helps to manage the lifecycle of an application’s development. It is tightly integrated with the APEX Application Builder.
• Administration: This component provides service management, user management, and workspace activity.

Chapter 1: Database Editions and Oracle Database XE
About Oracle
Available database editions
Oracle Database Express Edition (XE)
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)
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
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
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
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
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
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
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
Chapter 10: Upgrading Oracle Database 11g XE to Other Database Editions
Upgrading Oracle Database 11g XE to Oracle Database 11g
Enterprise Edition
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
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

Oracle Database XE 11gR2 Jump Start Guide


Top books

About huydam

Check Also

[UWP] The program could not build Windows Universal Samples

If you get this error like this: “Type universe cannot resolve assembly: System.Runtime, Version=4.0.0.0, Culture=neutral, …

Leave a Reply

Your email address will not be published. Required fields are marked *