Simply SQL / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
$25.44
Buy Used
Buy Used from BN.com
$20.56
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $11.24
Usually ships in 1-2 business days
(Save 67%)
Other sellers (Paperback)
  • All (23) from $11.24   
  • New (13) from $17.61   
  • Used (10) from $11.24   

Overview

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...
Read More Show Less

Product Details

  • ISBN-13: 9780980455250
  • Publisher: SitePoint Pty, Limited
  • Publication date: 12/1/2008
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 318
  • Sales rank: 678,254
  • Product dimensions: 7.00 (w) x 8.90 (h) x 0.80 (d)

Meet the Author

Rudy Limeback is a semi-retired SQL Consultant living in Toronto, Canada. His SQL experience spans more than 20 years, and includes working with DB2, SQL Server, Access, Oracle, and MySQL. He is an avid participant in discussion forums, primarily at SitePoint (http: //sitepoint.com/forums/). His two Web sites are http: //r937.com/ for SQL and http: //rudy.ca/ for personal stuff. When not glued to his computer, Rudy enjoys playing touch football and frisbee golf.

Read More Show Less

Table of Contents

Preface

1 An Introduction to SQL 1

2 An Overview of the SELECT Statement 23

3 The FROM Clause 35

4 The Where Clause 73

5 The Group By Clause 103

6 The Having Clause 125

7 The Select Clause 133

8 The Order By Clause 161

9 SQL Data Types 183

10 Relational Integrity 211

11 Special Structures 237

A Testing Environment 253

B Sample Applications 259

C Sample Scripts 265

D SQL Keywords 285

Index 287

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted March 6, 2009

    VERY VERY HIGHLY RECOMMENDED!!

    Are you a web designer or developer looking for guidance in learning SQL for your web projects? If you are, then this book is for you! Author Rudy Limeback, has done an outstanding job of writing a book about SQL.


    Limeback, begins by putting the SQL language into a perspective relevant to a typical web developer. Next, the author dissects the SQL SELECT statement into its component and clauses and gives you a taste of what's to come. Then, he will ease you through the tricky subject of database table joins, where you'll easily master the concepts of the inner join, left outer join, right outer join, full outer join, and cross join. He continues by showing you how to express conditions using SQL keywords: LIKE, BETWEEN, AND, OR, IN, EXISTS, and NOT; as well as, correlated subqueries. Next, the author shows you how to group works and the rules for its use. Then, he shows you how to write HAVING clause conditions, and how to use the HAVING clause without a GROUP BY clause. The author continues by showing you how to use the SELECT clause effectively, and how its scope changes in the presence or absence of the GROUP BY clause. Next, he focuses on sequencing the various data types, and the difference between sequencing the various data types, and the difference between sequencing and grouping. He continues by providing a detailed look at the various numeric, character, and temporal data types available for columns, and the rationales for their use. Next, the author introduces some topics that are the source of much befuddlement for many people new to databases. Finally, the author examines some of the common database structures that can be used to implement complex relationship between entities.


    This most excellent book explored all of the aspects of SQL and database design that are required by web developers to develop efficient and effective web pages. More importantly, it covered not only simple examples of SQL that are relevant to you, but also more complex concepts using terminology that is not too obscure.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)