A Visual Introduction to SQL (Paperback)

by David Chappell (Author), J. Harvey Trimble Jr. (Author) "Every IT professional needs at least a basic understanding of SQL..." (more)
Key Phrases: name phone salary, num credits, hoc table, Problem List, Carol Dean, Janet Thomas (more...)

Editorial Reviews

Product Description
Learn SQL basics quickly with this visual tutorial featuring over 125 graphics SQL (Structured Query Language) is the tool used to access nearly all databases, which means that most software professionals should understand at least the basics. This hands-on tutorial offers an accessible introduction to SQL using over 125 graphics to illustrate the lessons. The book's unique visual approach makes it much easier for the reader to learn SQL. This Second Edition has been updated with new graphics and covers such subjects as the SELECT statement, joins, subqueries, views, granting and revoking privileges, and creating and destroying tables.

From the Publisher
A unique, visual approach to learning Structured Query Language (SOL), a widely-used tool for accessing data stored in relational database systems. This diagram-based tutorial presents the language in an easily-accessible way, making it a more effective learning tool than other texts. --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 256 pages
• Publisher: Wiley; 2 edition (November 12, 2001)
• Language: English
• ISBN-10: 0471412767
• ISBN-13: 978-0471412762
• Product Dimensions: 9.2 x 7.5 x 0.3 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.9 out of 5 stars See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #228,480 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #63 in	Books > Computers & Internet > Databases > Relational Databases
  #64 in	Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

5.0 out of 5 stars The ONLY SQL book I recommend for beginners, September 5, 2000

By	Kenneth Shirey (Houston,TX United States) - See all my reviews

This review is from: A Visual Introduction to SQL (Paperback)

This is a GREAT book for foundation skills in SQL.

I used this book to teach myself SQL when I was "elected" to implement an Oracle database system at a former job and have since gone on to become an Oracle developer and DBA. The concepts and techniques learned in this book have served me well along the way. I have taught Oracle development in a technical school, and insisted that they use this book in the classroom. The diagrammatic approach to learning about tables, columns, joins and SQL functions seems to "click" with everyone who encounters it.

I'm writing this review after buying my ?10th? copy of this book - don't loan it out if you need to keep your copy.

11 of 11 people found the following review helpful:

5.0 out of 5 stars If you are trying to learn SQL, you need this book!, August 1, 1998

By	Donald Walker (San Marino, CA USA) - See all my reviews (REAL NAME)

This review is from: A Visual Introduction to SQL (Paperback)

I saw this book in a bookstore and it did not look very impressive based on price to number of pages ratio but I had a look at it, and after trying to learn SQL from some other books, this was a breath of fresh air. This is a book you can blow though quickly, doesn't require access to a computer or even much knowledge of any particular relational database system. I read thorough half of it in a few hours, but by that time I had developed a working knowledge of SQL. (Without ever sitting at a computer). They use a visual technique and repetition to show exactly what the SQL commands are used for, and how to use them to get what you need from the database. It covers your plain vanilla SQL and so may be 'slightly' different in syntax from the SQL your database uses (but in my experience, the changes are very very minor (eg, Transact SQL does not require a semicolon at the end of a statement)). This is an awesome book for anyone trying to 'figure out' SQL. Really lets you s! ee what the commands do and lets you understand it. I reccomended this book to a friend trying to learn SQL and he feels the same way about the book. SQL is really a pretty simple language, and this book makes the simplicity clear. Covers all major parts of SQL queries. Select, Update, making tables, altering tables, granting permissions, etc. Everything you need to get you started. IF you are trying to understand SQL, this book belongs on your desk. It was published in 1989 I think, but dont let that deter you. It is the best intro book on SQL I have ever seen!!!

9 of 9 people found the following review helpful:

5.0 out of 5 stars Attention Newbies to SQL - - This is your Book!!!, March 19, 2003

By	W. Weylman (Winchester, MA USA) - See all my reviews (REAL NAME)

I am currently enrolled in a Database Management (Oracle/SQL) class at Boston College. Right off the bat, I knew I was in trouble when we were told the professor would be unavailable for help and most of students in class were computer science majors. (I was taking the class to broaden my computer skills above and beyond front-end web design.)

The textbook in class was the heinously monstrous 1200+ page Oracle 9i The Complete Reference by Kevin Loney. After struggling through many chapters and finding our professor's teaching style very unhelpful, I decided it was time for another resource.

I checked on Amazon ... and found Sam's Teach Yourself SQL in 10 minutes to be semi-helpful. Then at the Harvard Coop, I stumbled upon it - - A VISUAL INTRODUCTION TO SQL. The problem, I realized, was that I am a visual learner and need to see all the schema tables and step-by step actions to describe what happens as I develop queries. This books is key for any layman, like myself. It walks you through very basic (and more complex) problems in an easy-to-read visual approach. While using SQL on the PC, viewing the tables is difficult and this book helps you map out the problems to figure them out. I was especially impressed after emailing the author about a table question and getting a personalized response.

If you are in a bind to learn SQL on your own, this book is great and won't kill you lugging it around either.

P.S. A great addition I found to this book was a Mac client software (that can access Oracle Databases) called SQL Grinder. Like the book, this program is also very visual and the GUI (MAC) clearly reigns over any PC. Sorry Windows users! Thanks for your help, David Chappell! ;-)