CART

(0) items

Oracle9i : SQL (With an Introduction to PL/SQL) with Self Assessment Software Demo,9780619212841
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Oracle9i : SQL (With an Introduction to PL/SQL) with Self Assessment Software Demo

by
Edition:
1st
ISBN13:

9780619212841

ISBN10:
0619212845
Format:
Paperback
Pub. Date:
7/16/2003
Publisher(s):
Cengage Learning

Questions About This Book?

What version or edition is this?
This is the 1st edition with a publication date of 7/16/2003.
What is included with this book?
  • The Used copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included.

Summary

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

Table of Contents

PREFACE xv
CHAPTER ONE Overview of Database Concepts 1(20)
Database Terminology
2(1)
Review of Database Design
3(8)
Entity-Relationship (E-R) Model
4(2)
Database Normalization
6(3)
Linking Tables Within the Database
9(2)
JustLee Books' Database Description
11(3)
Basic Assumptions
11(1)
Tables Within JustLee Books' Database
12(2)
Structured Query Language (SQL)
14(1)
Chapter Summary
15(1)
Review Questions
15(1)
Multiple Choice
16(3)
Hands-on Assignments
19(1)
A Case for Oracle9i
20(1)
CHAPTER TWO Basic SQL SELECT Statements 21(26)
SELECT Statement Syntax
23(7)
Selecting All Data in a Table
25(1)
Selecting One Column from a Table
26(2)
Selecting Multiple Columns from a Table
28(2)
Operations Within the SELECT Statement
30(7)
Using Column Aliases
30(2)
Using Arithmetic Operations
32(1)
Using DISTINCT and Unique
33(1)
Creating Concatenation
34(3)
Chapter Summary
37(1)
Chapter 2 Syntax Summary
38(1)
Review Questions
39(1)
Multiple Choice
40(4)
Hands-on Assignments
44(1)
A Case for Oracle9i
45(2)
CHAPTER THREE Restricting Rows and Sorting Data 47(34)
WHERE Clause Syntax
48(3)
Rules for Character Strings
50(1)
Rules for Dates
51(1)
Comparison Operators
51(8)
BETWEEN... AND Operator
56(1)
IN Operator
56(1)
LIKE Operator
57(2)
Logical Operators
59(3)
Treatment of NULL Values
62(1)
ORDER BY Clause Syntax
63(5)
Secondary Sort
66(1)
Sorting by SELECT Order
67(1)
Editing in SQL*Plus
68(3)
Chapter Summary
71(2)
Chapter 3 Syntax Summary
73(2)
Review Questions
75(1)
Multiple Choice
75(5)
Hands-on Assignments
80(1)
A Case for Oracle9i
80(1)
CHAPTER FOUR Joining Multiple Tables 81(42)
Cartesian Joins
83(3)
Cartesian Join-Traditional Method
83(2)
Cartesian Join JOIN Method
85(1)
Equality Joins
86(7)
Equality Joins-Traditional Method
86(3)
Equality Joins JOIN Method
89(4)
Non-Equality Joins
93(3)
Non-Equality Joins-Traditional Method
93(2)
Non-Equality Joins JOIN Method
95(1)
Self-Joins
96(1)
Self-Joins-Traditional Method
96(1)
Self-Joins-JOIN Method
97(1)
Outer Joins
97(5)
Outer Joins-Traditional Method
99(1)
Outer Joins JOIN Method
100(2)
Set Operators
102(4)
Joining Three or More Tables
106(3)
Joining Three or More Tables-Traditional Method
106(1)
Joining Three or More Tables JOIN Method
107(2)
Chapter Summary
109(2)
Chapter 4 Syntax Summary
111(3)
Review Questions
114(1)
Multiple Choice
114(6)
Hands-on Assignments
120(1)
A Case for Oracle9i
121(2)
CHAPTER FIVE Selected Single-Row Functions 123(38)
Case Conversion Functions
124(3)
LOWER Function
124(2)
UPPER Function
126(1)
INITCAP Function
126(1)
Character Manipulation Functions
127(6)
SUBSTR Function
127(2)
LENGTH Function
129(1)
LPAD and RPAD Functions
130(1)
LTRIM and RTRIM Functions
131(1)
REPLACE Function
132(1)
CONCAT Function
132(1)
Number Functions
133(3)
ROUND Function
133(2)
TRUNC Function
135(1)
Date Functions
136(4)
MONTHS_BETWEEN Function
137(1)
ADD_MONTHS Function
137(1)
NEXT_DAY Function
138(1)
TO_DATE Function
139(1)
Other Functions
140(8)
NVL Function
140(2)
NVL2 Function
142(1)
TO_CHAR Function
143(3)
DECODE Function
146(1)
SOUNDER Function
147(1)
Nesting Functions
148(1)
DUAL Table
149(2)
Chapter Summary
151(1)
Chapter 5 Syntax Summary
152(2)
Review Questions
154(1)
Multiple Choice
155(4)
Hands-on Assignments
159(1)
A Case for Oracle9i
160(1)
CHAPTER SIX Group Functions 161(28)
Group Function Concepts
162(11)
SUM Function
163(2)
AVG Function
165(1)
COUNT Function
166(2)
MAX Function
168(1)
MIN Function
169(1)
GROUP BY Clause
170(3)
HAVING Clause
173(2)
Nesting Functions
175(1)
Statistical Group Functions
176(3)
STDDEV Function
176(1)
VARIANCE Function
177(2)
Chapter Summary
179(1)
Chapter 6 Syntax Summary
179(2)
Review Questions
181(1)
Multiple Choice
181(5)
Hands-on Assignments
186(1)
A Case for Oracle9i
187(2)
CHAPTER SEVEN Subqueries 189(38)
Subqueries and Their Uses
190(1)
Single-Row Subqueries
191(6)
Single-Row Subquery in a WHERE Clause
191(4)
Single-Row Subquery in a HAVING Clause
195(1)
Single-Row Subquery in a SELECT Clause
196(1)
Multiple-row Subqueries
197(9)
IN Operator
197(1)
ALL and ANY Operators
198(5)
EXISTS Operator
203(1)
Multiple-Row Subquery in a HAVING Clause
204(2)
Multiple-column Subqueries
206(3)
Multiple-Column Subquery in a FROM Clause
206(1)
Multiple-Column Subquery in a WHERE Clause
207(2)
NULL Values
209(4)
NVL in Subqueries
210(1)
IS NULL in Subqueries
211(1)
Correlated Subqueries
211(2)
Nested Subqueries
213(2)
Chapter Summary
215(1)
Chapter 7 Syntax Summary
216(1)
Review Questions
217(1)
Multiple Choice
218(6)
Hands-on Assignments
224(1)
A Case for Oracle9i
224(3)
CHAPTER EIGHT Table Creation and Management 227(32)
Table Design
229(3)
Table Creation
232(2)
Defining Columns
232(2)
Viewing Table Structures: DESCRIBE
234(1)
Table Creation Through Subqueries
234(5)
CREATE TABLE...AS
235(3)
Subqueries with Group Functions
238(1)
Modifying Existing Tables
239(20)
ALTER TABLE...ADD Command
240(1)
ALTER TABLE...MODIFY Command
240(3)
ALTER TABLE...DROP COLUMN Command
243(1)
ALTER TABLE...SET UNUSED/DROP UNUSED COLUMNS Command
244(2)
Renaming a Table
246(2)
Truncating a Table
248(1)
Deleting a Table
249(1)
Chapter Summary
250(1)
Chapter 8 Syntax Summary
250(2)
Review Questions
252(1)
Multiple Choice
252(4)
Hands-on Assignments
256(1)
A Case for Oracle9i
257(2)
CHAPTER NINE Constraints 259(30)
Creating Constraints
260(2)
Creating Constraints at the Column Level
261(1)
Creating Constraints at the Table Level
262(1)
Using the PRIMARY KEY Constraint
262(3)
Using the FOREIGN KEY Constraint
265(3)
Using the UNIQUE Constraint
268(1)
Using the CHECK Constraint
269(2)
Using the NOT NULL Constraint
271(1)
Including Constraints During Table Creation
272(3)
Viewing Constraints
275(1)
Disabling and Dropping Constraints
276(1)
Using DISABLE/ENABLE
276(1)
Dropping Constraints
277(1)
Chapter Summary
278(1)
Chapter 9 Syntax Summary
279(2)
Review Questions
281(1)
Multiple Choice
282(5)
Hands-on Assignments
287(1)
A Case for Oracle9i
287(2)
CHAPTER TEN Data Manipulation 289(32)
Inserting New Rows
290(9)
INSERT Command
291(6)
Inserting Data from an Existing Table
297(2)
Modifying Existing Rows
299(3)
UPDATE command
299(3)
Substitution Variables
302(2)
Transaction Control Statements
304(2)
COMMIT and ROLLBACK Commands
305(1)
Deleting Rows
306(3)
Table Locks
309(2)
LOCK TABLE command
309(1)
SELECT... FOR UPDATE Command
310(1)
Chapter Summary
311(1)
Chapter 10 Syntax Summary
312(1)
Review Questions
313(1)
Multiple Choice
314(4)
Hands-on Assignments
318(1)
A Case for Oracle9i
319(2)
CHAPTER ELEVEN Views 321(30)
Creating a View
323(7)
Creating a Simple View
324(3)
DML Operations on a Simple View
327(3)
Creating a Complex View
330(9)
DML Operations on a Complex View with an Arithmetic Expression
331(2)
DML Operations on a Complex View Containing Data from Multiple Tables
333(3)
DML Operations on a Complex View Containing Functions or Grouped Data
336(1)
DML Operations on a Complex View Containing DISTINCT or ROWNUM
337(1)
Summary Guidelines of DML Operations on a Complex View
338(1)
Dropping a View
339(1)
Creating an Inline View
339(3)
"TOP-N" Analysis
340(2)
Chapter Summary
342(1)
Chapter 11 Syntax Summary
343(1)
Review Questions
343(1)
Multiple Choice
344(5)
Hands-on Assignments
349(1)
A Case for Oracle9i
350(1)
CHAPTER TWELVE Additional Database Objects 351(28)
Sequences
353(8)
Creating a Sequence
353(5)
Using Sequence Values
358(2)
Altering Sequence Definitions
360(1)
Dropping a Sequence
361(1)
Indexes
361(5)
Creating an Index
363(2)
Verifying an Index
365(1)
Synonyms
366(3)
Deleting a Synonym
368(1)
The Data Dictionary
369(1)
Chapter Summary
370(2)
Chapter 12 Syntax Summary
372(1)
Review Questions
373(1)
Multiple Choice
373(4)
Hands-on Assignments
377(1)
A Case for Oracle9i
378(1)
CHAPTER THIRTEEN User Creation and Management 379(30)
The Need for Security
381(2)
Creating a User
383(2)
Creating User Names and Passwords
383(1)
Connecting to the Oracle Server
384(1)
Granting Privileges
385(8)
Object Privileges
385(1)
Granting Object Privileges
386(1)
System Privileges
387(1)
Granting System Privileges
388(1)
Deploying GRANT Commands
389(1)
Changing a User Password
390(3)
Granting Roles
393(5)
Viewing Privileges
397(1)
Revoking and Dropping Privileges and Roles
398(3)
Revoking Privileges and Roles
398(2)
Dropping a Role
400(1)
Dropping a User
400(1)
Chapter Summary
401(1)
Chapter 13 Syntax Summary
402(1)
Review Questions
403(1)
Multiple Choice
404(3)
Hands-on Assignments
407(1)
A Case for Oracle9i
408(1)
CHAPTER FOURTEEN Formatting Readable Output 409(34)
The Basic Strategy
410(1)
COLUMN Command
411(11)
FORMAT Option
412(5)
HEADING Option
417(3)
NULL Option
420(2)
Environment Variables
422(6)
Report Headers and Footers
423(2)
LINESIZE
425(1)
PAGESIZE
426(2)
BREAK Command
428(6)
CLEAR Command
430(1)
COMPUTE Command
431(2)
SPOOL Command
433(1)
Chapter Summary
434(1)
Chapter 14 Syntax Summary
435(2)
Review Questions
437(1)
Multiple Choice
437(5)
Hands-on Assignments
442(1)
A Case for Oracle9i
442(1)
CHAPTER FIFTEEN Introduction to PL/SQL 443(32)
Basic Structure
445(3)
Declarative Section
448(4)
Variable Names
449(1)
Constants
449(1)
PL/SQL Datatypes
449(2)
NOT NULL Constraint
451(1)
Variable Initialization
451(1)
Executable Section
452(4)
SELECT Statement
452(1)
DML Statements in PL/SQL
453(3)
Execution Control
456(3)
IF Statements
456(3)
Iterative Control
459(5)
Basic Loop
459(2)
FOR Loop
461(1)
WHILE Loop
462(1)
Nested Loops
463(1)
Chapter Summary
464(1)
Chapter 15 Syntax Summary
465(3)
Review Questions
468(1)
Multiple Choice
468(4)
Hands-on Assignments
472(1)
A Case for Oracle9i
473(2)
CHAPTER SIXTEEN Cursors and Exceptions 475(26)
Cursors
476(12)
Declaring an Explicit Cursor
477(1)
Opening an Explicit Cursor
478(1)
Closing the Cursor
479(1)
Fetching Data from the Cursor
479(4)
Cursor FOR Loop
483(3)
Cursor Loop Control with Logical Operators
486(2)
Exception Handling
488(4)
User-Defined Exception Handling
490(2)
Chapter Summary
492(1)
Chapter 16 Syntax Summary
493(1)
Review Questions
494(1)
Multiple Choice
495(3)
Hands-on Assignments
498(1)
A Case for Oracle9i
499(2)
APPENDIX A 501(6)
Tables for the JustLee Books Database
501(22)
CUSTOMERS Table
501(1)
BOOKS Table
502(1)
ORDERS Table
502(1)
ORDERITEMS Table
503(1)
AUTHOR Table
504(1)
BOOKAUTHOR Table
505(1)
PUBLISHER Table
506(1)
PROMOTION Table
506(1)
APPENDIX B SQL Syntax Guide 507(16)
APPENDIX C 523(27)
Oracle9i Practice Exams (A-E)
523(27)
Practice Exam A
523(6)
Practice Exam B
529(6)
Practice Exam C
535(6)
Practice Exam D
541(5)
Practice Exam E
546(4)
APPENDIX D 550(3)
Oracle Resources
550(3)
Oracle Academic Initiative (OAJ)
550(1)
Oracle Certification Program (OCP)
550(1)
Oracle Technology Network (OTN)
550(1)
International Oracle Users Group (JOUG)
550(3)
GLOSSARY 553(8)
INDEX 561


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