- Paperback: 368 pages
- Publisher: Addison Wesley; 1 edition (15 May 2002)
- Language English
- ISBN-10: 0201773635
- ISBN-13: 978-0201773637
- Product Dimensions: 23 x 20.2 x 2 cm
-
Amazon Bestsellers Rank:
884,773 in Books (See Top 100 in Books)
- #43 in Books > Computers & Internet > Computer Science > Databases > Applications > Oracle > PL & SQL
- See Complete Table of Contents
| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
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.
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
6 reviews
12 of 12 people found the following review helpful
A Wonderful Book That Clearly Explains Unclear Topics
3 July 2002
Format: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
Great Book for beginners!
8 Oct 2002
Format: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.
Great Book for Beginners
26 Dec 2009
Format:Paperback|Amazon Verified Purchase
Thie is a great book for beginners, taking you from a background of SQl through an introduction of terms right into developing simple queries.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
