Amazon no longer offers textbook rentals. We do!

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

by: Shah, Nilesh D.

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

by: Shah, Nilesh D.

ISBN 13:
9780130909336
ISBN 10:
0130909335
Edition: 1st
Format: Paperback
Copyright: 01/01/2002
Publisher: Prentice Hall
Newer Edition

New From $66.34

Sorry, this item is currently unavailable.

List Price $67.00 Save $0.66

New $66.34

Usually Ships in 2-3 Business Days

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

For Database Systems courses focusing on SQL and/or Oracle, Oracle courses, and SQL courses offered in departments of Computer Science, CIS, MIS, IT and Continuing Education. Database Systems Using Oracle first introduces students to relational database concepts and database designing techniques, teaching them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a future reference. The author concludes with an introduction to the architecture and administration of Oracle 8, the new features of Oracle 8i, and the concepts of object orientation.

Foreword

xiii

Preface

Acknowledgments

xvii

Part 1: Database Concepts

(34)

Database Concepts: A Relational Approach

(19)

Database: An Introduction

(1)

Relationships

(1)

Database Management System (DBMS)

(2)

The Relational Database Model

(3)

Integrity Rules

(1)

Theoretical Relational Languages

(9)

Relational Algebra

(5)

Applications of Relational Algebra

(1)

Relational Calculus

(2)

Final Note

(1)

In a Nutshell

(1)

Exercise Questions

(2)

Database Design: Data Modeling and Normalization

(15)

Data Modeling

(4)

Dependency

(1)

Database Design

(1)

Normal Forms

(2)

Anomalies

(1)

First Normal Form (1NF)

(1)

Second Normal Form (2NF)

(1)

Third Normal Form (3NF)

(1)

Dependency Diagrams

(3)

Conversion from 1NF to 2NF

(1)

Conversion from 2NF to 3NF

(2)

Denormalization

(1)

In a Nutshell

(1)

Exercise Questions

(2)

Part 2: The Oracle SQL

(144)

Oracle 8: An Overview

(20)

Personal Databases

(2)

Client/Server Databases

(2)

Oracle 8: An Introduction

(1)

The SQL*Plus Environment

(1)

Structured Query Language

(1)

Logging In to SQL*Plus

(1)

SQL*Plus Commands

(2)

Sample Databases

(7)

The Indo-US College Student Database

(3)

The NamanNavan Corporation Employee Database

(3)

Alternate Text Editors

(1)

Oracle Online Help

(1)

In a Nutshell

(1)

Exercise Questions

(1)

Lab Activity

(2)

Oracle Tables: Creation and Modification

(24)

Naming Conventions

(1)

Data Types

(3)

Varchar2

(1)

Char

(1)

Number

(1)

Date

(1)

Constraints

(4)

Types of Constraints

(1)

Naming a Constraint

(1)

Defining a Constraint

(2)

Creating an Oracle Table

(3)

Displaying Table Information

(2)

Viewing a User's Table Names

(1)

Viewing a Table's Structure

(1)

Viewing Constraint Information

(1)

Altering an Existing Table

(5)

Adding a New Column to an Existing Table

(1)

Modifying an Existing Column

(1)

Adding a Constraint

(1)

Error Codes

(3)

Dropping a Column (Oracle 8i Onward)

(1)

Dropping a Table

(1)

Renaming a Table

(1)

Truncating a Table

(1)

Spooling

(1)

In a Nutshell

(1)

Exercise Questions

(1)

Lab Activity

(2)

Working with Tables: Data Management and Retrieval

(48)

Adding a New Row/Record

(3)

Entering NULL Values

(1)

Substitution Variables

(1)

Customized Prompts

(1)

Updating Existing Rows/Records

(2)

Deleting Existing Rows/Records

(1)

Dropping a Constraint

(1)

Disabling/Enabling Constraints

(1)

Retrieving Data from a Table

(6)

Wild Card (*)

(1)

Distinct Clause

(1)

Column Alias

(1)

Concatenation

(2)

Arithmetic Operations

(1)

Order of Operation

(1)

Restricting Data with a Where Clause

(9)

Wild Cards

101

(2)

Sorting

