BN.com Gift Guide

Learning SQL

( 11 )

Overview

Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations ...

See more details below
Paperback (Second Edition,Annotated)
$24.29
BN.com price
(Save 39%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (18) from $11.00   
  • New (8) from $21.76   
  • Used (10) from $11.00   
Learning SQL

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:

  • Move quickly through SQL basics and learn several advanced features
  • Use SQL data statements to generate, manipulate, and retrieve data
  • Create database objects, such as tables, indexes, and constraints, using SQL schema statements
  • Learn how data sets interact with queries, and understand the importance of subqueries
  • Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Don’t just skim SQL’s surface: Gain a real understanding of what it can do -- in less than 300 pages.

Alan Beaulieu’s Learning SQL starts with all the background you need: No SQL or database experience is required. In the first few chapters, you’ll walk through creating and populating your first database. (Download MySQL and follow along.) You’ll write basic queries, filter data, query multiple tables, work with sets, use built-in functions. Gradually, you’ll move to more complex tasks: grouping, aggregates, and subqueries; even joins, transactions, and indexes.

Beaulieu’s examples are tested with MySQL, Oracle, and SQL Server (and should work fine with most recent databases). The result: a book that’ll work in any environment, whether you’re building applications, working as an admin, or just trying to coax a database into coughing up the right information. Bill Camarda, from the November 2005 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780596520830
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 4/27/2009
  • Edition description: Second Edition,Annotated
  • Edition number: 2
  • Pages: 338
  • Sales rank: 127,172
  • Product dimensions: 6.90 (w) x 9.10 (h) x 0.80 (d)

Meet the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.

Read More Show Less

Table of Contents

Preface

Chapter 1: A Little Background

Chapter 2: Creating and Populating a Database

Chapter 3: Query Primer

Chapter 4: Filtering

Chapter 5: Querying Multiple Tables

Chapter 6: Working with Sets

Chapter 7: Data Generation, Conversion, and Manipulation

Chapter 8: Grouping and Aggregates

Chapter 9: Subqueries

Chapter 10: Joins Revisited

Chapter 11: Conditional Logic

Chapter 12: Transactions

Chapter 13: Indexes and Constraints

Chapter 14: Views

Chapter 15: Metadata

ER Diagram for Example Database

MySQL Extensions to the SQL Language

Solutions to Exercises

Colophon

Read More Show Less

Customer Reviews

Average Rating 4.5
( 11 )
Rating Distribution

5 Star

(7)

4 Star

(2)

3 Star

(2)

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 all of 11 Customer Reviews
  • Anonymous

    Posted April 20, 2006

    HIGHLY RECOMMENDED!!

    Are you working with relational databases and writing applications, performing administrative tasks, or generating reports? If you are, you're in luck! Author Alan Beaulieu, has done an outstanding job of writing a book that will show you how to interact with the data in your database. Beaulieu, begins by exploring the history of computerized databases, including the rise of the relational model and the SQL language. Then, he demonstrates how to create a MySQL database, create the tables used for the examples in this book, and populate the tables with data. The author continues by introducing the select statement and further demonstrating the most common clauses. Next, he demonstartes the different types of conditions that can be used in the where clause of a select, update, or delete statement. Then, the author shows you how queries can utilize multiple tables via table joins. He continues with a discussion about data sets and how they can interact within queries. Then, he demonstrates several built-in functions used for manipulating or converting data. The author continues by showing you how data can be aggregated. Next, he introduces the subquery and shows how and where they can be utilized. Then, the author further explores the various types of table joins. He continues by exploring how conditional logic can be utilized in select, insert, update, and delete statements. Then, the author introduces transactions and shows how to use them. Finally, he explores indexes and constraints. While this most excellent book demonstrates many of the SQL schema statements, the main focus of this book is on programming features. Filled with example code, you may use some of the code in this book in your programs and documentation. Basically, this book is here to help you get your job done--whatever it may be.

    3 out of 3 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted July 9, 2010

    more from this reviewer

    Good begineer book

    I would recommend this book to anyone who is starting to learn SQL.

    This book is a begineers book teaching various SQL statements like SELECT, INSERT, DELETE. The book starts off with the available database models like Network, Object and Heirarchical models and then goes ahead and explains the commands. The commands are written for MySQL which is freely available for download and install. The author also explains the variations in Oracle and SQL Server where appropriate.

    The commands are grouped together and covered one by one. The topics covered are statements like SELECT, INSERT, DELETE, aggregate functions, joining more than one table, set operations like union, intersection, views, indexes, constraints, transaction etc.

    There is also "Test your knowledge" at the end of each chapter which helps you to reinforce what you just learnt with the solutions at the end of the book in case you are struck and don't know how to proceed.

    This book just introduces all the beginners concept in a nice way. The examples are simple to follow and learn.

    PROS : Covers all SQL commands, Show different variations among Database vendors

    CONS : Begineer book (no indepth knowledge)

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted March 30, 2009

    more from this reviewer

    Excellent Beginner Book

    Learning SQL gets you up and running with the language very quickly. The introduction is easy to read and the first instructions are well chosen. It uses an example that can be downloaded from the O'Reilly site and MySQL Server as the programming platform. I opened the book not knowing a thing about SQL and it has helped me plenty.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted June 26, 2011

    No text was provided for this review.

  • Anonymous

    Posted December 10, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 11, 2009

    No text was provided for this review.

  • Anonymous

    Posted December 1, 2009

    No text was provided for this review.

  • Anonymous

    Posted June 28, 2011

    No text was provided for this review.

  • Anonymous

    Posted June 15, 2010

    No text was provided for this review.

  • Anonymous

    Posted November 23, 2011

    No text was provided for this review.

  • Anonymous

    Posted October 27, 2011

    No text was provided for this review.

Sort by: Showing all of 11 Customer Reviews

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