Rent 9780619033828 | Guide to SQL | Pratt, Philip @knetbooks.com

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

Summary Table of Contents

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.

Preface

vii

Introduction to Database Management

(16)

Objectives

(1)

... MORE

The Premiere Products Database

(6)

The Henry Books Database

(5)

Summary

(1)

Exercises

(3)

An Introduction to SQL

(26)

Objectives

(1)

Introduction

(1)

Relational Databases

(5)

Database Creation

(1)

SQL Commands

(2)

Dropping a Table

(1)

Data Types

(1)

Nulls

(1)

Loading a Table with Data

(4)

Viewing Data in a Table

(1)

Correcting Errors in the Database

(1)

Additional Tables

(5)

Describing a Table

(1)

Summary

(1)

Exercises

(3)

Single-Table Queries

(30)

Objectives

(1)

Introduction

(1)

Simple Queries

(10)

Sorting

(2)

Using Functions

(4)

Nesting Queries

(3)

Grouping

(4)

Nulls

(2)

Summary

(1)

Exercises

(3)

Multiple-Table Queries

(26)

Objectives

(1)

Introduction

(1)

Querying Multiple Tables

(9)

Using an Alias

(1)

More Complex Joins

(4)

Set Operations

(4)

ALL and ANY

(3)

Summary

(1)

Exercises

(4)

Updating Data

(18)

Objectives

(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

RENT TEXTBOOKS

Guide to SQL

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products