Head First PHP & MySQL
by Lynn Beighley; Michael Morrison
Learning SQL, 2nd Edition
by Alan Beaulieu
SQL Pocket Guide, 2nd Edition
by Jonathan Gennick
NHibernate in Action
by Pierre Henri Kuaté; Christian Bauer; Gavin King; Tobin Harris
Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.
Step through the basic SQL syntax
Learn how to use best practices in database design
Master advanced syntax like inner joins, groups, and subqueries
Understand the SQL datatypes
And much more...
Average Amazon.com® Rating: ![]()
![]()
![]()
![]()
Based on 6 Ratings
A Good Basic Intro to SQL Statement Writing - 2009-03-22
Reviewer Rating: ![]()
![]()
![]()
![]()
![]()
Simply SQL is a basic introduction of writing SQL statements. It covers the elements of statement development, covers the keywords, and also includes a brief discussion of database design.
The writing is clear and concise, many of the "gotchas" of statement writing are covered. Some of the fine points of choices re data types are described.
This is a good introduction to the subject.
Excellent Book for learning SQL! - 2010-02-02
Reviewer Rating: ![]()
![]()
![]()
![]()
![]()
This book is by far the best SQL learning book I ever purchased. I struggle in college learning SQL from books that served it's purpose of confusing me and professors that couldn't teach but hold PhDs. I wished I had this book back then...so if you are a student learning SQL, consider yourself lucky to have a book this clear and concise. Buy it, it's totally worth it and throw away other books you have (please don't donate them to the library as you will be confusing other).
A pick for any library catering to computer programmers and SQL designers - 2009-06-17
Reviewer Rating: ![]()
![]()
![]()
![]()
![]()
Teach yourself SQL the easy way, with a step-by-step guide to writing it. From the best SQL codes to discussions of standard syntax, database design best practices, and advanced operations, SIMPLY SQL is one of the best guides available for programmers new to the language and is a pick for any library catering to computer programmers and SQL designers.
Good book with clear info that does well at maintaining focus on its intended audience - 2009-05-30
Reviewer Rating: ![]()
![]()
![]()
![]()
![]()
I found this book easy to read and understand. I liked that the code focus is on using ANSI standard SQL as this gives knowledge that will work across platforms on multiple database systems from free options like MySQL to common proprietary ones like Oracle and SQL Server. The examples are clear and well written and the figures are wonderful (as is usual in sitepoint products).
This book is not intended for people who wish to learn to become database administrators. It was written for web developers who want to have a better understanding of the basics of SQL. This is an important fact. If you fit this role, this book is excellent. If you want to go deeper, O'Reilly's Learning SQL is better.
I appreciated the book's focus on adhering to ANSI standards while noting how different databases from various vendors may require slight adjustments in coding. This book is suitable for people using any of the databases mentioned in the first paragraph and others.
The coding style was easy to read, but there were some odd quirks that I didn't like. For example, as noted by the author himself, he likes to put commas at the beginning of lines when making lists. This is the only place I have ever seen that done. Now, this isn't technically wrong, but it is unusual. I would have preferred to see code examples written with strict adherence to commonly accepted standards as this makes the task of reading other people's code or writing good and readable code easier. However, I guess doing it this way can also be seen as a benefit as it will remind the reader that there is more than one way to do things, and that in the real world he will be sure to encounter non-standard methods and have to adapt. Honestly, that is my only big complaint about the book, and it isn't a deal breaker.
If you are part of the intended audience for the book and are interested in learning SQL, this book should serve you quite well.
Great Introduction to the SQL Language and Writing Queries - 2009-04-23
Reviewer Rating: ![]()
![]()
![]()
![]()
![]()
Most SQL documentation and books show syntax and convoluted examples that you would never use in real life, or show such simple examples you can't use any of their queries in a real database.
Simply SQL explains the syntax simply, moving into practical examples of how to write SQL queries and administer databases. It's an excellent "getting started" guide for anyone building database-driven websites, but is also an excellent reference for the seasoned developers (like myself). There are always times when I'm not quite sure how to handle a particular query.
I'd recommend Simply SQL for anyone who needs to administer a database as part of web development or programming.
Top Level Categories:
Databases
Sub-Categories:
Databases > Database Design
Databases > SQL
Some information on this page was provided using data from Amazon.com®. View at Amazon >