Register your product to gain access to bonus material or receive a coupon.
Sams Teach Yourself SQL in 10 Minutes
eBook (Adobe DRM)
- Sorry, this book is no longer in print.
- About Adobe DRM eBooks
- Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
- Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
This eBook requires the free Adobe® Digital Editions software.
Before downloading this DRM-encrypted PDF, be sure to:
Description
- Copyright 2003
- Edition: 1st
- eBook (Adobe DRM)
- ISBN-10: 0-7686-5759-8
- ISBN-13: 978-0-7686-5759-3
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
Sample Content
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. 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.