9781598632125

SQL Power! The Comprehensive Guide

by
  • ISBN13:

    9781598632125

  • ISBN10:

    1598632124

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2006-06-16
  • Publisher: Cengage Learning PTR

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $34.99 Save up to $30.00
  • Rent Book $4.99
    Add to Cart Free Shipping

    TERM
    PRICE
    DUE
    IN STOCK USUALLY SHIPS IN 24 HOURS.
    HURRY! ONLY 2 COPIES IN STOCK AT THIS PRICE

Supplemental Materials

What is included with this book?

  • The Used and Rental copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

If you're an aspiring database administrator, you need to learn SQL quickly to advance in your career. SQLPower! The Comprehensive Guide provides just the data you need to go from novice to master by immersingyou in real-life database design, implementation, and administration situations. The book is equally useful forthose already experienced with databases and SQL who want to increase their knowledge without having tosift through a tome. Beginning with an overview of SQL and the concept of relational databases, the book goes on to cover all the major topics, including tables, primary keys, relationships, foreign keys, MySQL, and database software, as well as the data definition, data manipulation, and data control languages. Later chapters cover higher-level topics such as advanced queries, virtual tables, normalization, and embedded SQL. The book's examples build upon one another, with end-ofchapter exercises that test your knowledge as you go. All of the source code used in the book is available for download at www.courseptr.com/downloads.

Table of Contents

