Guide to SQL

by Pratt, Philip J.

• ISBN13: 9780619033828
• ISBN10: 0619033827
• Format: Paperback
• Copyright: 2000-11-08
• Publisher: Course Technology Ptr

Summary

This comprehensive reference to SQL teaches basic familiarity with SQL programming using straightforward instruction and hands-on projects. All screenshots and examples have been updated to Oracle 8i to provide the most current coverage possible. Two NEW appendices provide handy references for Oracle Commands and Tasks.

Table of Contents

Preface	vii
Introduction to Database Management	1	(16)
Objectives	1	(1)
The Premiere Products Database	2	(6)
The Henry Books Database	8	(5)
Summary	13	(1)
Exercises	14	(3)
An Introduction to SQL	17	(26)
Objectives	17	(1)
Introduction	18	(1)
Relational Databases	18	(5)
Database Creation	23	(1)
SQL Commands	24	(2)
Dropping a Table	26	(1)
Data Types	27	(1)
Nulls	27	(1)
Loading a Table with Data	28	(4)
Viewing Data in a Table	32	(1)
Correcting Errors in the Database	32	(1)
Additional Tables	33	(5)
Describing a Table	38	(1)
Summary	39	(1)
Exercises	40	(3)
Single-Table Queries	43	(30)
Objectives	43	(1)
Introduction	44	(1)
Simple Queries	44	(10)
Sorting	54	(2)
Using Functions	56	(4)
Nesting Queries	60	(3)
Grouping	63	(4)
Nulls	67	(2)
Summary	69	(1)
Exercises	70	(3)
Multiple-Table Queries	73	(26)
Objectives	73	(1)
Introduction	74	(1)
Querying Multiple Tables	74	(9)
Using an Alias	83	(1)
More Complex Joins	84	(4)
Set Operations	88	(4)
ALL and ANY	92	(3)
Summary	95	(1)
Exercises	95	(4)
Updating Data	99	(18)
Objectives	99	(1)
Introduction	100	(1)
Commit and Rollback	100	(1)
Changing Existing Data in a Table	100	(3)
Adding New Rows To An Existing Table	103	(1)
Deleting Existing Rows From A Table	104	(1)
Creating a New Table From an Existing Table	105	(3)
Changing a Value in a Column to Null	108	(1)
Changing a Table's Structure	109	(5)
Summary	114	(1)
Exercises	115	(2)
Database Administration	117	(34)
Objectives	117	(1)
Introduction	118	(1)
Views	118	(11)
Security	129	(3)
Indexes	132	(6)
The System Catalog	138	(3)
Integrity in SQL	141	(5)
Summary	146	(1)
Exercises	147	(4)
Reports	151	(22)
Objectives	151	(1)
Introduction	152	(1)
Concatenating Columns	152	(1)
Creating and Using Scripts	153	(1)
Creating a View for the Report	154	(1)
Executing a Select Command	155	(2)
Changing Column Headings	157	(1)
Changing Column Formats in a Report	158	(2)
Adding a Title to a Report	160	(1)
Grouping Data in a Report	161	(1)
Including Totals and Subtotals in a Report	162	(3)
Sending the Report to a File	165	(1)
A Complete Script to Produce the Report	166	(3)
Summary	169	(1)
Exercises	170	(3)
Embedded SQL	173	(28)
Objectives	173	(1)
Introduction	174	(1)
Data Division	175	(1)
Procedure Division	176	(11)
Multiple-Row SELECT	187	(7)
Updating Cursors	194	(2)
Error Handling	196	(1)
Summarys	197	(1)
Exercises	198	(3)
A SQL Reference	201	(16)
Aliases	202	(1)
Alter Table	202	(1)
Column or Expression List (Select Clause)	202	(1)
Commit	203	(1)
Conditions	204	(2)
Create Index	206	(1)
Create Table	207	(1)
Create View	207	(1)
Data Types	208	(1)
Delete Rows	209	(1)
Drop Index	209	(1)
Drop Table	209	(1)
Drop View	210	(1)
Grant	210	(1)
Insert Into (Query)	211	(1)
Insert Into (Values)	211	(1)
Integrity	212	(1)
Revoke	212	(1)
Rollback	213	(1)
Select	213	(2)
Subqueries	215	(1)
Union, Intersect, and Minus	215	(1)
Update	216	(1)
B ``How do I'' Reference	217	(4)
C Answers to Odd-Numbered Exercises	221	(30)
Index	251