Learning SQL: A Step-By-Step Guide Using Oracle [Paperback]

Richard Earp (Author), Sikha Bagui (Author)

Book Description

Publication Date: May 25, 2002 | ISBN-10: 0201773635 | ISBN-13: 978-0201773637

Learning SQL: A Step-By-Step Guide Using Oracle is a brief, hands-on tutorial covering the basics of using SQL, as well as using the Oracle database engine with SQL. It assumes no previous knowledge of programming or databases. The book focuses on providing an introduction to beginning SQL tasks. Throughout the chapters, readers are taken through various beginning aspects of SQL. At the end of each chapter, a series of exercises is provided to facilitate the practice of these newly learned skills. Throughout the book, common pitfalls and style tips are called out in margin boxes. With this book, readers learn not only the basics, but also gain insight into how these skills are used by professional Oracle programmers. This book is appropriate as a main textbook in an Introduction to Oracle/SQL course, or as a supplemental book for an Introduction to Database course for CS, CIS, MIS, or IT students.

Product Details

• Paperback: 368 pages
• Publisher: Addison Wesley (May 25, 2002)
• Language: English
• ISBN-10: 0201773635
• ISBN-13: 978-0201773637
• Product Dimensions: 9.1 x 8 x 0.8 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #968,550 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

5.0 out of 5 stars A Wonderful Book That Clearly Explains Unclear Topics, July 2, 2002

By 

Linda Zarate "IT Ops Consultant" (Azusa, CA United States) - See all my reviews

This review is from: Learning SQL: A Step-By-Step Guide Using Oracle (Paperback)

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.

If you're pursuing your OCP certification and find that the class materials are too terse, or that the books are more focused on getting you through the exam instead of teaching you how to use SQL, get this book. For business users, IT business systems analysts and others who need to write and execute queries against an Oracle database and need a solid introduction to SQL this book will meet their needs.

4 of 5 people found the following review helpful:

5.0 out of 5 stars Great Book for beginners!, October 7, 2002

By 

Sandip Ray (Mobile, AL USA) - See all my reviews

This review is from: Learning SQL: A Step-By-Step Guide Using Oracle (Paperback)

This is a really good for a beginner to learn SQL using Oracle. The authors have very clearly explained the complicated terms and concepts, in a fashion we are used to learn in class rooms.

It can also be used as a reference book or as a quick refresher course for someone who have not used SQL in a few years or so.

I strongly recommend this book to everyone interested to learn SQL using Oracle.

5.0 out of 5 stars Great Book for Beginners, December 26, 2009

By 

jimboinaz (Tucson, AZ) - See all my reviews

Amazon Verified Purchase

This review is from: Learning SQL: A Step-By-Step Guide Using Oracle (Paperback)

Thie is a great book for beginners, taking you from a background of SQl through an introduction of terms right into developing simple queries.