+612 9045 4394
 
CHECKOUT
SQL : A Beginner's Guide - Forrest Houlette

SQL

A Beginner's Guide

Paperback

Published: 20th December 2000
Ships: 7 to 10 business days
7 to 10 business days
RRP $74.00
$59.35
20%
OFF

This work approaches teaching Structured Query Language the way most people learn it - by focusing on critical tasks first. Structured pedagogy enhances the learning experience: modules, goals, projects, mastery checks, one-minute drills enhance the learning experience. All coding is based on real-world scenarios. No hypothetical SQL statements. Projects include pre-built databases including: product tracking database, order entry for small business, patient tracking for medical facility and more. The book also includes quick-look up appendix of the most critical SQL commands and techniques, sample SQL code for both Access and SQL Server 2000, and syntax and information on the emerging new standard to SQL -SQL 3.

Acknowledgmentsp. xvii
Introductionp. xix
Learning the Essentials
Accessing the Databasep. 3
Connecting to the Databasep. 5
Using a Query Toolp. 8
Using ODBCp. 10
Using OLE DBp. 19
Connecting from a Programp. 21
Using a Connection Libraryp. 22
Using DAOp. 28
Using ADOp. 30
Create a Connectionp. 32
Mastery Checkp. 33
Retrieving Datap. 35
Using Selectp. 37
Adding a Where Clausep. 44
Adding Order Byp. 49
Adding Summariesp. 50
Adding a Having Clausep. 54
Joining Tablesp. 56
Combining Fields and Creating Columnsp. 62
Presenting Datap. 64
Mastery Checkp. 67
Inserting Datap. 69
Using Insertp. 70
Using Select with Insertp. 81
Adding a Where Clausep. 83
Adding a Having Clausep. 84
Using Select Intop. 85
Data Entryp. 87
Mastery Checkp. 92
Updating Datap. 93
Using Updatep. 94
Data Validationp. 95
Adding a Where Clausep. 98
Adding a Having Clausep. 101
Using Multiple Tablesp. 104
Update Datap. 107
Mastery Checkp. 113
Deleting Datap. 115
Deleting Datap. 116
Adding a Where Clausep. 117
Using a Query to Control Deletionp. 119
Using Transactionsp. 120
Data Deletionp. 124
Mastery Checkp. 126
Creating Tablesp. 129
Using Create Tablep. 130
Planning Keys, Primary and Foreignp. 135
Normalizing Datap. 137
Adding Indexesp. 141
Adding Constraintsp. 143
Altering Tablesp. 147
Deleting Tablesp. 148
Fix the Recordset Handling Bugsp. 149
Mastery Checkp. 151
Creating Databasesp. 153
Using Create Databasep. 154
Planning Tablesp. 157
Normalizing Tablesp. 159
Create the Portfolio Databasep. 166
Planning Securityp. 170
Fix Bugsp. 173
Mastery Checkp. 175
Building Skills
Using Operatorsp. 179
Using Relational and Boolean Operatorsp. 180
Finding What Existsp. 183
Finding Something in a Setp. 184
Finding Items In Betweenp. 185
Finding In, Any, All, or Somep. 185
Using Like and Is Nullp. 187
Build an Administrative Toolp. 190
Mastery Checkp. 194
Using Functionsp. 197
Aggregating Datap. 198
AVGp. 198
COUNTp. 199
MAXp. 199
MINp. 200
SUMp. 200
STDEVp. 201
STDEVPp. 202
VARp. 202
VARPp. 203
Fix the Bugp. 204
Handling Dates and Timesp. 204
DATEADDp. 205
DATEDIFFp. 205
DATENAMEp. 206
DATEPARTp. 206
DAYp. 207
GETDATEp. 207
MONTHp. 208
YEARp. 208
Test Functionsp. 209
Using Math Functionsp. 210
ABSp. 210
ACOSp. 210
ASINp. 211
ATANp. 211
ATN2p. 212
CEILINGp. 212
COSp. 212
COTp. 213
DEGREESp. 213
EXPp. 214
FLOORp. 214
LOGp. 215
LOG10p. 215
PIp. 216
POWERp. 216
RADIANSp. 216
RANDp. 217
ROUNDp. 217
SIGNp. 218
SINp. 218
SQUAREp. 219
SQRTp. 219
TANp. 220
Using String Functionsp. 221
ASCIIp. 221
CHARp. 221
CHARINDEXp. 222
DIFFERENCEp. 222
LEFTp. 223
LENp. 223
LOWERp. 224
LTRIMp. 224
NCHARp. 225
PATINDEXp. 225
QUOTENAMEp. 226
REPLACEp. 226
REPLICATEp. 227
REVERSEp. 227
RIGHTp. 228
RTRIMp. 228
SOUNDEXp. 229
SPACEp. 229
STRp. 230
STUFFp. 230
SUBSTRp. 231
UNICODEp. 231
UPPERp. 232
Using Critical System Functionsp. 233
CASEp. 233
CASTp. 234
CONVERTp. 234
ISDATEp. 235
ISNULLp. 236
ISNUMBERICp. 236
Enter Your Own Database Connectionsp. 238
Mastery Checkp. 241
Building Subqueriesp. 243
Selecting an Itemp. 246
Setting a Conditionp. 247
Substituting for Joinsp. 249
Deleting, Updating, and Insertingp. 251
Delete Recordsp. 254
Mastery Checkp. 257
Building Viewsp. 259
Rationalizing the Use of Viewsp. 261
Create the Queryp. 263
Create the Viewp. 265
Create a Viewp. 266
Add Formsp. 268
Mastery Checkp. 284
Building Stored Proceduresp. 285
Editing the Procedurep. 288
Using Create Procedurep. 290
Convert Queriesp. 293
Calling the Procedurep. 294
Using the Resultsp. 295
Convert Queries to Stored Proceduresp. 296
Mastery Checkp. 297
Programming in Stored Proceduresp. 299
Using Variablesp. 301
Using Flow Controlp. 303
Returning Valuesp. 308
Raising Errorsp. 310
Assemble the Stored Procedurep. 313
Mastery Checkp. 314
Using Parametersp. 315
Creating Parametersp. 319
Passing Valuesp. 321
Add Parametersp. 323
Using the Resultsp. 323
Mastery Checkp. 327
Using Cursorsp. 329
Declaring Cursorsp. 331
Manipulating Cursorsp. 333
Updating and Searching Cursorsp. 336
Closing and Deallocating Cursorsp. 339
Assemble a Stored Procedurep. 339
Mastery Checkp. 342
Building Unionsp. 343
Using the Union Operatorp. 345
Adhering to Union Constraintsp. 346
Building Practical Unionsp. 348
Build a Unionp. 350
Mastery Checkp. 353
Winding Down the Portfolio Projectp. 355
The Client's Structurep. 357
The Registration Processp. 363
Write the Lookupsp. 364
Planning Required Insert Proceduresp. 365
Write the INSERTSp. 366
Planning Required Unregister Proceduresp. 368
Write the Unregister Proceduresp. 369
Planning Required Checkout Proceduresp. 370
Write the Checkout Procedurep. 371
Planning Required Check-In Proceduresp. 371
Write the Check-In Procedurep. 371
Planning Required Delete Proceduresp. 372
Write the Delete Procedurep. 373
A Client Architecturep. 373
Mastery Checkp. 377
Answers to Mastery Checksp. 379
Accessing the Databasep. 380
Retrieving Datap. 380
Inserting Datap. 381
Updating Datap. 383
Deleting Datap. 384
Creating Tablesp. 385
Creating Databasesp. 386
Using Operatorsp. 387
Using Functionsp. 388
Building Subqueriesp. 389
Building Viewsp. 390
Building Stored Proceduresp. 391
Programming in Stored Proceduresp. 393
Using Parametersp. 394
Using Cursorsp. 395
Building Unionsp. 396
Winding Down the Portfolio Projectp. 397
A Little SQL Theoryp. 399
Declarative, Not Proceduralp. 400
A Relational Modelp. 401
The Structure of the Languagep. 403
Data Definition Languagep. 403
Data Manipulation Languagep. 404
Data Control Languagep. 404
Dependence on Transactionsp. 405
Focus on Integrityp. 406
Conclusionp. 407
Indexp. 433
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9780072130966
ISBN-10: 0072130962
Series: Beginner's Guide
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 452
Published: 20th December 2000
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.5 x 19.0  x 2.3
Weight (kg): 0.77
Edition Type: Annotated