Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 Jump Start Guide

Build and deal with your Oracle Database 11g XE atmosphere with this fast-paced, functional guide

  • Install and configure Oracle Database XE on home windows and Linux
  • Develop database purposes utilizing Oracle program Express
  • Back up, fix, and track your database
  • Includes transparent step by step directions and examples

In Detail

Oracle Database XE 11gR2 is a wonderful beginner-level database and is a brilliant platform to profit database concepts.

"Oracle Database XE 11gR2 bounce begin consultant" lets you set up, administer, keep, track, again up and improve your Oracle Database convey version. The e-book additionally permits you to construct customized database functions utilizing Oracle program Express.

Using this ebook, it is possible for you to to put in Oracle Database XE on Windows/Linux working system.

This publication is helping you know varied database versions and it courses you thru the deploy process simply by screenshots. you are going to discover ways to engage with the database gadgets. you'll achieve a pretty good realizing of saved sub-programs that is via an advent to Oracle program convey (APEX). sturdy database functionality tuning thoughts also are mentioned during this e-book through backup and restoration scenarios.

All in all, "Oracle Database XE 11gR2 bounce begin consultant" provides every thing for you to comprehend to start with Oracle Database administration.

What you'll examine from this book

  • Install and uninstall Oracle Database XE on home windows and Linux environment
  • Set up neighborhood and distant database connections and resize Oracle SGA.
  • Install SQL Developer, entry desk information, regulate desk information, comprehend transaction keep watch over statements and most ordinarily used SQL functions
  • Create and deal with database gadgets like tables, indexes, constraints, perspectives, sequences, and synonyms
  • Develop PL/SQL saved subprograms
  • Create wealthy and responsive functions utilizing Oracle software Express
  • Understand Oracle logical and actual elements corresponding to SGA, PGA, Tablespaces, and Flash restoration Area
  • Move info among various Oracle Database XE versions
  • Upgrade Oracle Database convey variation to different Oracle Database Editions
  • Protect and get better your database
  • Tune the database for optimum performance


This publication discusses techniques and initiatives via real-world examples. the writer makes use of uncomplicated language, screenshots, and a step by step method of get you begun with Oracle Database administration.

Who this publication is written for

If you're a scholar or newbie who's studying to manage Oracle Database, then this ebook is for you. This booklet is designed to hide the issues that amateur DBAs rather fight with, so no earlier wisdom of Oracle database management is expected.

Show sample text content

Download sample