Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

Oracle for Professionals - Covers Oracle 9i, 10g & 11g w CD *(Slightly worn, all pages and cover in tact.)

by: Shah, Sharanam et al

On-line Price: $19.00 (includes GST)

Hardcover package 1420

70%Off Retail Price

You save: $46.00

CLEARANCE Item - Special discount -limited stock
_____________________
N.Sydney : In Stock

Retail Price: $65.00

Publisher: Shroff Publishing,15.10.09

Category: ORACLE Level: B/I/A

ISBN: 8184045263
ISBN13: 9788184045260

Add to Shopping Cart

Covers Oracle 9i, 10g & 11g

Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly used business database models.

It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle's flagship database management system along with existing features found in Oracle Database 9i and 10g.

TOPICS COVERED IN THE BOOK

Overview Of Oracle Database
Introduction, Architecture, Installation, Tablespace/User Management, SQL Plus, SQL Developer

Basics Of SQL
Entity Relationship Diagram, Data Types, Working With Database Tables, Multi-Table Insert Statements, Merging Rows, Altering Table Structures, Synonyms, External Tables, Data Constraints

Working With Data
Operators, Character/String Functions, Number Function, Date Functions, Grouping Data, Subqueries, Joins, Union, Intersect And Minus, Analytic Functions, Modeling Data, Hierarchical SQL Queries, If, then And Else,

Pivot/Unpivot Operators, Regular Expressions, RowlD And RowNum

SQL Performance Tuning
Indexes, Views, Clusters, Sequences

Beyond The Basics
Flashback, Objects And Collections, Oracle Text, XML

PL/SQL
Introduction To PL/SQL, Transactions, Cursors, Procedures And Functions, Packages, Triggers, Automatically Generating And Assigning Primary Key Values, Dynamic SQL, DML Error Logging

Backup, Restore And Data Loading
IMP And EXP, Data Pump - IMPDB And EXPDB, SQL*Loader

Application Development
Java, PHP, Pro*C/C++

Scripting In Oracle
SQL Scripts, PL/SQL Scripts

Data Warehouse
Oracle Warehouse Builder

Appendix
Sample Data, Installing Oracle Database 10g XE, Interview Questions

CONTENTS OF THE CD-ROM
Setup files for Oracle database 10g eXpress Edition. Video Footage of Installing Oracle Database 10g [XE] and 11g. Source code for examples in this book.

About The Authors
The author Sharanam Shah [www.sharanamshah.com] has 7+ years of IT experience as a Developer, Database Designer, Technical Writer, Systems Analyst and a Lead Architect. He currently consults with several software houses in Mumbai, India, to help them design and manage database applications. Vaishali Shah [www.vaishalishahonline. com], his wife, co-author and a Technical Writer by profession, has a rich experience of designing, developing and managing database systems.

Their desire to share the knowledge they've acquired over all these years working together and perhaps partially to keep it available and alive made them co-author and publish several books, most of them tightly focused on commercial application development using software tools.