Sams Teach Yourself SQL in 10 Minutes

by Forta, Ben

• ISBN13: 9780672316647
• ISBN10: 0672316641
• Format: Paperback
• Copyright: 1999-08-01
• Publisher: Sams

Summary

In easy, 10-minute lessons, beginners can learn how to retrieve and store data, combine queries, create triggers and more in SQL. Perfect for those who can't sift through heavy manuals, light chapters bright insight on the basics of this popular program.

Table of Contents

Introduction	xi
Understanding SQL	1	(7)
Database Basics	1	(4)
What Is SQL?	5	(2)
Summary	7	(1)
Retrieving Data	8	(6)
The SELECT Statement	8	(1)
Retrieving Individual Columns	9	(2)
Retrieving Multiple Columns	11	(1)
Retrieving All Columns	12	(1)
Summary	13	(1)
Sorting Retrieved Data	14	(6)
Sorting Data	14	(2)
Sorting by Multiple Columns	16	(1)
Sorting by Column Position	17	(1)
Specifying Sort Direction	18	(1)
Summary	19	(1)
Filtering Data	20	(6)
Using the WHERE Clause	20	(1)
The WHERE Clause Operators	21	(4)
Summary	25	(1)
Advanced Data Filtering	26	(7)
Combining WHERE Clauses	26	(4)
Using the In Operator	30	(1)
Using the Not Operator	31	(1)
Summary	32	(1)
Using Wildcard Filtering	33	(5)
Using the LIKE Operator	33	(4)
Tips for Using Wildcards	37	(1)
Summary	37	(1)
Creating Calculated Fields	38	(9)
Understanding Calculated Fields	38	(1)
Concatenating Fields	39	(6)
Performing Mathematical Calculations	45	(1)
Summary	46	(1)
Using Data Manipulation Functions	47	(9)
Understanding Functions	47	(2)
Using Functions	49	(6)
Summary	55	(1)
Summarizing Data	56	(9)
Using Aggregate Functions	56	(6)
Aggregates on Distinct Values	62	(1)
Combining Aggregate Functions	63	(1)
Summary	64	(1)
Grouping Data	65	(8)
Understanding Data Grouping	65	(1)
Creating Groups	66	(2)
Filtering Groups	68	(1)
Grouping and Sorting	69	(2)
SELECT Clause Ordering	71	(1)
Summary	72	(1)
Working with Subqueries	73	(7)
Understanding Subqueries	73	(1)
Filtering by Subquery	73	(4)
Using Subqueries as Calculated Fields	77	(2)
Summary	79	(1)
Joining Tables	80	(10)
Understanding Joins	80	(3)
Creating a Join	83	(6)
Summary	89	(1)
Creating Advanced Joins	90	(11)
Using Table Aliases	90	(2)
Join Types	92	(6)
Using Joins with Aggregate Functions	98	(1)
Using Joins and Join Conditions	99	(1)
Summary	100	(1)
Combining Queries	101	(7)
Understanding Combined Queries	101	(1)
Creating Combined Queries	102	(5)
Summary	107	(1)
Inserting Data	108	(8)
Understanding Data Insertion	108	(6)
Copying from One Table to Another	114	(1)
Summary	115	(1)
Updating and Deleting Data	116	(6)
Updating Data	116	(2)
Deleting Data	118	(2)
Guidelines for Updating and Deleting Data	120	(1)
Summary	121	(1)
Creating and Manipulating Tables	122	(9)
Creating Tables	122	(6)
Updating Tables	128	(2)
Deleting Tables	130	(1)
Renaming Tables	130	(1)
Summary	130	(1)
Using Views	131	(10)
Understanding Views	131	(3)
Creating Views	134	(6)
Summary	140	(1)
Using Transaction Processing	141	(7)
Understanding Transaction Processing	141	(2)
Controlling Transactions	143	(4)
Summary	147	(1)
Understanding Advanced SQL Features	148	(12)
Understanding Constraints	148	(6)
Understanding Indexes	154	(2)
Understanding Stored Procedures	156	(1)
Understanding Triggers	157	(2)
Summary	159	(1)
A Sample Table Scripts	160	(18)
Sample Tables Overview	160	(4)
Creating the Sample Tables	164	(4)
Populating the Sample Tables	168	(10)
B Working in Popular Applications	178	(10)
Configuring ODBC Data Sources	178	(1)
Using Allaire ColdFusion	179	(1)
Using DB2	180	(1)
Using Informix Dynamic Server 7.x	181	(1)
Using Microsoft Access	181	(1)
Using Microsoft ASP	182	(1)
Using Microsoft Query	183	(1)
Using Microsoft SQL Server 6.x	184	(1)
Using Microsoft SQL Server 7	184	(1)
Using Microsoft Visual Basic	185	(1)
Using Microsoft Visual C++	186	(1)
Using Oracle 8	186	(1)
Using Sybase	187	(1)
C SQL Statement Syntax	188	(4)
Alter Table	188	(1)
Commit	189	(1)
Create Index	189	(1)
Create Table	189	(1)
Create View	189	(1)
Delete	190	(1)
Drop	190	(1)
Insert	190	(1)
Insert Select	190	(1)
Rollback	190	(1)
Select	191	(1)
Update	191	(1)
D SQL Datatypes	192	(6)
String Datatypes	193	(2)
Numeric Datatypes	195	(1)
Date and Time Datatypes	196	(1)
Binary Datatypes	197	(1)
E SQL Reserved Words	198	(7)
Index	205