Oracle Database XE 11gR2 Jump Start Guide

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.

Type
ebook
Category
Data
publication date
2012-07-10
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

no of pages
146
duration
292
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
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.
audience
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.
meta description
Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.
subtitle
Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide with this book and ebook.
keywords
Oracle database XE, Oracle Database Express Edition, Oracle Apex, Oracle Application express, oracle database, oracle database application development, Asif Memon, Oracle ACE, advanced SQL and PL/SQL
Product ISBN
9781849686747