Sams Teach Yourself SQL in 24 Hours

by Plew, Ronald R.; Plew, Ron; Stephens, Ryan

• ISBN13: 9780672318993
• ISBN10: 0672318997
• Edition: 2nd
• Format: Paperback
• Copyright: 2000-03-01
• Publisher: Macmillan Computer Pub

Summary

Written by college instructors, Sams Teach Yourself SQL in 24 Hours quickly teaches beginning- to intermediate-level SQL users how to create, store, access and manipulate data using a proven step-by-step format that teaches SQL by example. This book contains a thorough explanation of database concepts, SQL procedures, and low-level programming, enabling readers to gain an understanding of the whys as well as the hows behind SQL.This book presents complete code listings and output, followed with analysis that explains exactly what the listings are doing. These practical code examples can be incorporated easily by the reader into other projects. Coverage includes SQL, as well as SQL in an enterprise setting and on the Web and Intranet.Authors Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each.

Table of Contents

Introduction	1	(4)
Part I: An SQL Concepts Overview	5	(18)
Welcome to the World of SQL	7	(16)
Part II: Building Your Database	23	(64)
Defining Data Structures	25	(12)
Managing Database Objects	37	(18)
The Normalization Process	55	(10)
Manipulating Data	65	(12)
Managing Database Transactions	77	(10)
Part III: Getting Effective Results from Queries	87	(96)
Introduction to the Database Query	89	(14)
Using Operators to Categorize Data	103	(24)
Summarizing Data Results from a Query	127	(10)
Sorting and Grouping Data	137	(12)
Restructuring the Appearance of Data	149	(20)
Understanding Dates and Times	169	(14)
Part IV: Building Sophisticated Database Queries	183	(52)
Joining Tables in Queries	185	(20)
Using Subqueries to Define Unknown Data	205	(14)
Combining Multiple Queries into One	219	(16)
Part V: SQL Performance Tuning	235	(28)
Using Indexes to Improve Performance	237	(10)
Improving Database Performance	247	(16)
Part VI: Using SQL to Manage Users and Security	263	(28)
Managing Database Users	265	(12)
Managing Database Security	277	(14)
Part VII: Summarized Data Structures	291	(30)
Creating and Using Views and Synonyms	293	(15)
Working with the System Catalog	308	(13)
Part VIII: Applying SQL Fundamentals in Today's World	321	(36)
Advanced SQL Topics	323	(14)
Extending SQL to the Enterprise, the Internet, and the Intranet	337	(10)
Extensions to Standard SQL	347	(10)
Part X: Appendixes	357	(66)
Appendix A Common SQL Commands	359	(6)
B ASCII Table	365	(6)
C Answers to Quizzes and Exercises	371	(40)
D Create Table Statements for Book Examples	411	(2)
E Insert Statements for Data in Book Examples	413	(6)
F Glossary	419	(4)
Index	423