SQL: A Beginner's Guide, Second Edition [Paperback]

Robert Sheldon (Author)

Book Description

ISBN-10: 0072228857 | ISBN-13: 978-0072228854 | Publication Date: April 28, 2003 | Edition: 2

Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you�ll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.

Editorial Reviews

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Product Details

• Paperback: 560 pages
• Publisher: McGraw-Hill Osborne Media; 2 edition (April 28, 2003)
• Language: English
• ISBN-10: 0072228857
• ISBN-13: 978-0072228854
• Product Dimensions: 9.1 x 7.2 x 1.2 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #860,516 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful:

4.0 out of 5 stars Very well written for new SQL user, September 26, 2003

By 

Francis D. Ferrall "Delphititan" (Portland, OR) - See all my reviews
(REAL NAME)   

This review is from: SQL: A Beginner's Guide, Second Edition (Paperback)

This book helped me get my web development project well on the way. I am using PowerBuilder to build a web based application and I needed to learn SQL programming quickly for the database component. The author was easy to understand and uses lesson plans that make it easy to learn SQL at a reasonable pace. I was able to get up and running with the basics and am becoming more proficient as I implement more of the examples in the book.
I recommend this book to anyone new to SQL. I think it may be useful to experienced SQL developers also but I cannot speak for the more advanced users since I am so new.

5 of 6 people found the following review helpful:

3.0 out of 5 stars Good book but somewhat hard to follow, October 9, 2005

By 

A. Reed "Student" (Fayetteville, NC) - See all my reviews
(REAL NAME)   

This review is from: SQL: A Beginner's Guide, Second Edition (Paperback)

The book I think would be more effective if we knew what software is preferred. If the book was designed with SQL Server in mind then the book should have been designed for this version. I think the author should have made different versions for different DBMS, this way the book would be more effective. If the book was going to be used for all databases then they should have included the commands used for each DBMS. Otherwise why include a step by step if not all the commands are going to work. The book is however, very well written and easy easy to follow, but there are parts of the projects that become rather difficult to follow because the book doesn't include the commands for your DBMS. In addition, the book doesn't include a DBMS program nor does it suggest what is the best program to use with this book.

Rating the book from 1 to 5 I would give it a 3. The lack of 2 points is mainly because there are parts in the book that doesn't work with the DBMS. If I wasn't using SQL Server I would give it a much lower number.

2 of 2 people found the following review helpful:

4.0 out of 5 stars Solid introduction to core SQL, May 6, 2007

By 

Andrew E. Schulman (Bethesda, MD USA) - See all my reviews
(REAL NAME)   

This review is from: SQL: A Beginner's Guide, Second Edition (Paperback)

This book teaches core or basic SQL, that is, the subset of the language that's common to all of the many database products. That's a hard thing to do well, because the common core is small compared to the wide variety of vendor-specific extensions. But it's worth doing, and this book does it well. Approaching SQL for the first time, I used the book to get a foundation of understanding and get up and running creating tables, constraints, and views, and constructing queries, joins, and subqueries.

The book's explanations are clear, and the selection of material seems good. The end-of-chapter review questions are helpful. The exercises are helpful and essential, but I found them to be somewhat too mechanical, and there should be more of them to help cement each topic before moving on to the next.

The book's vendor-neutral approach has its costs. Some of the features that it describes, such as catalogs and roles, aren't implemented in all database products, so you have to try them with your database or consult your documentation to find out. The book is very clear about this, though; I never found an example that didn't work that wasn't flagged as not supported in all products. And an alternative approach is always provided. As another reviewer pointed out, the book describes the crucial 'Hello World' task of connecting to the database server and submitting your first SQL statement in only general terms, since it depends on your database product and client. And unfortunately one very important set of tasks is vendor-specific and therefore not covered here: finding out what databases, users, and roles are present, and what the structure of each database and table is.

In summary, if you know you want to use SQL with a particular database product, you'd probably do better to get a book that's specific to that product. But if you want to understand and use the core of SQL before you move on to your vendor's extentions, this is a good book to get you there.