FREE SHIPPING BOTH WAYS
ON EVERY ORDER!
LIST PRICE:
$36.95

Sorry, this item is currently unavailable.

A Guide to SQL Featuring Oracle

ISBN: 9780760049235 | 0760049238
Edition: 4th
Format: Paperback
Publisher: Course Technology
Pub. Date: 8/1/1997

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
SummaryTable of Contents
Through numerous examples, realistic exercises, and hands-on projects, this text teaches the ins-and-outs of how to use SQL in an Oracle environment.
Prefacev
Introduction to Database Management
1(14)
The Premiere Products Database
2(5)
... MORE
The Henry Books Database
7(8)
Introduction to SQL
15(26)
Introduction
16(1)
Relational Databases
16(5)
Database Creation
21(1)
SQL Commands
22(2)
Dropping a Table
24(1)
Data Types
25(1)
Nulls
25(1)
Loading a Table with Data
26(4)
Viewing Data in a Table
30(1)
Correcting Errors in the Database
30(1)
Additional Tables
31(4)
Describing a Table
35(6)
Single-Table Queries
41(28)
Introduction
42(1)
Simple Queries
42(9)
Sorting
51(1)
Using Functions
52(4)
Nesting Queries
56(2)
Grouping
58(4)
Nulls
62(7)
Multiple-Table Queries
69(24)
Introduction
70(1)
Querying Multiple Tables
70(8)
Using an Alias
78(1)
More Complex Joins
79(3)
Set Operations
82(3)
All and Any
85(8)
Updating Data
93(18)
Introduction
94(1)
Commit and Rollback
94(1)
Changing Existing Data in a Table
94(3)
Adding New Rows to an Existing Table
97(1)
Deleting Existing Rows From a Table
97(1)
Creating a New Table From an Existing Table
98(2)
Changing a Value in a Column to Null
100(1)
Changing the Table Structure
101(10)
Database Administration
111(34)
Introduction
112(1)
Views
112(11)
Security
123(3)
Indexes
126(5)
The System Catalog
131(3)
Integrity in SQL
134(11)
Reports
145(20)
Introduction
146(1)
Concatenating Columns
146(1)
Creating and Using Scripts
147(1)
Creating a View for the Report
148(1)
Executing a Select Command
149(1)
Changing Column Headings
150(1)
Changing Column Formats in a Report
151(2)
Adding a Title to a Report
153(1)
Grouping Data in a Report
154(1)
Including Totals and Subtotals in a Report
155(3)
Sending the Report to a File
158(1)
A Complete Script to Produce the Report
159(6)
Embedded SQL
165(26)
Introduction
166(1)
Data Division
167(1)
Procedure Division
168(3)
Error Handling
171(1)
Multiple-Row Select
171(1)
Updating Cursors
171(5)
Multiple-Row Select
176(6)
Updating Cursors
182(1)
Error Handling
183(8)
Appendix A: Introduction to the Oracle Forms Designer191(20)
Appendix B: Answers to Odd-Numbered Exercises211(30)
Index241

Related Products


  • A Guide To Sql
    A Guide To Sql
  • A Guide to SQL
    A Guide to SQL
  • A Guide to SQL
    A Guide to SQL
  • A Guide to SQL
    A Guide to SQL
  • A Guide to SQL, 8th Edition
    A Guide to SQL, 8th Edition
  • Guide to SQL
    Guide to SQL


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