My Princess

Janya - My Life

My Co-Authors

Vaishali Shah
Ivan Bayross

My Publishers

Shroff Publishers

I work with

CyberSol Technologies

Web Directories

Directory India

Who's Online

Oracle For Professionals - Covers Oracle 9i, 10g & 11g PDF Print E-mail

 

Oracle For Profesionals


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.

 

Buy this item

 

ISBN 10: 81-8404-526-3
ISBN 13: 978-81-8404-526-0

Edition: First

Downloads
Sample Chapter                                                     TOC

THE 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, RowID 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.
+/-
Write comment
Name:
Email:
 
Website:
Title:
UBBCode:
[b] [i] [u] [url] [quote] [code] [img] 
 
 
:angry::0:confused::cheer:B):evil::silly::dry::lol::kiss::D:pinch:
:(:shock::X:side::):P:unsure::woohoo::huh::whistle:;):s
:!::?::idea::arrow:
 
Please input the anti-spam code that you can read in the image.
+/- Comments
Add New Search RSS
Jez   |2009
Sharanam and Vaishali,
Both of you have put
together a book thats a masterpiece for Oracle Professionals. Its very useful as
it acts as a ready and lucid reference to the different topics in Oracle
Database .

Also, one of the many ways where it stands different from the
other similar books on Oracle is the Reminders and Warnings section present
wherever applicable. This helps the Oracle beginners invaluably to avoid errors
and save on development time.

Great Going ! Keep it up !
Reply | Quote
0 0
Mustafa  - Oracle Warehouse Builder   |2008
I have purchased your book titled "Oracle for Professionals" and was
delighted to note the rich contents. I was very much imppressed about the depth
of coverage and the minute details you have provided.

Am sure a lot of efforts
have gone into it.
Reply | Quote
2 0
Pawan  - Good book     |2008
I have been working on oracle for ages.So I generally don't like many books as I
didn't find much new in any of them.

When I first saw this book ,I was scared
by its size but I took it just to find something new.

But I found this book
really well organized where you can flip open the topic you like and read it
rather than wasting time here and there.

Book is to the point and doesn't
wastes your precious time taking here and there. It is really for professionals


http://pawan-timekill.blogspot.com/
Reply | Quote
3 0
Bhuvnesh Sharma  - Really useful for Oracle Professional   |2008
I saw your book Oracle for Professional in our Library. I was so happy to see a
book which is really useful for Oracle Professional.

It is really useful for
Beginners like me. I checked on your website that you even write Technical
Documents also like High Level Design Documentation, Low Level Design
Documentation, Use Cases, Test Cases etc.

Can you plz guide me in that or plz
tell me whether you sell them or not? I really want those types of
documents.

Hoping to hear from you soon.
Reply | Quote
3 0

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."
 
[ Back ]