Book 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
Table of contents
- Copyright
- About the Author
- Acknowledgments
- Tell Us What You Think!
- Introduction
- Understanding SQL
- Retrieving Data
- Sorting Retrieved Data
- Filtering Data
- Advanced Data Filtering
- Using Wildcard Filtering
- Creating Calculated Fields
- Using Data Manipulation Functions
- Summarizing Data
- Grouping Data
- Working with Subqueries
- Joining Tables
- Creating Advanced Joins
- Combining Queries
- Inserting Data
- Updating and Deleting Data
- Creating and Manipulating Tables
- Using Views
- Working with Stored Procedures
- Managing Transaction Processing
- Using Cursors
- Understanding Advanced SQL Features
- Sample Table Scripts
-
Working in Popular Applications
- Configuring ODBC Data Sources
- Using Allaire ColdFusion
- Using Allaire JRun 3.x
- Using DB2
- Using Informix Dynamic Server 7.x
- Using Microsoft Access
- Using Microsoft ASP
- Using Microsoft Query
- Using Microsoft SQL Server 6.x
- Using Microsoft SQL Server 7
- Using Microsoft SQL Server 2000
- Using Microsoft Visual Basic
- Using Microsoft Visual C++
- Using Oracle 8
- Using Query Tool
- Using Sybase
- SQL Statement Syntax
- Using SQL Datatypes
- SQL Reserved Words
- Index
Product information
- Title: Sams Teach Yourself SQL in 10 Minutes, Second Edition
- Author(s):
- Release date: April 2001
- Publisher(s): Que
- ISBN: 9780672321283
You might also like
book
Sams Teach Yourself SQL in 10 Minutes
Sams Teach Yourself SQL in 10 Minutes is a tutorial-based book, organized into a series of …
book
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see …
book
Sams Teach Yourself Beginning Programming in 24 Hours, 4th Edition
explains the basics of programming in the successful 24 Hours format. The book's examples are easily …
book
Practical SQL Handbook, The: Using SQL Variants, Fourth Edition
This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals …