Sql for Dummies

by Allen G. Taylor

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them.Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities - the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, "SQL For Dummies, 5th Edition, " sweeps away the database mystique.Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using But you don't have to be a database newbie to find value in "SQL For Dummies, 5th Edition"; even if you have some experience designing and creating databases, you may discover a few things you didn't know about.Here's just a sampling of some of the things you'll find covered in "SQL For Dummies, 5th "Exploring relational database and SQL fundamentalsBuilding and maintaining a simple database structureBuilding a multiple relational databaseManipulating database dataExamining SQL nuts and values, expressions, operators, and queriesProviding database security and protecting your dataExploring ODBC and JDBC, and using SQL with XMLMoving beyond the cursors, persistent stored modules, and error-handlingTop Ten lists on common SQL mistakes and retrieval tipsPlain and simply, databases are the best tools ever invented for keeping track of the things you care about. After you understand databases and can use SQL to make them do your bidding, you wield tremendous power. "SQL For Dummies, 5th Edition, " can get you well on your way to harnessing the power of databases.

Genres: Reference, Nonfiction, Programming, Technical, Technology, Computer Science, Computers

432 pages, Kindle Edition

First published January 1, 1997

Reviews

[KP · Rating 3 out of 5]

A good introduction for someone who has never used SQL before. Don't use this book for instructions on how to do complicated queries, but do read it if you want to know what sql does, and basic commands and how to use them. this is the first technical text which i felt able to read from cover to cover, rather than giving up at chapter 2.

[Dragomir Draganov · Rating 3 out of 5]

Информативна книга, въвеждаща в тайните на SQL. Подходяща е за съвсем начинаещи, които за първи път се сблъскват с езика и работата с релационни бази данни. Дава добра рамка за по-нататъшни търсения.

[Xapphirea · Rating 2 out of 5]

+ Nice to learn new stuff
+ Funny at times
+ A good, cheap alternative to an expensive course
-It isn't really fit for learning for there are no practices
- It skips handy details to zoom in on stuff I barely need
- No dragons

[Charlie Lee]

It's a 500 page book on SQL.

[Bernie4444 · Rating 3 out of 5]

All that it claims to be

I like to start projects with simple concepts and a few examples to get off the ground. Well, this book does just that. Unfortunately, I would also like to have some examples of input and output.

I chose this book because it was not database specific, as I am converting files from an Informix database, through a filter, to a flat file, for later conversion to an Oracle database, with a different structure.

Unfortunately, this book (being universal) has no universal explanation as to how to get information from a flat file in or out of the database. First, you have to find the term they use, not ASCII, not flat, not import, not export, not not not. The term is found in chapter 7 "foreign." The explanation on how to do this is to "...turn to one of the professional data translation services." Great, just what I wanted to know.

[Chloe Thonus · Rating 3 out of 5]

It's fine as a reference guide or for understanding specific commands/syntax, but doesn't really allow you to practice. It's good for a surface level of knowledge but won't exactly turn you into an SQL developer, better to take a class or learn from someone who already knows. Has some good information on databases and how they work though.

[Ben · Rating 5 out of 5]

I use SQL every day, so I am fairly well-versed in it.

Even at that, I still enjoyed this book.

I didn't learn too much new, but found a few cool shortcuts and ideas.

Would recommend if learning SQL

[Yesi Days · Rating 4 out of 5]

Está bien para iniciarse en SQL, habla de las sentencias generales y presenta ejemplos claros. En lo personal agregaría queries más complejas.

[Niklas Angmyr · Rating 3 out of 5]

SQL for not so dumb people.

[Ben Stenhaug · Rating 2 out of 5]

Seems fine but not the best out there

[Phil Branigan · Rating 4 out of 5]

Yet another really useful book in it's day, now withdrawn according to the stamp inside the cover. It is full of all the basic instructions you need to start understanding and using SQL.

[Deep · Rating 3 out of 5]

It is rather a okay-okay but funny book. Yeah, funny! And I actually admire Allen's friendly conduct throughout the book. Yet, I wouldn't say it is a great book 'cause often enough, whenever I felt like that the topic needs further explanation and examples, Allen just jumps to the next topic and often enough he would delve needlessly into something very clear. He would literally go by the name of the book. Like, " If the expression evaluates to True, the predicate returns TRUE; (well of course it would) otherwise, it returns FALSE. " (oh, Really!). This line appears near the end of the book and it is sandwiched between similar statements. And there are other examples when you would say, okay, move on, I get it!

Another thing that disappointed me is the lack of cross-reference among the topics, and most often when it is somewhat vital (not that your life depends upon it). Like suddenly the keyword FETCH with its important functionality appears without being introduced before and is introduced a few pages later.

Throughout the book topics are scattered and not arranged properly so that the reader could be at much ease. I think that editors should have done something about that.

But then, yea, it isn't that you don't learn a thing here. Yes, you pretty much get what you were looking for with pretty much fun, like Can you imagine what your life would have been like in the caveman times of 1992, when you’d have to repeatedly swap between SQL and its procedural host language just to do your work?

[Brian · Rating 3 out of 5]

Actually read a newer version than this, but the 6th edition was not shown here. It is fine for a teaching/reference guide, but like with a lot of coding or problem-solving situations, there was not much in the way of hands-on work suggested here. Best thing to have done was to have included some way to have put a creatable database into the lesson, and given some sort of chapter-by-chapter guide to add onto that database/learn the ins and outs of SQL.

[John · Rating 5 out of 5]

A great book to 'Drop' into when you need that bit of clarification - or it's been a while since you've had to do something away from the norm.

I'd recommend this to any techie who either is an SQL jockie or has the occasional requirement for using SQL 'In Anger'.

[J.S. · Rating 2 out of 5]

Finished my exploratory read of this book. It reminded me of my IUN days and data structures class. Although this book is a bit out dated, it was a good reintroduction to SQL. I'm not sure if I will continue with my SQL adventures, but if I had too, I would.
JS

[Jonathan]

None

[Mark Balson · Rating 3 out of 5]

This is not a beginners book. I could not get through it.

[Davy · Rating 3 out of 5]

This book would be improved tremendously if the examples could be used to build an actual db. As it is now, it'll see use as a reference work.

[Fausto Betances · Rating 4 out of 5]

Good for what I needed. Scant practices.