 | |
| |
SQL: Visual QuickStart Guide
 |
Author: Chris Fehily
List Price: $21.99
Our Price: Click to see the latest and low price
ISBN: 0321118030
Publisher: Peachpit Press (19 July, 2002)
Edition: Paperback
Sales Rank: 17,061
Average Customer Rating: 5 out of 5
|
Customer ReviewsRating: 5 out of 5
Amazing SQL query book
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.
Rating: 5 out of 5
Start Your Queries Now!
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.
Rating: 5 out of 5
Extensive Treatment of Nulls
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.
Similar Products
· PHP for the World Wide Web Visual Quickstart Guide
· Perl and CGI for the World Wide Web: Visual QuickStart Guide, Second Edition
· XML for the World Wide Web: Visual QuickStart Guide
· MySQL: Visual QuickStart Guide
· Sams Teach Yourself SQL in 10 Minutes (2nd Edition)
| | | | | |
| |
