A Visual Introduction to SQL [Paperback]

David Chappell (Author), J. Harvey Trimble Jr. (Author)

Book Description

ISBN-10: 0471412767 | ISBN-13: 978-0471412762 | Publication Date: November 12, 2001 | Edition: 2

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.

Editorial Reviews

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.

From the Back Cover

Learn SQL quickly with this easy-to-use, visual tutorial

Every IT professional needs at least a basic understanding of SQL. A Visual Introduction to SQL, Second Edition provides a unique tool for acquiring this knowledge. By diagramming each query, this book resolves the language's apparent complexity into simple clarity using an intuitive visual representation. Rather than focusing on a specific vendor's SQL dialect, the book introduces the essential core of the language, making it useful for anyone.

For this new edition of their successful, long-selling book, David Chappell and J. Harvey Trimble Jr. have updated the contents to reflect SQL today. The result is a clear, step-by-step explanation of the current language, with the book's unique visual approach guiding the way.

A Visual Introduction to SQL, Second Edition is useful for all levels:
* For SQL beginners, the unique graphical approach makes learning this sometimes unfriendly language much easier
* For those with some SQL experience, the visual approach makes clear the language's underlying structure and helps in creating complex queries
* For regular SQL users, the wealth of examples in this book provides quick, easy-to-reference answers to frequently asked questions

No matter what SQL version you use, A Visual Introduction to SQL, Second Edition allows you to quickly grasp both the basic and more advanced features of this important language.

Wiley Computer Publishing
Timely. Practical. Reliable.
Visit our Web site at www.wiley.com/compbooks/

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: 11.3 x 7.2 x 0.7 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.9 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #513,894 in Books (See Top 100 in Books)
  • #89 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

17 of 17 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!!!

11 of 11 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)   

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

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! ;-)