Enjoy fast, free delivery, exclusive deals, and award-winning movies & TV shows with Prime
Try Prime
and start saving today with fast, free delivery
Amazon Prime includes:
Fast, FREE Delivery is available to Prime members. To join, select "Try Amazon Prime and start saving today with Fast, FREE Delivery" below the Add to Cart button.
Amazon Prime members enjoy:- Cardmembers earn 5% Back at Amazon.com with a Prime Credit Card.
- Unlimited Free Two-Day Delivery
- Streaming of thousands of movies and TV shows with limited ads on Prime Video.
- A Kindle book to borrow for free each month - with no due dates
- Listen to over 2 million songs and hundreds of playlists
- Unlimited photo storage with anywhere access
Important: Your credit card will NOT be charged when you start your free trial or if you cancel during the trial period. If you're happy with Amazon Prime, do nothing. At the end of the free trial, your membership will automatically upgrade to a monthly membership.
-53% $13.99$13.99
Ships from: Amazon Sold by: Moonlight Book Kingdom
$11.98$11.98
Ships from: Amazon Sold by: JYPA Enterprises LLC
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.
OK
SQL in 10 Minutes, Sams Teach Yourself 4th Edition
There is a newer edition of this item:
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
1 Understanding SQL
2 Retrieving 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
- ISBN-100672336073
- ISBN-13978-0672336072
- Edition4th
- PublisherSams Publishing
- Publication dateOctober 25, 2012
- LanguageEnglish
- Dimensions5.4 x 0.8 x 8.2 inches
- Print length288 pages
Frequently bought together
Similar items that may deliver to you quickly
Editorial Reviews
From the Back Cover
About the Author
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
- Best Sellers Rank: #119,986 in Books (See Top 100 in Books)
- #19 in SQL
- #25 in Computer Programming Languages
- #2,173 in Unknown
- Customer Reviews:
About the author
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
Customer Reviews, including Product Star Ratings help customers to learn more about the product and decide whether it is the right product for them.
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzed reviews to verify trustworthiness.
Learn more how customers reviews work on Amazon-
Top reviews
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
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.
- 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. :-)
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.
Highly recommended.
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.
Top reviews from other countries
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!
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.