Sams Teach Yourself SQL in 10 Minutes

( 15 )

Overview

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach ...

See more details below
Paperback
$19.82
BN.com price
(Save 33%)$29.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (14) from $15.98   
  • New (12) from $15.98   
  • Used (2) from $19.81   
Sams Teach Yourself SQL in 10 Minutes

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

Want a NOOK? Explore Now

NOOK Book (eBook)
$13.49
BN.com price
(Save 43%)$23.99 List Price

Overview

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

New full-color code examples help you see how SQL statements are structured

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.

Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints.

You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete.

With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language.

10 minutes is all you need to learn how to...

  • Use the major SQL statements
  • Construct complex SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use aggregate functions to summarize data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, and more
Table of Contents

1 Understanding SQL

2 Retrieving Data

3 Sorting Retrieved Data

4 Filtering Data

5 Advanced Data Filtering

6 Using Wildcard Filtering

7 Creating Calculated Fields

8 Using Data Manipulation Functions

9 Summarizing Data

10 Grouping Data

11 Working with Subqueries

12 Joining Tables

13 Creating Advanced Joins

14 Combining Queries

15 Inserting Data

16 Updating and Deleting Data

17 Creating and Manipulating Tables

18 Using Views

19 Working with Stored Procedures

20 Managing Transaction Processing

21 Using Cursors

22 Understanding Advanced SQL Features

Appendix A: Sample Table Scripts

Appendix B: Working in Popular Applications

Appendix C : SQL Statement Syntax

Appendix D: Using SQL Datatypes

Appendix E: SQL Reserved Words


Read More Show Less

Product Details

  • ISBN-13: 9780672336072
  • Publisher: Sams
  • Publication date: 11/8/2012
  • Edition number: 4
  • Pages: 288
  • Sales rank: 69,558
  • Product dimensions: 6.00 (w) x 8.90 (h) x 0.50 (d)

Meet the Author

Ben Forta is Adobe Systems’ Director of Developer Relations and has more than 20 years of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes, spinoff titles on MySQL and SQL Server T-SQL, ColdFusion Web Application Construction Kit and Advanced ColdFusion Application Development (both published by Adobe Press), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, Windows, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on Internet and database technologies.
Read More Show Less

Table of Contents

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition

1 Understanding SQL

Database Basics

What Is SQL?

Try It Yourself

2 Retrieving Data

The SELECT Statement

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving All Columns

Retrieving Distinct Rows

Limiting Results

Using Comments

3 Sorting Retrieved Data

Sorting Data

Sorting by Multiple Columns

Sorting by Column Position

Specifying Sort Direction

4 Filtering Data

Using the WHERE Clause

The WHERE Clause Operators

5 Advanced Data Filtering

Combining WHERE Clauses

Using the IN Operator

Using the NOT Operator

6 Using Wildcard Filtering

Using the LIKE Operator

Tips for Using Wildcards

7 Creating Calculated Fields

Understanding Calculated Fields

Concatenating Fields

Performing Mathematical Calculations

8 Using Data Manipulation Functions

Understanding Functions

Using Functions

9 Summarizing Data

Using Aggregate Functions

Aggregates on Distinct Values

Combining Aggregate Functions

10 Grouping Data

Understanding Data Grouping

Creating Groups

Filtering Groups

Grouping and Sorting

SELECT Clause Ordering

11 Working with Subqueries

Understanding Subqueries

Filtering by Subquery

Using Subqueries as Calculated Fields

12 Joining Tables

Understanding Joins

Creating a Join

13 Creating Advanced Joins

Using Table Aliases

Using Different Join Types

Using Joins with Aggregate Functions

Using Joins and Join Conditions

14 Combining Queries

Understanding Combined Queries

Creating Combined Queries

15 Inserting Data

Understanding Data Insertion

Copying from One Table to Another

16 Updating and Deleting Data

Updating Data

Deleting Data

Guidelines for Updating and Deleting Data

17 Creating and Manipulating Tables

Creating Tables

Updating Tables

Deleting Tables

Renaming Tables

18 Using Views

Understanding Views

Creating Views

19 Working with Stored Procedures

Understanding Stored Procedures

Why to Use Stored Procedures

Executing Stored Procedures

Creating Stored Procedures

20 Managing Transaction Processing

Understanding Transaction Processing

Controlling Transactions

21 Using Cursors

Understanding Cursors

Working with Cursors

22 Understanding Advanced SQL Features

Understanding Constraints

Understanding Indexes

Understanding Triggers

Database Security

A Sample Table Scripts

Understanding the Sample Tables

Obtaining the Sample Tables

B Working in Popular Applications

Using Apache Open Office Base

Using Adobe ColdFusion

Using IBM DB2

Using MariaDB

Using Microsoft Access

Using Microsoft ASP

Using Microsoft ASP.NET

Using Microsoft Query

Using Microsoft SQL Server (including Microsoft SQL Server Express)

Using MySQL

Using Oracle

Using Oracle Express

Using PHP

Using PostgreSQL

Using SQLite

Configuring ODBC Data Sources

C SQL Statement Syntax

ALTER TABLE

COMMIT

