- Paperback: 424 pages
- Publisher: Peachpit Press; 1 edition (July 29 2002)
- Language: English
- ISBN-10: 0321118030
- ISBN-13: 978-0321118035
- Product Dimensions: 22.6 x 17.8 x 2.3 cm
- Shipping Weight: 635 g
- Average Customer Review: 5.0 out of 5 stars See all reviews (7 customer reviews)
-
Amazon Bestsellers Rank:
#51,699 in Books (See Top 100 in Books)
- #6 in Books > Computers & Internet > Databases > Relational Databases
- #23 in Books > Computers & Internet > Software > Databases
- #50 in Books > Computers & Internet > Databases > Database Management Systems
- See Complete Table of Contents
|
||||||||||||||||||
|
||||||||||||||||||
|
||||||||||||||||||
| ||||||||||||||||||
|
There is a newer edition of this item:
|
Product Details |
Product Description
Book Description
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?
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?
Inside This Book
(Learn More)
Browse and search another edition of this book.
Browse and search another edition of this book.
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most helpful customer reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars
Extensive Treatment of Nulls,
By Kenneth L Gutwillig (New York, NY United States) - See all my reviews
This review is from: SQL: Visual QuickStart Guide (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.
2 of 2 people found the following review helpful
5.0 out of 5 stars
This Book Makes My Job Easier.,
By Melanie Pennington (Portland, OR United States) - See all my reviews
This review is from: SQL: Visual QuickStart Guide (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.
1 of 1 people found the following review helpful
5.0 out of 5 stars
Amazing SQL query book,
By "atl123" (Boston, MA) - See all my reviews
This review is from: SQL: Visual QuickStart Guide (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.
Share your thoughts with other customers: Create your own review
Want to see more reviews on this item?
|
Most recent customer reviews |
Listmania!
Look for similar items by category
- Books > Computers & Internet > Databases > Database Management Systems
- Books > Computers & Internet > Databases > Relational Databases
- Books > Computers & Internet > Programming
- Books > Computers & Internet > Software > Databases
- Books > Computers & Internet > Web Development > Programming > SQL
- Books > Professional & Technical > Professional Science > Mathematics
Look for similar items by subject
Feedback
Would you like to update product info or give feedback on images?
