Cover image for SQL for dummies
Title:
SQL for dummies
Author:
Taylor, Allen G.
Personal Author:
Edition:
Fifth edition.
Publication Information:
Hoboken, NJ : Wiley, [2003]

©2003
Physical Description:
xviii, 408 pages : illustrations ; 24 cm.
General Note:
"Fully updated with all-new coverage for SQL:2003"-- Cover.

Includes index.
Language:
English
ISBN:
9780764540752
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
QA76.73.S67 T39 2003 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them.

Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities - the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique.

Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value in SQL For Dummies, 5th Edition ; even if you have some experience designing and creating databases, you may discover a few things you didn't know about.

Here's just a sampling of some of the things you'll find covered in SQL For Dummies, 5th Edition:

Exploring relational database and SQL fundamentals Building and maintaining a simple database structure Building a multiple relational database Manipulating database data Examining SQL nuts and bolts: values, expressions, operators, and queries Providing database security and protecting your data Exploring ODBC and JDBC, and using SQL with XML Moving beyond the basics: cursors, persistent stored modules, and error-handling Top Ten lists on common SQL mistakes and retrieval tips

Plain and simply, databases are the best tools ever invented for keeping track of the things you care about. After you understand databases and can use SQL to make them do your bidding, you wield tremendous power. SQL For Dummies, 5th Edition, can get you well on your way to harnessing the power of databases.


Author Notes

Allen G. Taylor is a database instructor who has written 20 computer books. He operates a Web development company and is much in demand as a speaker


Table of Contents

Introductionp. 1
About This Bookp. 1
Who Should Read This Book?p. 2
How This Book Is Organizedp. 2
Icons Used in This Bookp. 4
Getting Startedp. 4
Part I Basic Conceptsp. 5
Chapter 1 Relational Database Fundamentalsp. 7
Chapter 2 SQL Fundamentalsp. 21
Chapter 3 The Components of SQLp. 45
Part II Using SQL to Build Databasesp. 71
Chapter 4 Building and Maintaining a Simple Database Structurep. 73
Chapter 5 Building a Multitable Relational Databasep. 91
Part III Retrieving Datap. 119
Chapter 6 Manipulating Database Datap. 121
Chapter 7 Specifying Valuesp. 139
Chapter 8 Advanced SQL Value Expressionsp. 161
Chapter 9 Zeroing In on the Data You Wantp. 173
Chapter 10 Relational Operatorsp. 199
Chapter 11 Delving Deep with Nested Queriesp. 223
Chapter 12 Recursive Queriesp. 241
Chapter 13 Providing Database Securityp. 251
Part IV Controlling Operationsp. 265
Chapter 14 Protecting Datap. 267
Chapter 15 Using SQL Within Applicationsp. 285
Part V SQL in the Real Worldp. 295
Chapter 16 ODBC and JDBCp. 297
Chapter 17 SQL:2003 and XMLp. 307
Part VI Advanced Topicsp. 321
Chapter 18 Cursorsp. 323
Chapter 19 Persistent Stored Modulesp. 333
Chapter 20 Error-Handlingp. 351
Part VII The Part of Tensp. 363
Chapter 21 Ten Common Mistakesp. 365
Chapter 22 Ten Retrieval Tipsp. 369
Part VIII Appendixesp. 373
Appendix A SQL:2003 Reserved Wordsp. 375
Appendix B Glossaryp. 379
Indexp. 387