Paperback: 456 pages
Publisher: Pearson; 2 edition (May 23, 2004)
Product Dimensions: 6.9 x 1 x 9.1 inches
Shipping Weight: 1.5 pounds (View shipping rates and policies)
Average Customer Review: 4.0 out of 5 stars See all reviews (7 customer reviews)
Best Sellers Rank: #533,470 in Books (See Top 100 in Books) #125 in Books > Computers & Technology > Databases & Big Data > Oracle #274 in Books > Computers & Technology > Databases & Big Data > SQL #587 in Books > Textbooks > Computer Science > Database Storage & Design
This book is remarkable for the clear manner in which it explains the basics of relational databases in general and Oracle in particular. I am currently in training for Oracle Certified Professional and had been using study guides and class material to learn Oracle. These are fine for passing the OCP exam, but they leave many gaps in the finer points which lead to thoroughly understanding Oracle.Since this book's goal is to explain Oracle's SQL Plus and PL/SQL languages instead of getting you through an examination with a passing grade it goes into details that my training missed. I especially like the way that database concepts, design and modeling are covered in the first chapter, and the step-by-step approach to teaching SQL and PL/SQL by actually performing useful tasks such as creating tables and working with tables.In addition to the basics, this book covers advanced topics such as row locking, performance and joins and set operations. PL/SQL is given the same thorough treatment as SQL Plus and as you read through the book and actually perform the tasks on a real Oracle instance your understanding and skill level increases greatly. Since PL/SQL is rich in features and programming constructs the care with which the author explains the basics and how to apply them in a real environment made learning fun and builds your self confidence.I also liked the attention given to database administration tasks in the final part of the book, and found the SQL Plus and PL/SQL quick reference in the back of the book useful on many occasions.If you don't have the luxury of attending Oracle training this book is an excellent substitute, and even if you're going through OCP training this book will fill in the gaps that will surely arise since the course is fast paced. Note that this book uses Oracle 8i as the example environment, but the material works with the newer 9i version too.
It is good startup book for anyone wanting to learn SQL/PL-SQL. The book is targeted on 9i but almost everything is still relevant.
Great book! well written easy to follow. A must have for beginners and pro.
Needed it for college, price here was cheaper than the bookstore.
Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Database Systems Using Oracle (2nd Edition) Beginning Oracle Database 11g Administration: From Novice to Professional (Expert's Voice in Oracle) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Oracle Database 12c Oracle RMAN Backup and Recovery OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control Oracle Database 11g SQL (Oracle Press) Oracle Database 11g New Features (Oracle Press) Oracle Database Ajax & PHP Web Application Development (Oracle Press) Oracle Performance Survival Guide: A Systematic Approach to Database Optimization (Prentice Hall Professional Oracle Series) Database Design Using Entity-Relationship Diagrams, Second Edition (Foundations of Database Design) Oracle Solaris and Veritas Cluster : An Easy-build Guide: A try-at-home, practical guide to implementing Oracle/Solaris and Veritas clustering using a desktop or laptop Librarian's Guide to Online Searching: Cultivating Database Skills for Research and Instruction, 4th Edition: Cultivating Database Skills for Research and Instruction Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design DB2/400: The New AS/400 Database: The Unabridged Guide to the New IBM Database Management System