Buy new:
-45% $16.47
FREE delivery Monday, May 20 on orders shipped by Amazon over $35
Ships from: Amazon
Sold by: Moonlight Book Kingdom
$16.47 with 45 percent savings
List Price: $29.99

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Monday, May 20 on orders shipped by Amazon over $35
Only 1 left in stock - order soon.
$$16.47 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$16.47
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Ships from
Amazon
Returns
30-day easy returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$6.90
Get Fast, Free Shipping with Amazon Prime FREE Returns
Shows signs of wear. Jacket may be torn, cover may have creases, pages have some writing and highlighting. May have some water damage. May be a former library book. Ships direct from Amazon! Shows signs of wear. Jacket may be torn, cover may have creases, pages have some writing and highlighting. May have some water damage. May be a former library book. Ships direct from Amazon! See less
FREE delivery Thursday, May 16 on orders shipped by Amazon over $35. Order within 3 hrs 57 mins
Only 1 left in stock - order soon.
$$16.47 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$16.47
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Ben Forta
+ Follow
More books from this author
Something went wrong. Please try your request again later.

SQL in 10 Minutes, Sams Teach Yourself 4th Edition

by Ben Forta (Author)
4.6 4.6 out of 5 stars 1,110 ratings
See all formats and editions

There is a newer edition of this item:

