- You'll save an extra 5% on Books purchased from Amazon.ca, now through July 29th. No code necessary, discount applied at checkout. Here's how (restrictions apply)
SQL All-in-One For Dummies Paperback – Apr 5 2011
|New from||Used from|
Special Offers and Product Promotions
Frequently Bought Together
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Back Cover
Want to be a database diva or the office's information oracle? Do it with SQL — here's how!
SQL does one thing, and it does that better than any other language: it handles data in relational databases. SQL lets you create databases, manipulate the data in them, retrieve information, control who has access, and much more. Whether you're new to SQL or an old hand who wants to supercharge your database, find help in one of these minibooks!
The overview — Books I and II give you the nitty-gritty about SQL, relational databases, and the System Development Life Cycle
If you have queries — learn the fine points of making SQL retrieve exactly what you want from the database and no more
Safety first — discover the tools SQL provides to protect your vital data and handle any errors that occur
Integrating SQL with other languages — understand how SQL works with Visual Basic, Java, C++, and XML
Turbocharge your database — fine-tune and optimize your databases to keep them performing optimally
Visit the companion Web site at www.dummies.com/go/sqlaiofd2e to download a zip file that contains all the sample code used in this book
Open the book and find:
Details of how SQL works
SQL data types
Why the System Development Life Cycle matters
Directions for structuring SQL queries
Tips for protecting your database from user errors
Sample applications you can use
Ways to track down and eliminate bottlenecks
Definitions of common SQL terms
8 Books in 1
Relational Database Development
SQL and Programming
SQL and XML
Database Tuning Overview
About the Author
Allen G. Taylor lectures nationally on databases, innovation, and entrepreneurship, and teaches database development internationally through a leading online education provider. Among his more than 20 books are all editions of SQL For Dummies and Database Development For Dummies.
What Other Items Do Customers Buy After Viewing This Item?
Most Helpful Customer Reviews on Amazon.com (beta)
I particularly enjoyed his description of all the standard SQL data types from char, varchar to national char, blob and clob. There are some nuances between various data-types which I was a bit hazy on, but this book cleared that all up. He does a great job explaining things like indexing and how to tune up database queries. He touches on some advanced concepts like EF Codds normal forms, and explains some of the differences, and even tells you which normal forms are too obscure to really be relevant for most database systems. He also explains why de-normalization matters and how to find that "sweet spot" between performance and robustness (resistance to modification anomalies).
If you're not already familiar with RDBMS concepts like relations, attributes, tuples, ER models, and such, this book may be a very valuable read for you. I'm giving this book 5 stars because it gave me exactly what I wanted-- about 640 pages summarizing all the important concepts of SQL, plenty of real life examples, and illustrations as well.
What a surprise. This is an excellent book, sitting astride the area that goes from basic introduction well into hands-on. It's written clearly without a hint of the condescension I feared. It does assume some technical background, but the author has a good sense of where the reader's knowledge is likely to end. I was impressed with the overall organization. It's 8 books (sort-of), with the goal of each well-delineated. Each volume has a clearly stated purpose and is written with a clarity that is rare among technical writers.
For those of us willing to admit an occasional bout of dummyhood, this is a fine antidote.
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Programming > Introductory & Beginning > For Dummies - Programming
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software > Introductory Guides
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > For Dummies Store > Computers & Internet > Programming
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages