SQL: Visual QuickStart Guide (3rd Edition) [Paperback]

Chris Fehily (Author)

Book Description

ISBN-10: 0321553578 | ISBN-13: 978-0321553577 | Publication Date: June 14, 2008 | Edition: 3

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

Editorial Reviews

From the Back Cover

Database management. It may sound daunting, but it doesn't have to be, even if you've never programmed before. SQL: Visual QuickStart Guide isn't an exhaustive guide to SQL written for aspiring programming experts. It's simply an invaluable resource for those who want a fast, easy way to harness information living in complex databases.

Because author Chris Fehily assumes no prior programming experience on your part (just a familiarity with your OS's file system), he spends the first few chapters laying out the basics, including clear explanations of the relational database model and SQL syntax. Then he jumps into step-by-step tasks designed to get you comfortable using SQL right away. You'll learn how to use SQL's most popular statements and commands to maintain, retrieve, and analyze database information, and to create and edit database objects. Each visually oriented task features the actual code and plenty of screenshots to keep you on track. Fehily takes a software-independent approach to teaching SQL, but includes tips for specific database software. You may not be a programming expert, but with SQL: VQS, who will be able to tell? --This text refers to an alternate Paperback edition.

About the Author

Chris Fehily is a statistical consultant and bestselling technical author. His other books for Peachpit Press include Visual QuickStart Guides on Windows, Numbers for iPad, and Python. He is also the author of Cancel Cable: How Internet Pirates Get Free Stuff.

Product Details

• Paperback: 496 pages
• Publisher: Peachpit Press; 3 edition (June 14, 2008)
• Language: English
• ISBN-10: 0321553578
• ISBN-13: 978-0321553577
• Product Dimensions: 9 x 7.1 x 1 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (30 customer reviews)
• Amazon Best Sellers Rank: #89,369 in Books (See Top 100 in Books)
  • #49 in Books > Computers & Technology > Databases > SQL

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

29 of 29 people found the following review helpful:

5.0 out of 5 stars This book helped get me a job, August 22, 2002

By 

Diane Yee (Belmont, CA USA) - See all my reviews

This review is from: SQL (Paperback)

Recently I was "redeployed" - which is the word that my company uses for "laid off if you can't find another job (quick) within the company". I speed-read this book, like cramming for an exam, and applied for the junior database administrator position and got it! Later, the senior DBA told me that I got the job because I knew subtle things about SQL and relational databases that the other candidates didn't know (or got wrong). For example, the difference between a database and a DBMS, why SQL doesn't stand for "Structured Query Language", the difference between server and desktop DBMSes, what the "relational" in "relational database" refers to, the normal forms, and the difference between SQL syntax and semantics. Most of these things were in the first few chapters. Author! Author!

14 of 14 people found the following review helpful:

5.0 out of 5 stars Start Your Queries Now!, February 15, 2003

By 

Bunny Bear (Brooklyn, NY) - See all my reviews

Amazon Verified Purchase

This review is from: SQL (Paperback)

Excellent book for learning SQL. This little books seems to pack a big punch in everything there is to know about SQL. There are around 200 to 300 sample queries, that start from the basics to nice fancy ones. You will learn about sub setting, functions, grouping, joins, sub queries, set operations, indexes, views, data definition language, and much more. For every topic you will get instructions on how its done in about the five most common SQL implementations.

20 of 22 people found the following review helpful:

5.0 out of 5 stars This Book Makes My Job Easier., September 4, 2002

By 

Melanie Pennington (Portland, OR United States) - See all my reviews

This review is from: SQL (Paperback)

There are several "software-independent" SQL books available. I thumbed through a number before landing on this one. I believe I got real lucky.

I'm a research analyst at a large medical center. I pull data from various sources using SQL front-ends and stuff data into MS Access for analysis or additional manipulation. I needed an SQL reference for both parts of my job, understanding what I was getting from the hospital systems and writing better SQL in Access or imbeddded SQL in VBA code. This book serves my needs because it is a thorough reference and also because it has plenty of Access examples and tips.

I'm also impressed with the layout of the Visual QuickStart Guide. It is very easy to find the information you are after and the bullet points are generally right on target with the details important to the task at hand. I haven't had to read the entire book cover to cover to do some work, and that's the point. When the author does interject himself, his comments are insightful and meaningful. An example, "Although SELECT is powerful, it's not dangerous. You can't use it to add, change or delete data... The dangerous stuff starts in Chapter 9."

A great technical reference in a crowded field.