Main Menu
Home
My Books
Contact Me
Search
My Books
Java EE Project
JPA In EJB 3
Hibernate 3 For Beginners
Struts 2 With Hibernate 3
Struts 2 For Beginners
JSP Project For Beginners
Oracle For Professionals
Java Srv Programming
JSP For Beginners
Java EE 5 For Beginners
My Co-Authors
Sharanam Shah
Ivan Bayross
Syndicate
Tag Clouds
PDF Print E-mail

Oracle For Professionals

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.


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.

 
< Prev   Next >