CART

(0) items

Guide to SQL,9780619033828

Guide to SQL

by
Edition:
5th
ISBN13:

9780619033828

ISBN10:
0619033827
Format:
Paperback
Pub. Date:
11/8/2000
Publisher(s):
Course Technology
List Price: $44.00
More New and Used
from Private Sellers
Starting at $0.01
See Prices

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

New Textbook

We're Sorry
Sold Out

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


Please wait while the item is added to your cart...