103

(4)

Built-in Functions

107

(12)

Single-Row Functions

107

(9)

Group Functions

116

(3)

Grouping Data

119

(2)

Having Clause

120

(1)

Nesting Group Functions

121

(1)

Revisiting Substitution Variables

121

(1)

Define Command

122

(1)

In a Nutshell

123

(2)

Exercise Questions

125

(1)

Lab Activity

126

(1)

Multiple Tables: Joins and Sub-Queries

127

(24)

Join

128

(9)

Product

128

(1)

Equijoin

129

(3)

Table Aliases

132

(1)

Additional Conditions

133

(1)

Nonequijoin

133

(1)

Outer Join

134

(2)

Self-Join

136

(1)

Set Operators

137

(3)

Union

137

(2)

Union All

139

(1)

Intersect

139

(1)

Minus

140

(1)

Sub-Query

140

(6)

Single-Row Sub-Query

142

(1)

Creating a Table Using a Sub-Query

143

(1)

Insert Using a Sub-Query

143

(1)

Update Using a Sub-Query

144

(1)

Delete Using a Sub-Query

144

(1)

Multiple-Row Sub-Query

145

(1)

Top-N Analysis

146

(2)

Important Note about TOP-N Analysis

147

(1)

In a Nutshell

148

(1)

Exercise Questions

149

(1)

Lab Activity

150

(1)

Advanced Features: Objects, Transactions, and Control

151

(28)

Views

151

(4)

Creating a View

152

(2)

Removing a View

154

(1)

Sequences

155

(3)

Modifying a Sequence

158

(1)

Dropping a Sequence

158

(1)

Synonyms

158

(1)

Index

159

(1)

Transactions

160

(3)

Read Consistency and Locking

162

(1)

Locking Rows for Update

163

(1)

Controlling Access

164

(4)

User, Role, and System Privileges

164

(2)

Object Privileges

166

(2)

In a Nutshell

168

(1)

Exercise Questions

168

(1)

Lab Activity

169

(1)

SQL Review: Supplementary Examples

170

(9)

Part 3: PL/SQL

179

(97)

PL/SQL: Programming Language Basics

179

(18)

A Brief History of PL/SQL

180

(1)

Fundamentals of PL/SQL

181

(2)

Reserved Words

181

(1)

User-Defined Words

181

(1)

Literals

182

(1)

PL/SQL Block Structure

183

(1)

Comments

184

(1)

Data Types

184

(3)

Character

185

(1)

Number

186

(1)

Boolean

186

(1)

Date

187

(1)

Other Scalar Data Types

187

(1)

NLS

187

(1)

Lob

187

(1)

Variable Declaration

188

(1)

Anchored Declaration

188

(2)

Nested Anchoring

189

(1)

Not Null Constraint for %Type Declarations

190

(1)

Assignment Operation

190

(1)

Bind Variables

191

(1)

Substitution Variables in PL/SQL

192

(1)

Printing in PL/SQL

192

(1)

Arithmetic Operators

193

(1)

In a Nutshell

194

(1)

Exercise Questions

195

(1)

Lab Activity

196

(1)

SQL and Control Structures in PL/SQL

197

(19)

Control Structures

198

(11)

Selection Structure

198

(6)

Looping Structure

204

(5)

Nested Blocks

209

(1)

SQL in PL/SQL

209

(1)

Select Statement in PL/SQL

209

(1)

Data Manipulation in PL/SQL

210

(3)

Insert Statement

210

(1)

Delete Statement

210

(2)

Update Statement

212

(1)

Transaction Control Statements

213

(1)

In a Nutshell

213

(1)

Exercise Questions

214

(1)

Lab Activity

215

(1)

Cursors and Exceptions

216

(26)

Cursors

217

(1)

Types of Cursors

217

(1)

Implicit Cursors

217

(1)

Explicit Cursors

218

(3)

Declaring an Explicit Cursor

218

(1)

Actions on Explicit Cursors

219

(2)

Explicit Cursor Attributes

221

(2)

%Isopen

221

(1)

%Found

222

(1)

%Notfound

222

(1)

%Rowcount

223

(1)

Implicit Cursor Attributes

