A Visual Introduction to SQL

by David Chappell, J. Harvey Trimble Jr., David Chappell

SQL (Structured Query Language) ist eine Programmiersprache, die bei den meisten relationalen Datenbanken, wie z.B. Oracle, Sybase, Microsoft SQL Server und Access zum Einsatz kommt. Zwar verf?gen die meisten ?ber eigene Extensions, doch mit den SQL Standardbefehlen wie "select", "insert", "update", "delete", "create" und "drop" k?nnen grundlegende Datenbankaufgaben wie Datenzugriff und -bearbeitung ausgef?hrt werden. Deshalb sollten Softwareexperten...

• Format: Paperback
• Language: English
• ISBN: 0471412767
• ISBN13: 9780471412762
• Release Date: November 2001
• Publisher: Wiley
• Length: 304 Pages
• Weight: 1.20 lbs.
• Dimensions: 0.7" x 7.2" x 11.3"

Customer Reviews

All the Basics and More

This book doesn't assume that you are familiar with databases or the SQL programming language. It teaches you the programming language step-by-step using a graphic approach. A great way to learn SQL.

The ONLY SQL book I recommend for beginners

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.

Very user-friendly introduction to SQL concepts

The visual representations used by the authors makes it much easier to grasp the concepts of data retrieval in a relational database. Where most books tend to represent SQL statements as a string of required and optional words in syntax, this book goes beyond the syntax to illustrate how the data is stored, and how to retrieve it. By using a visual approach, it is possible to see how sql works to manage data, rather than just imitating a string of text that you often don't understand.

If you are trying to learn SQL, you need this book!

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