SQL in 10 Minutes a Day, Sams Teach Yourself
SQL in 10 Minutes a Day, Sams Teach Yourself
$24.99
(515)
In Stock
{"desktop_buybox_group_1":[{"displayPrice":"$16.47","priceAmount":16.47,"currencySymbol":"$","integerValue":"16","decimalSeparator":".","fractionalValue":"47","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"3%2FZW%2B%2FfuqAoABjstqyx3K8Xth7D9%2FLJLw8pi71rqoyT%2BrHdgYt5zxHGLwkIm9uC2rfhUeySrqLLFngdSriygaWgXmIpAiTSbij8D2EEZ4m%2FhUOx%2BoUHvNVeod2jLh3tGka9haiaqfMkuObNt3zTS4sYlYmTpl81dQh%2Bci1PqbAw8FUqlf%2Bj2tkil50cjJE3O","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$6.90","priceAmount":6.90,"currencySymbol":"$","integerValue":"6","decimalSeparator":".","fractionalValue":"90","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"3%2FZW%2B%2FfuqAoABjstqyx3K8Xth7D9%2FLJLMljQ%2BCUNMid9sEox1tnonaMHz8bQkr5t3SFm%2BSJa5YLdk8HWPV5ZIw%2BkYnP4PgJKj5486I47jDmvNkBgniBe9%2BISGiF0oUN7AsrDa70eGYFYiVHFkEykcfiS7pCuRSSptbETAKp7cvnEE8hcOl2%2Fjw%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

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

App
Read more Read less
Previous page
  1. ISBN-10
    0672336073
  2. ISBN-13
    978-0672336072
  3. Edition
    4th
  4. Publisher
    Sams Publishing
  5. Publication date
    October 25, 2012
  6. Part of series
    Sams Teach Yourself
  7. Language
    English
  8. Dimensions
    5.4 x 0.8 x 8.2 inches
  9. Print length
    288 pages
  10. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Frequently bought together

SQL in 10 Minutes, Sams Teach Yourself
$16.47
Get it as soon as Monday, May 20
Only 1 left in stock - order soon.
Sold by Moonlight Book Kingdom and ships from Amazon Fulfillment.
+
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Progra
$23.99
Get it as soon as Thursday, May 16
In Stock
Ships from and sold by Amazon.com.
+
Sql Guide (Quick Study: SQL)
$4.46
Get it as soon as Thursday, May 16
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Editorial Reviews

From the Back Cover

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

Product details

  • Publisher ‏ : ‎ Sams Publishing; 4th edition (October 25, 2012)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 288 pages
  • ISBN-10 ‏ : ‎ 0672336073
  • ISBN-13 ‏ : ‎ 978-0672336072
  • Item Weight ‏ : ‎ 13.4 ounces
  • Dimensions ‏ : ‎ 5.4 x 0.8 x 8.2 inches
  • Customer Reviews:
    4.6 4.6 out of 5 stars 1,110 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Ben Forta

Ben Forta

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Ben Forta is, first and foremost, an educator with over three decades of experience in and out of the classroom. Education is Ben’s passion. Between writing, lecturing, and in-classroom experience, he has dedicated his professional and personal lives to teaching, inspiring, mentoring, and sharing his love for technology and creativity. He is immensely grateful to have had the opportunity to share with millions worldwide. As Adobe’s Senior Director of Education Initiatives, he spends a considerable amount of time teaching, talking, and writing about creativity and digital literacy and the future of education, and provides feedback to help shape the future direction of Adobe products. And, in his spare time, Ben leads a high-school robotics program at a local Michigan high school.

Ben is the author of over 40 books, including the world’s best-selling title on SQL, as well as titles on topics as diverse as Adobe Spark in the classroom, Regular Expressions, mobile development, and Adobe ColdFusion. Over 900,000 copies of his books are in print in English, and titles have been translated into 16 additional languages. Many of these titles are used as textbooks in colleges and universities worldwide. Through his books and videos Ben has taught coding skills to over 1,000,000 people.

Ben has decades of experience in the tech space in product design and development, support, training, and marketing. Ben is also a successful entrepreneur with experience creating, building, and selling start-ups. He is a sought-after public speaker, a writer and blogger, and he presents on education and development topics worldwide.

Customer reviews

4.6 out of 5 stars
4.6 out of 5
1,110 global ratings

Top reviews from the United States

Mohan
5.0 out of 5 stars Delivers on its promises!
Reviewed in the United States on September 26, 2018
Verified Purchase
I just started my databases class in college and I was absolutely clueless about databases and I thought my professor would make that assumption. So, I got this book and its getting me up to speed real nice. The explanations and the code are clear and its easy to find anything you're looking for if you're stuck coding. It clarified concepts that I thought were hard but are actually straightforward. It might be odd, but one thing I really appreciate is the size of the book. It's not big and the pages don't spring back to close the book as much as the other large books out here.

One thing that I wish was also promised are exercises that follow a lesson. It's easy to just follow the book and write the code the author puts down. The mental exercise that I wish was there, though, is to ask us to write queries using only natural language and not specify the code. A little bit of practice helps ingrain the concepts and the understanding of the code.
2 people found this helpful
Helpful
 Report
Dustin Williams
5.0 out of 5 stars A book that actually makes learning SQL fun and easy... ;-)
Reviewed in the United States on September 21, 2016
Verified Purchase
This is a fantastic book for those who need to quickly learn how to use SQL! Here's what I like about it:
- Designed for absolute beginners!
- Well explained with lots of visual, hands-on examples to ensure that you solidly comprehend what is being taught.
- Each lesson is quick and to the point. Best of all, it's actually fun and interesting to read. (A lot of SQL books out there are drier than DUST!!)
- Shows how each feature is achieved on different "versions" of SQL, as needed.
- Data files are freely available for different SQL database versions with an easy-to-use install script.

Personally, I am very thankful that I found this book! A lot of SQL books are written by people who are clueless as to how to teach. This author knows exactly how to communicate to his audience in a way that makes it simply enjoyable. :-)
4 people found this helpful
Helpful
 Report
Sean C.
4.0 out of 5 stars Learn SQL in 10 minutes? I don't think so...
Reviewed in the United States on July 9, 2016
Verified Purchase
While the title is misleading, good reference tool for learning general SQL. The book doesn't focus on any particular Database Management Software but it gives examples of where the concepts may differ. I found the sections are broken up in a meaningful way. If you're taking a Database Course at school or learning on your own, this makes a great reference tool along with your course materials.

MY RATING SYSTEM:
I try to stick with the same criteria and system when reviewing products and here is how it breaks down…
FIVE STARS: Great Product, would feel completely confident in recommending to others and consider the product to be a great overall value with no obvious faults.
FOUR STARS: Still a very good product, I consider it to be overall a good satisfying purchase and can still recommend it in good faith but there is one small aspect about the product keeping it from a perfect score.
THREE STARS: A good product but not a great one, it operates and appears as advertised but more than one aspect of the item is undesirable. This is an item I would use but probably consider an alternative option.
TWO STARS: Product is definitely lacking in quality and or the way it operates. Would not recommend it to others and would seek and alternative elsewhere. It maybe just barely does what it is advertised to do but is probably not worth the money and there are many negative factors about it.
ONE STAR: No two ways about it, this is a bad product and I would not recommend anybody purchase it.
One person found this helpful
Helpful
 Report
D. Barry
5.0 out of 5 stars Best quick reference for mySQL I have found.
Reviewed in the United States on August 6, 2016
Verified Purchase
As an intermittent user of mySQL, I find that I need to research the solutions to issues with some of the queries I want to write. I have a selection of books to refer to, but for some reason this one seems to have the exact pieces of information I am looking for. It is not intended as a reference book, but the index is good, and the Teach Yourself format means that the examples are explained well enough to allow one to extrapolate from them to the code variation that one is looking for. My objective is not to become a fully qualified SQL user, but to use it as a tool for the limited applications that I have, and for this need this book is invaluable.
Highly recommended.
One person found this helpful
Helpful
 Report
Amazon Customer
5.0 out of 5 stars Saving The Day
Reviewed in the United States on October 29, 2015
Verified Purchase
You really can teach yourself with just 10 minutes a day. This small book has made my job easier and saved me tons of time by migrating from Access to SQL Server when retrieving large amounts data. It even saved the day during a month end when data was updated late on the Server. When the update was finished, I tapped directly into SQL Server and got the data I needed in just under 2 minutes. Normally I would have used Access to link to the tables and run the append queries to be able to process the data. It would have taken me at least 1 hour for the whole process in Access and management needed the financial reporting as soon as possible. Luckily, I had written the code with this book's help and just ran the query. I was able to deliver on time.
5 people found this helpful
Helpful
 Report
Karrie
5.0 out of 5 stars I wish I had ordered this book sooner
Reviewed in the United States on June 6, 2015
Verified Purchase
I am currently studying for the MCSA Server 2012 certification to help become a DBA. I've read all the lessons on w3school, I took several DB classes in college, and I ordered a text book for the first exam of the certification.

This is by far the best, most helpful book when it comes to learning SQL. There is no "fluff", so everything you read is straight to the point and valuable. I hate other books that go into great detail when I want to understand the basic information before I try to learn the more fine-tune details.

It is quick and easy to read. Tons of examples that show you what to do, what not to do, and different examples of the codes.

Highly recommended. I would give it 10 stars if I could.
2 people found this helpful
Helpful
 Report
G. Stark
4.0 out of 5 stars Just the right level
Reviewed in the United States on September 30, 2019
Verified Purchase
A fairly rapid go through of SQL, it's not a tutorial but it's also not a dry A-Z reference manual. It was perfect for someone like me who has seen SQL and thus it's not completely foreign to me but who never really sat down to learn it. Like the better books it doesn't merely show you the syntax with a perfunctory explanation, but rather it builds up an understandable example and adds complexity as you go along. In this why you can begin to understand why a certain SQL aspect is pertinent and when it makes sense to have it.
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Christian Camarillo Reyes
5.0 out of 5 stars Directo y al grano
Reviewed in Mexico on January 26, 2018
Verified Purchase
Muy buen libro, lo recomiendo para los niveles básico e intermedio, muy bien explicado todo con ejemplos para el lenguaje SQL.
Report
Anonym
1.0 out of 5 stars 1/5
Reviewed in Germany on August 26, 2019
Verified Purchase
The book is shortly written... and less functions included.
Report
Shuaib
5.0 out of 5 stars Very concise, yet comprehensive overview of SQL features
Reviewed in the United Kingdom on August 31, 2018
Verified Purchase
The topics/lessons are displayed really well.
It's easy to follow for beginners as he provides an introduction of the conventions and aims of learning SQL.
The author also lays out the types of Database systems used alongside the lessons and their applicability like Microsoft Access, PostgreSQL, SQLite - which helps those target the systems they wish to learn immediately as there may be slight differences in the convention or features. In any case, he notes which ones work/not for the corresponding tutorials.

I used this alongside my MOOC to learn SQL for data analysis, and this covered the fundamentals really well to gain confidence in writing code/statements to answer queries by viewing the syntax to answer these queries by understanding data structures.
Afterwards, you could move onto filtering data and then gain the skill to handle more advanced features like using aggregations, JOINs and subqueries to gain the real value of SQL (especially PostgreSQL/SQLite)

However if you're more advanced in querying - this might not be useful since features like CTE (WITH statements) and WINDOW functions (which carry out aggregations/statements concisely) aren't covered and are helpful for brevity and learning even advanced tools.

Still, this book is valuable as a reference as I try to revise/refine my skills already covered every so often. Highly recommended nonetheless!
One person found this helpful
 Report
Amazon Customer
5.0 out of 5 stars Good books on Amazon
Reviewed in India on October 11, 2017
Verified Purchase
excellent
One person found this helpful
 Report
Dr. Tim Parker
5.0 out of 5 stars Not just a great teaching tool, but a solid reference book as well. Well written.
Reviewed in Canada on July 18, 2015
Verified Purchase
This is a relatively small book, but well written and well laid out. I've been working with SQL for decades, but with other tasks getting in my professional life's way I often don't code for months or years on end. When I do have to code, a quick skim through this book helps me get back up to speed. It also serves as a solid reference to commands and optional components.

While many will see this as a beginner's book (and it will work fine teaching SQL), I prefer to think of it as a solid reference since I can quickly find anything I want. This is one book I keep handy, all the time, just in case. Very well done by Ben Forta, and recommended unequivocally. I find I turn to this book more than any other SQL book on my shelves.
2 people found this helpful
 Report