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
|
||
THE TOPICS COVERED IN THE BOOK CONTENTS OF THE CD-ROM
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
Beyond The Basics
Indexes, Views, Clusters, Sequences
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
Scripting In Oracle
Java, PHP, Pro*C/C++
SQL Scripts, PL/SQL Scripts
Data Warehouse
Appendix
Oracle Warehouse Builder
Sample Data, Installing Oracle Database 10g XE, Interview Questions
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.
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.