October 2012
Beginner
288 pages
4h 37m
English
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.