Learning SQL

( 11 )

Overview

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.

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 ...

See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (3) from $10.0   
  • Used (17) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$10.00
Zeebooks AL
Seller since Sun Jan 01 01:01:01 EST 2006

Feedback rating:

(59)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
PAPERBACK New 0596007272.

Ships from: Foley, AL

Usually ships in 1-2 business days

  • •Canadian
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$60.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$60.00
bluehouse
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Learning SQL

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • 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)
$15.49
BN.com price
(Save 44%)$27.99 List Price

More About This Book

Overview

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.

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: 9780596007270
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 9/10/2005
  • Edition number: 1
  • Pages: 312
  • Product dimensions: 7.02 (w) x 9.16 (h) x 0.75 (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

1. A Little Background
     Introduction to Databases
     What Is SQL?
     What Is MySQL?
     What's in Store

2. Creating and Populating a Database
     Creating a MySQL Database
     Using the mysql Command-Line Tool
     MySQL Data Types
     Table Creation
     Populating and Modifying Tables
     When Good Statements Go Bad
     The Bank Schema

3. Query Primer
     Query Mechanics
     Query Clauses
     The select Clause
     The from Clause
     The where Clause
     The group by and having Clauses
     The order by Clause
     Exercises

4. Filtering
     Condition Evaluation
     Building a Condition
     Condition Types
     NULL: That Four-Letter Word
     Exercises

5. Querying Multiple Tables
     What Is a Join?
     Joining Three or More Tables
     Self-Joins
     Equi-Joins Versus Non-Equi-Joins
     Join Conditions Versus Filter Conditions
     Exercises

6. Working with Sets
     Set Theory Primer
     Set Theory in Practice
     Set Operators
     Set Operation Rules
     Exercises

7. Data Generation, Conversion, and Manipulation
     Working with String Data
     Working with Numeric Data
     Working with Temporal Data
     Conversion Functions
     Exercises

8. Grouping and Aggregates
     Grouping Concepts
     Aggregate Functions
     Generating Groups
     Group Filter Conditions
     Exercises

9. Subqueries
     What Is a Subquery?
     Subquery Types
     Noncorrelated Subqueries
     Correlated Subqueries
     When to Use Subqueries
     Subquery Wrap-up
     Exercises

10. Joins Revisited
     Outer Joins
     Cross Joins
     Natural Joins
     Exercises

11. Conditional Logic
     What Is Conditional Logic?
     The Case Expression
     Case Expression Examples
     Exercises

12. Transactions
     Multiuser Databases
     What Is a Transaction?

13. Indexes and Constraints
     Indexes
     Constraints

A. ER Diagram for Example Database

B. MySQL Extensions to the SQL Language

C. Solutions to Exercises

D. Further Resources

Index

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)
Sort by: Showing all of 11 Customer Reviews

  • Anonymous

    Posted Thu Apr 20 00:00:00 EDT 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  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Posted Fri Jul 09 00:00:00 EDT 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  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Posted Mon Mar 30 00:00:00 EDT 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  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Sun Jun 26 00:00:00 EDT 2011

    No text was provided for this review.

  • Anonymous

    Posted Thu Dec 10 00:00:00 EST 2009

    No text was provided for this review.

  • Anonymous

    Posted Wed Nov 11 00:00:00 EST 2009

    No text was provided for this review.

  • Anonymous

    Posted Tue Dec 01 00:00:00 EST 2009

    No text was provided for this review.

  • Anonymous

    Posted Tue Jun 28 00:00:00 EDT 2011

    No text was provided for this review.

  • Anonymous

    Posted Tue Jun 15 00:00:00 EDT 2010

    No text was provided for this review.

  • Anonymous

    Posted Wed Nov 23 00:00:00 EST 2011

    No text was provided for this review.

  • Anonymous

    Posted Thu Oct 27 00:00:00 EDT 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)