CREATE INDEX

CREATE PROCEDURE

CREATE TABLE

CREATE VIEW

DELETE

DROP

INSERT

INSERT SELECT

ROLLBACK

SELECT

UPDATE

D Using SQL Datatypes

String Datatypes

Numeric Datatypes

Date and Time Datatypes

Binary Datatypes

E SQL Reserved Words

Read More Show Less

Introduction

SQL is the most widely used database language. Whether you are an application developer, database administrator, Web application designer, or Microsoft Office user, a good working knowledge of SQL is an important part of interacting with databases.

There are lots of SQL books out there. Some are actually very good. But they all have one thing in common: For most users they teach just too much information. Instead of teaching SQL itself, most books teach everything from database design and normalization to relational database theory and administrative concerns. Although those are all important topics, they are not of interest to most of us who just need to learn SQL.

That is where this book comes in. Sams Teach Yourself SQL in 10 Minutes will teach you SQL, starting with simple data retrieval and working on to more complex topics including the use of joins, subqueries, and table constraints. You'll learn what you need to know methodically, systematically, and simply-in lessons that will each take 10 minutes or less to complete.

So turn to Lesson 1, and get to work. You'll be writing world-class SQL in no time at all.

Who is the Teach Yourself SQL book for?

This book is for you if:

  • You are new to SQL.
  • You want to quickly learn how to get the most out of SQL.
  • You want to do things quickly and easily in SQL without having to call someone for help.

Conventions Used in This Book

This book uses different typefaces to differentiate between code and regular English, and also to help you identify important concepts.

Text that you type and text that should appear on your screen is presented in monospace type.

It willlook like this to mimic the way text looks on your screen.

Placeholders for variables and expressions appear in monospace italic font You should replace the placeholder with the specific value it represents.

This arrow at the beginning of a line of code means that a single line of code is too long to fit on the printed page. Continue typing all characters after the as though they were part of the preceding line.

New Term icons provide clear definitions of new, essential terms. The term appears in italic.

The Input icon identifies code that you can type in yourself. It usually appears next to a listing.

The Output icon highlights the output produced by running a program. It usually appears after a listing.

The Analysis icon alerts you to the author's line-by-line analysis of a program.

Read More Show Less

Customer Reviews

Average Rating 3.5
( 15 )
Rating Distribution

5 Star

(6)

4 Star

(4)

3 Star

(2)

2 Star

(1)

1 Star

(2)

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 15 Customer Reviews
  • Posted July 25, 2009

    Good Reference for Beginners

    I found this book to be a reference for beginners when utilizing SQL. It's good to have by the desk side to use as a quick reference tool and is organized in a logical format

    1 out of 1 people found this review helpful.

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

    Posted September 15, 2008

    I used this to prep for a job interview

    This is a great introduction to SQL. It starts slow and gives you the essential details to do a practical 'work unit.' To use this book as intended, it is helpful if you have some programming background and/or even just a little exposure to databases.

    1 out of 1 people found this review helpful.

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

    Posted July 8, 2013

    Good book for beginners. For anyone looking specifically to lear

    Good book for beginners. For anyone looking specifically to learn proprietary syntax, look to those books. I've read a lot of reviews about how this book isn't good to learn SQL server, but this book isn't about SQL server; it's about basic SQL fundamentals. There are free tutorials out on the web with interactive learning that outdoes this book. However, it's still a good touch and feel reference tool for those who prefer a hard copy.

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

    Posted February 17, 2002

    Just the facts

    Great for beginners who just want to get started with what they need.

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

    Posted May 2, 2002

    An insult to even say 10 Minutes

    Sure, the book is good, but let's not downplay the importance of understanding the full spectrum of SQL Server. Enormous catostraphic damage can occur from giving people the false sense of security that they can learn SQL in 10 minutes.

    0 out of 2 people found this review helpful.

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

    Posted May 9, 2002

    Good Quick Reference

    This book is more of a quick reference on basic SQL. As a web application developer who doesn't use SQL query on a daily basis. This book is helpful on reminding me some SQL syntax that I know but cannot recall right away from my head.

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

    Posted July 22, 2001

    WOW!

    I was very impressed having never worked with SQL before. I was writing queries within the first few pages. Being a light VB programmer, adapting was easy as pie. Highly recommended if you will be writing a front end in any programming language, or if you just want to interact with SQL from Word or Excel. Very well written

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

    Posted March 4, 2001

    The BIG little book about SQL !!

    This book is simply amazing as the other books by Ben Forta. Very few typos. Very concise. Anyone serious about SQL should read this book.

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

    Posted September 14, 2000

    An excellent primer

    An excellent primer. Read it in one nite. You can start turning out good queries, immediately.

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

    Posted September 13, 2009

    No text was provided for this review.

  • Anonymous

    Posted July 5, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 16, 2010

    No text was provided for this review.

  • Anonymous

    Posted September 18, 2010

    No text was provided for this review.

  • Anonymous

    Posted July 14, 2011

    No text was provided for this review.

  • Anonymous

    Posted September 18, 2011

    No text was provided for this review.

Sort by: Showing all of 15 Customer Reviews

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