Sams Teach Yourself SQL™ in 10 Minutes

✍ Scribed by Forta, Ben

• Publisher: Sams
• Year: 2004
• Tongue: English
• Leaves: 257
• Series: Sams teach yourself
• Edition: 3rd ed
• Category: Library

✦ Synopsis

Offering a tutorial to the themes and techniques involved in applying the SQL language, this book includes coverage of versions of major commercial SQL platforms. It also covers MySQL, and PostgreSQL. It contains examples which have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.

✦ Table of Contents

Cover......Page 1
Contents......Page 4
Introduction......Page 12
Database Basics......Page 16
What Is SQL?......Page 22
Summary......Page 23
The SELECT Statement......Page 24
Retrieving Individual Columns......Page 25
Retrieving Multiple Columns......Page 27
Retrieving All Columns......Page 28
Summary......Page 29
Sorting Data......Page 30
Sorting by Multiple Columns......Page 32
Sorting by Column Position......Page 33
Specifying Sort Direction......Page 34
Summary......Page 36
Using the WHERE Clause......Page 37
The WHERE Clause Operators......Page 39
Summary......Page 43
Combining WHERE Clauses......Page 44
Using the IN Operator......Page 47
Using the NOT Operator......Page 49
Summary......Page 50
Using the LIKE Operator......Page 51
Tips for Using Wildcards......Page 57
Summary......Page 58
Understanding Calculated Fields......Page 59
Concatenating Fields......Page 60
Performing Mathematical Calculations......Page 66
Summary......Page 67
Understanding Functions......Page 68
Using Functions......Page 70
Summary......Page 76
Using Aggregate Functions......Page 77
Aggregates on Distinct Values......Page 83
Combining Aggregate Functions......Page 84
Summary......Page 85
Understanding Data Grouping......Page 86
Creating Groups......Page 87
Filtering Groups......Page 89
Grouping and Sorting......Page 91
Summary......Page 94
Filtering by Subquery......Page 95
Using Subqueries As Calculated Fields......Page 99
Summary......Page 101
Understanding Joins......Page 102
Creating a Join......Page 105
Summary......Page 111
Using Table Aliases......Page 112
Using Different Join Types......Page 113
Using Joins with Aggregate Functions......Page 119
Summary......Page 121
Understanding Combined Queries......Page 122
Creating Combined Queries......Page 123
Summary......Page 128
Understanding Data Insertion......Page 129
Copying from One Table to Another......Page 135
Summary......Page 137
Updating Data......Page 138
Deleting Data......Page 140
Guidelines for Updating and Deleting Data......Page 142
Summary......Page 143
Creating Tables......Page 144
Updating Tables......Page 150
Renaming Tables......Page 152
Summary......Page 153
Understanding Views......Page 154
Creating Views......Page 157
Summary......Page 163
Understanding Stored Procedures......Page 164
Why to Use Stored Procedures......Page 165
Executing Stored Procedures......Page 167
Creating Stored Procedures......Page 168
Summary......Page 171
Understanding Transaction Processing......Page 172
Controlling Transactions......Page 175
Summary......Page 178
Understanding Cursors......Page 179
Working with Cursors......Page 181
Summary......Page 184
Understanding Constraints......Page 185
Understanding Indexes......Page 191
Understanding Triggers......Page 194
Database Security......Page 196
Summary......Page 197
Understanding the Sample Tables......Page 198
Obtaining the Sample Tables......Page 202
B: Working in Popular Applications......Page 205
Using DB2......Page 206
Using Macromedia ColdFusion......Page 207
Using Microsoft Access......Page 208
Using Microsoft ASP.NET......Page 210
Using Microsoft Query......Page 211
Using Microsoft SQL Server......Page 212
Using Oracle......Page 213
Using Query Tool......Page 214
Using Sybase......Page 215
Configuring ODBC Data Sources......Page 216
ALTER TABLE......Page 218
CREATE TABLE......Page 219
INSERT......Page 220
SELECT......Page 221
UPDATE......Page 222
D: Using SQL Datatypes......Page 223
String Datatypes......Page 224
Numeric Datatypes......Page 226
Date and Time Datatypes......Page 227
Binary Datatypes......Page 228
E: SQL Reserved Words......Page 230
A......Page 236
C......Page 237
D......Page 239
F......Page 241
G......Page 242
J-K......Page 243
N......Page 244
O......Page 245
Q......Page 246
R......Page 247
S......Page 248
T......Page 251
U......Page 252
W-X-Y-Z......Page 253

✦ Subjects

Computer Science;Programming;Nonfiction;Reference;Computers;Science;Technology;Technical;Business;Textbooks;Software