SQL (Database Programming) (2014 Edition) and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Start reading SQL (Database Programming) (2014 Edition) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL: Visual QuickStart Guide [Paperback]

Chris Fehily
5.0 out of 5 stars  See all reviews (7 customer reviews)

Available from these sellers.


Formats

Amazon Price New from Used from
Kindle Edition CDN $9.99  
Paperback --  
Save Up to 90% on Textbooks
Hit the books in Amazon.ca's Textbook Store and save up to 90% on used textbooks and 35% on new textbooks. Learn more.
There is a newer edition of this item:
SQL: Visual QuickStart Guide (3rd Edition) SQL: Visual QuickStart Guide (3rd Edition) 3.7 out of 5 stars (3)
CDN$ 35.90
In Stock.
Join Amazon Student in Canada


Book Description

July 29 2002 0321118030 978-0321118035 1

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?


Product Details


Product Description

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?

About the Author

Chris Fehily is a writer and consultant living in San Francisco.

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most helpful customer reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars Extensive Treatment of Nulls Sept. 5 2002
Format:Paperback
Anyone who uses SQL regularly knows that it's absolutely critical to understand nulls - you can't write SQL programs or interpret results without mastering them. In most of the SQL books that I've read, nulls are mentioned once near the beginning and not given much screen time afterwards - perhaps popping up in an example here and there. This book takes the different (and welcome) approach of weaving the implications of nulls throughout the entire text. In addition to null rudiments, this book addresses crucial issues such as detecting and counting nulls, how nulls give rise to three-value logic (true/false/unknown), when nulls are considered to be duplicates and when they aren't, substituting actual values for nulls and vice versa, how nulls sort, how nulls propagate through computations, which functions ignore nulls and which don't, how nulls affect joins, and how nulls cause problems in subqueries. The book also contains specific tips for Oracle, which (for some reason) considers empty strings to be nulls.
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars This Book Makes My Job Easier. Sept. 4 2002
Format: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.
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Start Your Queries Now! Feb. 15 2003
Format: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 subsetting, fucntions, grouping, joins, subqueries, 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.
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Amazing SQL query book May 1 2003
Format:Paperback
I would recommend this SQL book for acadamic classes to use it. As most of the SQL text book out the market really confuse student a lot without practical examples on how to use it. This book explains in details in a qucik and visul way. Students can also use this book as reference on how different database work with SQL. Excellent SQL book i have never seen before. Thanks for the author, Chris Fehily who did the great job on it.
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category


Feedback