SQL: The Languagep. 1
A Bit of Historyp. 1
SQL Definedp. 2
SQL-environmentsp. 2
SQL-agentsp. 3
SQL-implementationsp. 3
SQL-clientsp. 3
SQL-serversp. 3
SQL-client modulesp. 3
User Identifiersp. 4
Catalogsp. 4
SQL-schemasp. 4
Information Schemap. 4
Definition Schemap. 4
SQL-datap. 4
Tablesp. 4
SQL as a Languagep. 5
SQL Standardsp. 6
SQL92p. 6
SQL99p. 8
SQL2003p. 10
Speculating on the Future of SQLp. 11
Database Technologyp. 11
The SQL Languagep. 12
SQL Standardsp. 13
Database Vendorsp. 13
Open Sourcep. 14
Summaryp. 14
Chapter Reviewp. 15
Multiple Choicep. 15
Conceptsp. 17
Relational Databasesp. 19
The Relational Data Modelp. 20
Tablesp. 22
Primary Keysp. 25
Indexesp. 26
Summaryp. 31
Chapter Reviewp. 31
Multiple Choicep. 31
Conceptsp. 33
Database Softwarep. 35
Salesp. 35
ACID Compliancep. 36
Database Softwarep. 38
Microsoft SQL Serverp. 40
Microsoft Accessp. 41
Oraclep. 43
Informixp. 44
Sybasep. 45
DB2p. 46
MySQLp. 47
PostgreSQLp. 49
SQLitep. 51
Teradatap. 53
Other RDBMSsp. 54
Summaryp. 55
Chapter Reviewp. 56
Multiple Choicep. 56
Conceptsp. 58
Data Definition Languagep. 59
Preparingp. 60
CREATEp. 61
CREATE DATABASEp. 61
CREATE TABLEp. 63
CREATE TABLE ASp. 67
CREATE INDEXp. 68
DROPp. 70
DROP DATABASEp. 70
DROP TABLEp. 71
DROP INDEXp. 72
ALTERp. 74
ALTER DATABASEp. 74
ALTER TABLEp. 74
RENAME TABLEp. 79
Summaryp. 79
Chapter Reviewp. 80
Multiple Choicep. 80
MySQLp. 83
MySQL ABp. 83
The MySQL Database Management Systemp. 85
Tablesp. 86
Permanent Tablesp. 86
Virtual Tables (Views)p. 87
Temporary Tablesp. 87
MySQL Table Typesp. 88
MyISAMp. 89
InnoDBp. 90
Federatedp. 93
Memory (Heap)p. 94
Switching Storage Enginesp. 95
Lockingp. 95
Summaryp. 97
Chapter Reviewp. 97
Multiple Choicep. 97
Conceptsp. 99
Data Manipulation Languagep. 101
INSERTp. 101
Objectivep. 102
Objectivep. 104
SELECTp. 105
Objectivep. 106
Objectivep. 106
Objectivep. 107
Objectivep. 108
Objectivep. 109
Objectivep. 110
Objectivep. 110
Objectivep. 111
Objectivep. 111
Objectivep. 112
Objectivep. 112
Objectivep. 114
Objectivep. 114
Objectivep. 115
Objectivep. 115
Objectivep. 116
UPDATEp. 117
Objectivep. 117
Objectivep. 119
DELETEp. 120
Objectivep. 122
Objectivep. 122
Miscellaneous Data-Manipulation Commandsp. 123
TRUNCATEp. 123
REPLACEp. 123
Summaryp. 124
Chapter Reviewp. 124
Multiple Choicep. 124
Conceptsp. 126
Data Control Languagep. 127
Access Controlp. 127
GRANTp. 128
Limiting Resourcesp. 135
REVOKEp. 136
Transaction Controlp. 140
AUTOCOMMITp. 140
SET TRANSACTIONp. 140
BEGINp. 141
COMMITp. 141
ROLLBACKp. 141
SAVEPOINTp. 142
Summaryp. 145
Chapter Reviewp. 146
Multiple Choicep. 146
Conceptsp. 149
Advanced Queriesp. 151
Multiple-Table Queriesp. 154
Objectivep. 155
Subqueriesp. 157
JOINp. 160
CROSS JOINp. 161
NATURAL JOINp. 163
INNER JOINp. 164
OUTER JOINp. 165
UNIONp. 167
Summary Queriesp. 169
Column Functionsp. 169
GROUP BYp. 170
HAVINGp. 171
Batch Data Extractionp. 172
Batch Data Loadingp. 174
Summaryp. 178
Chapter Reviewp. 178
Multiple Choicep. 178
Conceptsp. 180
Viewsp. 181
CREATE VIEWp. 181
Objectivep. 185
ALTER VIEWp. 188
Objectivep. 188
Objectivep. 189
DROP VIEWp. 189
SHOW CREATE VIEWp. 190
Updating Viewsp. 190
Limitations of Viewsp. 192
View Securityp. 193
Advanced View Informationp. 193
Summaryp. 194
Chapter Reviewp. 195
Multiple Choicep. 195
Conceptsp. 197
SQL Optimizationp. 199
Hardware Optimizationp. 199
Disk I/Op. 200
CPUp. 202
Memoryp. 203
Networkp. 204
Database Softwarep. 207
Operating Systemp. 207
Database Designp. 207
Indexesp. 210
Query Optimizerp. 211
Data Selectionp. 214
SELECT * FROM Table_Namep. 214
Only Select Data Needed for Queryp. 214
Full Table Scansp. 215
EXPLAINp. 215
JOIN TYPESp. 219
Examining the Queryp. 222
Summaryp. 223
Chapter Reviewp. 223
Multiple Choicep. 223
Conceptsp. 225
Normalizationp. 227
First Normal Formp. 229
Second Normal Formp. 232
Third Normal Formp. 233
Boyce-Codd Normal Formp. 234
Advanced Normal Formsp. 235
Denormalizationp. 235
A Database Design How-Top. 236
Sketch It Outp. 236
Check for Redundanciesp. 237
Assign Primary Keysp. 239
Assign Foreign Keysp. 239
Summaryp. 241
Chapter Reviewp. 242
Multiple Choicep. 242
Conceptsp. 244
Embedded SQLp. 245
PHP for the Webp. 245
Testingp. 246
Embedded SQL Examplesp. 248
Command-Line PHPp. 253
Command-Line PHP Examplesp. 253
Objectivep. 255
Other Languagesp. 258
Perlp. 258
Perl Resourcesp. 260
Perl Examplep. 260
Pythonp. 261
Python Resourcep. 261
Python Examplep. 261
Rubyp. 262
Ruby Resourcesp. 262
Ruby Examplep. 262
Summaryp. 264
Chapter Reviewp. 264
Multiple Choicep. 264
Stored Proceduresp. 267
DELIMITERp. 268
CREATE PROCEDUREp. 269
Objectivep. 269
CALLp. 270
SHOW CREATE PROCEDUREp. 271
ALTER PROCEDUREp. 271
Objectivep. 271
DROP PROCEDUREp. 272
BEGIN...ENDp. 272
DECLAREp. 273
SHOW PROCEDURE STATUSp. 273
Programming Constructsp. 273
Branchingp. 273
Loopingp. 275
Summaryp. 276
Chapter Reviewp. 277
Multiple Choicep. 277
Conceptsp. 279
Data Warehousingp. 281
OLTPp. 281
OLAPp. 282
The Operational Databasep. 282
The Data Warehousep. 282
Star Schemap. 283
Snowflake Schemap. 283
The Data Martp. 283
Building a Data Warehousep. 284
Summaryp. 286
Chapter Reviewp. 286
Multiple Choicep. 286
Conceptsp. 288
Database Administrator Utilitiesp. 289
MySQL Maintenancep. 295
MySQL Installationp. 319
Orca Installationp. 331
PHP Installationp. 349
Functionsp. 363
Answers to Chapter Review Questionsp. 439
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review