223

(1)

Cursor FOR Loops

224

(1)

Cursor For Loop Using a Sub-Query

224

(1)

Select...For Update Cursor

225

(1)

Where Current of Clause

226

(1)

Cursor with Parameters

226

(1)

Cursor Variables: An Introduction

227

(2)

Ref Cursor Type

228

(1)

Opening a Cursor Variable

228

(1)

Fetching from a Cursor Variable

229

(1)

Exceptions

229

(1)

Types of Exceptions

230

(5)

Predefined Oracle Server Exceptions

230

(1)

Nonpredefined Oracle Server Exceptions

231

(3)

User-Defined Exceptions

234

(1)

Sample Programs

235

(4)

In a Nutshell

239

(1)

Exercise Questions

240

(1)

Lab Activity

241

(1)

Composite Data Types: Records and Tables

242

(13)

Composite Data Types

242

(1)

PL/SQL Records

243

(2)

Creating a PL/SQL Record

243

(1)

Referencing Fields in a Record

244

(1)

Working with Records

244

(1)

Nested Records

245

(1)

PL/SQL Tables

245

(6)

Declaring a PL/SQL Table

246

(1)

Referencing Table Elements/Rows

247

(1)

Assigning Values to Rows in a PL/SQL Table

248

(1)

Built-In Table Methods

249

(1)

Table of Records

250

(1)

Sample Programs

251

(1)

In a Nutshell

252

(1)

Exercise Questions

253

(1)

Lab Activity

254

(1)

Procedures, Functions, and Packages

255

(21)

Procedures

256

(5)

Calling a Procedure

256

(1)

Procedure Header

256

(1)

Procedure Body

256

(1)

Parameters

256

(2)

Actual and Formal Parameters

258

(1)

Matching Actual and Formal Parameters

258

(3)

Functions

261

(4)

Function Header

262

(1)

Function Body

262

(1)

Return Data Types

262

(1)

Calling a Function

262

(3)

Packages

265

(8)

Structure of a Package

266

(1)

Package Specification

266

(1)

Package Body

267

(1)

Triggers

268

(3)

Before Triggers

271

(1)

After Triggers

272

(1)

In a Nutshell

273

(1)

Exercise Questions

274

(1)

Lab Activity

275

(1)

Part 4: Miscellaneous Topics

276

(27)

Oracle Database Administration

276

(17)

Database Administrator (DBA)

276

(1)

Oracle Architecture: An Overview

277

(2)

Installation

279

(2)

Networking

281

(1)

Security

282

(2)

System Privileges

284

(1)

Roles

285

(1)

Users

286

(1)

Oracle Tools

286

(1)

SQL*Plus

287

(3)

Oracle Data Dictionary

290

(1)

In a Nutshell

290

(1)

Exercise Questions

291

(2)

Oracle 81: An Overview and Web Tools

293

(10)

Oracle8i Core Package

293

(1)

An Object

294

(2)

SQL Queries for Objects

296

(1)

Retrieving Data from an Object Table

296

(1)

Inserting a Row into an Object Table

296

(1)

Updating an Object

297

(1)

Deleting Rows from an Object Table

297

(1)

Internet Computing and Oracle8i

297

(2)

Internet Terminology

298

(1)

Oracle Internet Tools

298

(1)

WebDB

299

(2)

Component Administration

300

(1)

Create Web Sites

300

(1)

JDeveloper

301

(1)

In a Nutshell

301

(1)

Exercise Questions

302

(1)

APPENDIX A SAMPLE DATABASES: TABLE DEFINITIONS

303

(3)

The Indo-US College Student Database

303

(2)

The NamanNavan Corporation College Database

305

(1)

APPENDIX B QUICK REFERENCE TO SQL AND PL/SQL SYNTAX

306

(11)

APPENDIX C ADDITIONAL REFERENCES

317

(2)

Web Sites

317

(1)

Books and Other Published Material on Oracle

318

(1)

Index

319

Amazon no longer offers textbook rentals. We do!

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

9780130909336

0130909335

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

Database Systems Using Oracle : A Simplified Guide to SQL and PL/SQL

9780130909336

0130909335

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products