Sams Teach Yourself SQL in 10 Minutes
Ben Forta(Author)
Sams Publishing
2nd Edition
Published on 11. May 2001
Book
Paperback/Softback
272 pages
978-0-672-32128-3 (ISBN)
Article exhausted; check for reprint
Description
Sams Teach Yourself SQL in 10 Minutes, 2E is a tutorial-based book, organized into a series of easy-to-follow, 10-minute lessons. These well targeted lessons teach you in 10 minutes what some books take several hours or days to teach. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.
The reader of this book will learn how to:
Retrieve and sort data
Filter data using comparisons and wildcards
Use the aggregate functions to analyze data
Perform insert, update, and delete operations
Join relational tables using inner, outer, and self joins
Combine queries using unions
Use views
Create and use stored procedures, triggers, and other advanced database features
The reader of this book will learn how to:
Retrieve and sort data
Filter data using comparisons and wildcards
Use the aggregate functions to analyze data
Perform insert, update, and delete operations
Join relational tables using inner, outer, and self joins
Combine queries using unions
Use views
Create and use stored procedures, triggers, and other advanced database features
More details
Edition
2nd edition
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 210 mm
Width: 139 mm
Thickness: 16 mm
Weight
308 gr
ISBN-13
978-0-672-32128-3 (9780672321283)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

Book
08/2020
5th Edition
Addison Wesley
€35.99
Available immediately

Ben Forta
Sams Teach Yourself SQL in 10 Minutes
Book
04/2004
3rd Edition
Sams Publishing
€13.61
Article exhausted; check for reprint
Previous edition

Ben Forta
Sams Teach Yourself SQL in 10 Minutes
Book
09/1999
Sams Publishing
€13.61
Article exhausted; check for reprint
Person
Ben Forta is Allaire Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and it's sequel Advanced ColdFusion 4 Application Development, as well as books on JSP (JavaServer Pages), WAP, and other technologies.
Content
1. Understanding SQL.
2. Retrieving Data.
3. Sorting Retrieved Data.
4. Filtering Data.
5. Advanced Data Filtering.
6. Using Wildcard Filtering.
7. Calculated Fields.
8. Data Manipulation Functions.
9. Summarizing Data.
10. Grouping Data.
11. Subqueries.
12. Joining Tables.
13. Advanced Joins.
14. Combining Queries.
15. Inserting Data.
16. Data.
17. Tables.
18. Using Views.
19. Transaction Processing.
20. Advanced SQL Features.
A: Sample Table Scripts.
B: Popular Applications.
C: SQL Statement Syntax.
D: SQL Datatypes.
2. Retrieving Data.
3. Sorting Retrieved Data.
4. Filtering Data.
5. Advanced Data Filtering.
6. Using Wildcard Filtering.
7. Calculated Fields.
8. Data Manipulation Functions.
9. Summarizing Data.
10. Grouping Data.
11. Subqueries.
12. Joining Tables.
13. Advanced Joins.
14. Combining Queries.
15. Inserting Data.
16. Data.
17. Tables.
18. Using Views.
19. Transaction Processing.
20. Advanced SQL Features.
A: Sample Table Scripts.
B: Popular Applications.
C: SQL Statement Syntax.
D: SQL Datatypes.