SQL For Dummies? (For Dummies (Computers))
Author | : | |
Rating | : | 4.40 (607 Votes) |
Asin | : | 0764507370 |
Format Type | : | paperback |
Number of Pages | : | 456 Pages |
Publish Date | : | 2013-10-24 |
Language | : | English |
DESCRIPTION:
It helps you take advantage of SQL's rich assortment of tools and powerful new object-relational features to snag all the information you need from your databases quickly and easily.. Understanding databases and SQL gives you tremendous power to access the information you need. It shows programmers how to incorporate SQL into programs for powerful data manipulation and retrieval, including operation on non-text objects such as graphical images and sound files. This book shows you how to use DBMS to define, administer, and process databases and their associated applications. Find out how to create and maintain powerful databases -- it's easy with this book! Databases are the best tools ever invented for keeping track of the things users care about
Some sections show several screen shots from Delphi and it may be difficult to follow along in these sections if you don't have the program in front of you. . Like many of the books in IDG's Dummies series, this volume begins with a definition ("What is SQL?") and ends with "The Part of Tens," a collection of tips in a top ten list form. Taylor writes in a breezy, entertaining style that SQL novices will find inviting. This is the rare case of a book that can take you from a beginner to an advanced-intermediate level. One caveat: The examples are given in Borland's Delphi, a rapid application development (RAD) tool. As with other Dummies books, SQL for Dummies is entertaining to read although the nonstop jokes may distract some reader
"You will be dummy if you buy this book" according to JohnDoe155. Poorly written, jumps back and force between the topics not yet explained. Good for Some A Customer A good introduction to SQL for people who have some programming experience, and need to know how to integrate their applications with a database, and for people who use MS Access, but want to work independently of the query design grid. The book is especially good for defining the common SQL and database terminology. It was nice to finally get a thorough explanation of the various types of joins, and the brief chapter on ODBC was pleasantly simple. SQL is not a very exciting subject, however, and a little more humor would have been helpful to ward off boredom. Some hands-on exercises for MS Access, VB or SQL Server would have been. "Overall adequate, but could have been better" according to David H Schneider. First off, I must stress that after I finished reading this book I did walk away with a far greater knowledge of SQL. To this end the book served its purpose and was worth the time/money I invested in the book.My most serious criticism is that the early chapters introduced complex examples, which I forced myself to understandonly to discover that the author explained the issues more thoroughly at a later stage. On page 55 the author explains the MIN function with a sub/nested SQL queryintroducing nested queries at such an early stage was a little confusing and it distracted me from the function being discussed.As a result I spent
Allen G. He also teaches database development and Crystal Reports through a leading online education. Taylor is a 30-year veteran of the computer industry and the author of 30 books, including Cruise for Free, SQL For Dummies, 8th Edition, Crystal Reports 2008 For Dummies, Database Development For Dummies, Access Power Programming with VBA, and SQL All-In-One For Dummies, S