Paperback: 368 pages
Publisher: Addison Wesley; 1St Edition edition (May 25, 2002)
Product Dimensions: 7.8 x 0.5 x 8.9 inches
Shipping Weight: 1.4 pounds
Average Customer Review: 3.7 out of 5 stars See all reviews (7 customer reviews)
Best Sellers Rank: #2,023,555 in Books (See Top 100 in Books) #136 in Books > Computers & Technology > Databases & Big Data > Relational Databases #514 in Books > Computers & Technology > Databases & Big Data > Oracle #872 in Books > Computers & Technology > Databases & Big Data > SQL
Despite the pile Oracle Certified Professional training material I received in class and the OCP certification books on SQL, there were aspects that I didn't fully understand until I read this excellent book.Part I contains the absolute basics, all of which are as applicable to IT professionals and business users. The first three chapters are standard fare in most books of this sort - getting started and the basic commands (SELECT, CREATE, etc.). It's in Chapters 3-9 where the clarity of the author's writing pays off. These chapters cover Cartesian products, joins and aliases; set operations; grouping and sub queries. These are not easy to grasp by beginners, but the book clearly explains each, and also goes into details such as the differences between a join and sub queries, sub query correlation and similar topics.Part II of the book covers more advanced tasks that are more suited to DBAs., with some material that will interest advanced business users and IT business systems analysts. For the DBA only are chapters on creating tables and using Oracle's SQL*Loader, triggers and PL/SQL (although some advanced business users employ PL/SQL it's rare, and the focus in the chapter on the subject is more in line with DBA uses). For all readers the chapter titled "Multiple Commands, START Files, and Reports" contains highly useful information, especially on how to do crude branching with the DECODE statement. The four appendices are also valuable references, and cover using Oracle in the UNIX environment, data dictionaries, the student database and associated tables, and improvements that Oracle made to 8i and 9i.
SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Learning SQL: A Step-By-Step Guide Using Oracle Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Learning: 25 Learning Techniques for Accelerated Learning - Learn Faster by 300%! (Learning, Memory Techniques, Accelerated Learning, Memory, E Learning, ... Learning Techniques, Exam Preparation) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle SQL Tuning with Oracle SQLTXPLAIN Oracle Database 11g SQL (Oracle Press) ORACLE PL/SQL 101 (Oracle Press) Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) SQL Handbook: Learning The Basics Of SQL Programming (Computer Science Programming) (Computer Programming For Beginners) The Practical SQL Handbook: Using SQL Variants (4th Edition) A Step-By-Step Learning Guide for Older Retarded Children (Step-By-Step Learning Guide Series; 2) 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 Learn: Cognitive Psychology - How to Learn, Any Skill or Subject in 21 Days! (Learn, Learning Disability, Learning Games, Learning Techniques, Learning ... Learning, Cognitive Science, Study) SQL: The Ultimate Beginners Guide: Learn SQL Today SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition) SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL Head First SQL: Your Brain on SQL -- A Learner's Guide