BN.com Gift Guide

Discovering SQL: A Hands-On Guide for Beginners

Overview

Teaching the SQL skills that businesses demand when hiring programmers

If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 ...

See more details below
Paperback
$26.19
BN.com price
(Save 25%)$34.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (19) from $3.45   
  • New (12) from $6.58   
  • Used (7) from $3.45   

Overview

Teaching the SQL skills that businesses demand when hiring programmers

If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL.

  • Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code
  • Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered
  • Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software
  • Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity

Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.

Read More Show Less

Product Details

  • ISBN-13: 9781118002674
  • Publisher: Wiley
  • Publication date: 4/19/2011
  • Edition number: 1
  • Pages: 432
  • Sales rank: 957,650
  • Product dimensions: 7.30 (w) x 9.20 (h) x 0.90 (d)

Meet the Author

Alex Kriegel is an enterprise systems architect for the Oregon Health Authority, State of Oregon. He has more than 20 years of professional database and software development experience and holds numerous certifications, including MCTS, PMP from Project Management Institute, TOGAF 8 Certified Practitioner from The Open Architecture Group, and Certified Scrum Master from Scrum Alliance.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Read More Show Less

Table of Contents

INTRODUCTION.

CHAPTER 1: DROWNING IN DATA, DYING OF THIRST FOR KNOWLEDGE.

CHAPTER 2: BREAKING AND ENTERING: STRUCTURED INFORMATION.

CHAPTER 3: A THING YOU CAN RELATE TO — DESIGNING A RELATIONAL DATABASE.

CHAPTER 4: OVERCOMING THE LIMITATIONS OF SQL.

CHAPTER 5: GROUPING AND AGGREGATION.

CHAPTER 6: WHEN ONE IS NOT ENOUGH: A QUERY WITHIN A QUERY.

CHAPTER 7: YOU BROKE IT; YOU FIX IT: COMBINING DATA SETS.

CHAPTER 8: WHAT ELSE IS THERE, AND WHY?

CHAPTER 9: OPTIMIZING PERFORMANCE.

CHAPTER 10: MULTIUSER ENVIRONMENT.

CHAPTER 11: WORKING WITH UNSTRUCTURED AND SEMISTRUCTURED DATA.

CHAPTER 12: NOT BY SQL ALONE.

APPENDIX A: INSTALLING RDBMSS RDBMS SOFTWARE.

APPENDIX B: ACCESSING RDBMSS.

APPENDIX C: ACCESSING RDBMSS WITH THE SQUIRREL UNIVERSAL SQL CLIENT.

APPENDIX D: INSTALLING THE LIBRARY DATABASE.

INDEX.

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

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