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.

Key Features

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

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

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.