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.

Asif Momen

€24.99

4.3 (3 Ratings)

Paperback Jul 2012 146 pages 1st Edition

Asif Momen

€24.99

4.3 (3 Ratings)

Paperback Jul 2012 146 pages 1st Edition

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Preview Book

Key benefits

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

Description

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.

Who is this book 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.

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

Estimated delivery fee Deliver to Spain

Premium delivery 7 - 10 business days

€17.95

(Includes tracking information)

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

€24.99

Oracle Database 11gR2 Performance Tuning Cookbook

€45.99

Oracle Advanced PL/SQL Developer Professional Guide

€48.99

Total € 119.97

FAQs

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

Nassyam Basha Oct 01, 2012

I have reviewed all the chapters, Every step is with full of explanations and examples. Who ever starting to learn XE 11gR2 i think this is the right book to start learning.From the chapters of 1 to 6 designed for beginners to learn from architecture concepts, Every chapter is very detailed.From the chapters 7 to 12 desgined with advanced topics. Chapter 7 introduced with Application Express, Moving data between oracle Databases, Managing Database and storage,For sure Chapter 12 is an valuable by introducing "Tuning Oracle 11g XE". Overall This book looks great even for beginners and who ever looking for Advanced concepts of Oracle 11g XE.Thank You.

Amazon Verified review

Milto Oct 25, 2012

This is an excellent introduction to the complex world of the Oracle 11G database. It covers all the important aspects of database installation, setup, programming, maintenance, backup and support.There is enough information in each subject area to get the reader started and interested in finding out more. It would even be a useful 11g quick reference for experienced DBAs. Highly recommended.

B. Walter Finn Dec 29, 2013

The mere mention of "Oracle Database" can strike fear and intimidation in many an aspiring IT career climber. Have no fear. This books lays it out step by step in a clear fashion. For those concerned about licensing issues, since Oracle XE and Oracle Developer are free, you can use them to learn, build a working project, or both. The book gives a rundown of other Oracle versions and their licenses as well, explaining the cost, terms, and limitations.I have a background in mysql and MS SQL, so I'm no beginner, but I do like books that lay down the basics. When using a new technology, there may be features or ways of doing things that are a bit different. Reading from a basic level gives me a good foundation and fills in any gaps I may have. It leaves me well-prepared for tackling the more advanced topics.Pros:This book includes installation instructions for Oracle and the Oracle IDE, as well as step-by-step queries that you can practice that will introduce you to the syntax, features, and functions of Oracle.Cons:There are some things that I would do different. While there are instructions for Linux, there is no mention that the RPM files need to be converted for Debian-based distros such as Ubuntu. I had to Google the instructions. Ubuntu is one of the most popular distros, so I feel that the instructions should be there. There's quite a few steps involved in regards to various hardware settings. The book addresses some, but not all. I actually had to create a new swap partition and delete the old one because the one my Oracle VBOX built during the Ubuntu installation was under 2 gigabytes. I also had to figure out how to install JDK, and make a decision on whether to use Oracle's or opensdk. I feel these instructions should be included. To me, buying a technical book is about being hand-walked step by step without having to jump around from blog to blog for snippets of instructions. If I'm having to do this anyway, what's the point of buying the book?So after jumping from site to site, I'm back to the book, and go to where I feel I need to be... which is after IDE installation. But now I'm being asked to run queries on an HR database, except where's the HR database? Do I need to make one up? The thought crossed my mind... but it sounded like I had to bake a cake before learning how to make it. I downloaded the code samples from the publisher, but no database there. Turns out the instructions for adding Oracle's version of "Northwind", HR, a sample database that comes with Oracle, was a bit before the IDE installation. I feel this should go immediately before the SQL query chapter after the IDE installation, and if not, at least make a reference to it for those that had to step away from the book for the installation portion or waited to install the IDE before trying out queries.The third thing I would do differently is to create a chart for each screenshot that breaks down each line in the statement in summary. This is something that "MySQL Stored Procedure Programming" did which I found very practical and useful.Conclusion:Overall, I think this is a great book to get you started on Oracle. I haven't finished it yet, but I'm looking forward to the chapter on Oracle APEX. I feel confident that I'll be able to tackle more challenging material comfortably after completing this book.

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.

What do you get with Print?