<< 1 >>
Rating: 
Summary: Extensive Treatment of Nulls
Review: 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.
Rating:
Summary: Start Your Queries Now!
Review: 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:
Summary: Amazing SQL query book
Review: 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:
Summary: Amazing SQL query book
Review: 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:
Summary: This book helped get me a job
Review: 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!
Rating:
Summary: This Book Makes My Job Easier.
Review: 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.
<< 1 >>
|
