Comprehensive: Covers practically all of SQL, PL/SQL and SQL Plus; and it covers System Administration in adequate detail.
Oracle Best Practices: Comprehensively covers best practices in Naming Conventions, Database Design, SQL, PL/SQL, Audit & Logging, and Performance Enhancement.
Foundation for Designing a Robust, High-Performance Database: Relational Database Fundamentals and Normalization.
Brevity, with Clarity.
Examples: Extensive Illustrative Examples.
Useful Code: The Book is full of useful code. There is additionally a separate section on “Sample Code & Utilities”.
Meant for: While the Book is meant for professionals, the beginners would also find it very useful, as it deals with all the fundamentals too. It is meant for the developers, the designers and the architects; and also the system administrators. The Book would be very useful and effective for training purposes.
Covers the latest Oracle 11g Release 2
About the Author
The author, Rajnikant Puranik, has software experience of over 25 years. He has headed development of over a score of software products notably Core Banking, Treasury, Web-banking, Tele-banking, ATM-interfaces, and Basel-compliant Credit and Market Risk Management products. He has over two decades of experience working on relational databases, including Sybase, MS-SQL Server, Unify, Informix, SQL Anywhere, MySQL, etc., and, of course, Oracle, in which he has worked extensively, and has designed and developed a number of commercial applications.
Mr. Rajnikant Puranik has also authored a book on software testing, “The Art of Creative Destruction” (also available from SPD: Shroff Publishers & Distributors), which has been very well received, and which many found to be of significant practical utility in their software testing work.
There are scores of books on Oracle, and many good ones too. This, however, is different, both in its coverage and its treatment. You judge!
Table of ContentsA. RDBMS Overview
B. Relational Fundas
C. Oracle SQL Basics
D. Select Queries
E. Oracle Functions-I
F. Oracle Functions-II
G. Oracle Functions-III
H. DML: Data Manipulation Language
I. DDL: Data Definition Language
L. SQL Plus
M. Oracle Supplied Packages
N. Oracle System & Administration
O. Oracle Special Features
P. Performance Enhancement & Management
Q. Oracle Best Practices
R. Sample Code & Utilities
T. What they say about Computing