CART

(0) items

Oracle 10g : SQL,9781418836290
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.

Oracle 10g : SQL

by
Edition:
1st
ISBN13:

9781418836290

ISBN10:
141883629X
Format:
Paperback
Pub. Date:
1/27/2006
Publisher(s):
Cengage Learning
List Price: $157.00

eTextbook


 
Duration
Price
$46.19

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

New Textbook

We're Sorry
Sold Out

More New and Used
from Private Sellers
Starting at $4.25
See Prices

Related Products


  • Oracle 11g : SQL
    Oracle 11g : SQL
  • Oracle 11G: SQL, 2nd Edition
    Oracle 11G: SQL, 2nd Edition
  • Oracle 9I: SQL With an Introduction to Pl/SQL
    Oracle 9I: SQL With an Introduction to Pl/SQL
  • Oracle9i : SQL (With an Introduction to PL/SQL) with Self Assessment Software Demo
    Oracle9i : SQL (With an Introduction to PL/SQL) with Self Assessment Software Demo




Summary

This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

Table of Contents

Preface xiii
Overview of Database Concepts
1(24)
Database Terminology
3(1)
Database Management System
4(1)
Database Design
4(10)
Entity-Relationship (E-R) Model
5(2)
Database Normalization
7(4)
Relating Tables Within the Database
11(3)
Structured Query Language (SQL)
14(1)
Databases Used in This Textbook
14(3)
Basic Assumptions
14(1)
Tables Within JustLee Books' Database
15(2)
Topic sequence
17(1)
Chapter Summary
18(1)
Review Questions
18(1)
Multiple Choice
19(3)
Hands-On Assignments
22(1)
Advanced Challenge
23(1)
Case Study: City Jail
23(2)
Basic SQL Select Statements
25(28)
Select Statement Syntax
28(6)
Selecting All Data in a Table
29(2)
Selecting One Column from a Table
31(1)
Selecting Multiple Columns from a Table
32(2)
Operations Within the Select Statement
34(10)
Using Column Aliases
34(2)
Using Arithmetic Operations
36(1)
Using Distinct and Unique
37(2)
Using Concatenation
39(1)
Inserting a Line Break
40(4)
Chapter Summary
44(1)
Syntax Summary
44(2)
Review Questions
46(4)
Hands-On Assignments
50(1)
Advanced Challenge
51(1)
Case Study: City Jail
51(2)
Table Creation and Management
53(38)
Table Design
56(4)
Table Creation
60(3)
Defining Columns
60(2)
Viewing List of Tables: User_Tables
62(1)
Viewing Table Structures: Describe
63(1)
Table Creation Through Subqueries
63(3)
Create Table...As
64(2)
Modifying Existing Tables
66(11)
Alter Table...Add Command
67(1)
Alter Table...Modify Command
68(3)
Alter Table...Drop Column Command
71(1)
Alter Table...Set Unused/Drop Unused Columns Command
72(1)
Renaming a Table
73(2)
Truncating a Table
75(2)
Deleting a Table
77(3)
Chapter Summary
80(1)
Chapter 3 Syntax Summary
81(1)
Review Questions
82(4)
Hands-On Assignments
86(1)
Advanced Challenge
87(1)
Case Study: City Jail
87(4)
Constraints
91(34)
Creating Constraints
93(2)
Creating Constraints at the Column Level
94(1)
Creating Constraints at the Table Level
94(1)
Using the Primary Key Constraint
95(3)
Using the Foreign Key Constraint
98(4)
Using the Unique Constraint
102(1)
Using the Check Constraint
103(2)
Using the Not Null Constraint
105(1)
Including Constraints During Table Creation
106(3)
Multiple Constraints on a Single Column
109(1)
Viewing Constraints
109(2)
Disabling and Dropping Constraints
111(1)
Using Disable/Enable
111(1)
Dropping Constraints
112(3)
Chapter Summary
115(1)
Syntax Summary
116(2)
Review Questions
118(4)
Hands-On Assignments
122(2)
Advanced Challenge
124(1)
Case Study: City Jail
124(1)
Data Manipulation and Transaction Control
125(32)
Inserting New Rows
126(9)
Insert Command
127(4)
Constraint Violations
131(2)
Inserting Data from an Existing Table
133(2)
Modifying Existing Rows
135(2)
Update command
135(2)
Substitution Variables
137(3)
Deleting Rows
140(2)
Transaction Control Statements
142(3)
Commit and Rollback Commands
142(3)
Table Locks
145(3)
Lock Table command
146(1)
Select...For Update Command
146(2)
Chapter Summary
148(1)
Syntax Summary
149(1)
Review Questions
149(4)
Hands-On Assignments
153(1)
Advanced Challenge
154(1)
Case Study: City Jail
155(2)
Additional Database Objects
157(36)
Sequences
159(10)
Creating a Sequence
160(5)
Using Sequence Values
165(2)
Altering Sequence Definitions
167(2)
Removing a Sequence
169(1)
Indexes
169(11)
B-tree Index
171(4)
Bitmap Indexes
175(1)
Function-based Indexes
176(1)
Index Organized Tables
177(1)
Verifying an Index
178(1)
Removing an Index
179(1)
Synonyms
180(4)
Deleting a Synonym
181(3)
Chapter Summary
184(1)
Syntax Summary
185(1)
Review Questions
186(1)
Multiple Choice
186(4)
Hands-On Assignments
190(1)
Advanced Challenge
191(1)
Case Study: City Jail
192(1)
User Creation and Management
193(30)
Data Security
195(1)
Creating a User
196(2)
Creating User Names and Passwords
196(2)
Assigning User Privileges
198(4)
System Privileges
198(1)
Granting System Privileges
198(2)
Object Privileges
200(1)
Granting Object Privileges
200(2)
Password Management
202(2)
Utilizing Roles
204(6)
Creating and Assigning Roles
205(2)
Predefined Roles
207(1)
Default Roles
208(1)
Enabling Roles After Login
209(1)
Viewing Privilege Information
210(2)
Removing Privileges and Roles
212(3)
Revoking Privileges and Roles
212(1)
Dropping a Role
213(1)
Dropping a User
213(2)
Chapter Summary
215(1)
Syntax Summary
216(1)
Review Questions
217(1)
Multiple Choice
217(4)
Hands-On Assignments
221(1)
Advanced Challenge
221(1)
Case Study: City Jail
222(1)
Restricting Rows and Sorting Data
223(36)
Where Clause Syntax
224(4)
Rules for Character Strings
226(1)
Rules for Dates
227(1)
Comparison Operators
228(9)
Between ...And Operator
234(1)
In Operator
235(1)
Like Operator
236(1)
Logical Operators
237(3)
Treatment of Null Values
240(3)
Order By Clause Syntax
243(6)
Secondary Sort
245(2)
Sorting by Select Order
247(2)
Chapter Summary
249(1)
Syntax Summary
250(1)
Review Questions
251(1)
Multiple Choice
251(5)
Hands-On Assignments
256(1)
Advanced Challenge
256(1)
Case Study: City Jail
257(2)
Joining Data from Multiple Tables
259(44)
Cartesian Joins
261(5)
Cartesian Join---Traditional Method
262(2)
Cartesian Join---Join Method
264(2)
Equality Joins
266(10)
Equality Joins---Traditional Method
267(4)
Equality Joins---Join Method
271(5)
Non-Equality Joins
276(3)
Non-Equality Joins---Traditional Methods
277(1)
Non-Equality Joins---Join Method
277(2)
Self-Joins
279(2)
Self-Joins---Traditional Method
280(1)
Self-Joins---Join Method
280(1)
Outer Joins
281(4)
Outer Joins---Traditional Method
282(2)
Outer Joins---Join Method
284(1)
Set Operators
285(5)
Chapter Summary
290(1)
Syntax Summary
291(2)
Review Questions
293(1)
Multiple Choice
294(5)
Hands-On Assignments
299(1)
Advanced Challenge
300(1)
Case Study: City Jail
300(3)
Selected Single-Row Functions
303(48)
Case Conversion Functions
305(3)
Lower Function
305(2)
Upper Function
307(1)
Initcap Function
307(1)
Character Manipulation Functions
308(10)
Substr Function
308(2)
Instr Function
310(2)
Length Function
312(1)
Lpad and Rpad Functions
313(1)
Ltrim and Rtrim Functions
314(1)
Replace Function
314(1)
Translate Function
315(2)
Concat Function
317(1)
Number Functions
318(3)
Round Function
318(1)
Trunc Function
319(1)
Mod Function
320(1)
ABS Function
320(1)
Date Functions
321(7)
Months_Between Function
322(1)
Add_Months Function
323(1)
Next_Day Function
324(1)
To_Date Function
324(1)
Round Function
325(1)
Trunc Function
326(1)
Current_Date Versus Sysdate
327(1)
Regular Expressions
328(3)
Other Functions
331(9)
NVL Function
331(2)
NVL2 Function
333(1)
To_Char Function
333(2)
Decode Function
335(3)
Soundex Function
338(1)
To_Number Function
339(1)
Dual Table
340(1)
Chapter Summary
341(1)
Syntax Summary
341(3)
Review Questions
344(1)
Multiple Choice
345(4)
Hands-On Assignments
349(1)
Advanced Challenge
349(1)
Case Study: City Jail
350(1)
Group Functions
351(40)
Group Functions
353(7)
Sum Function
354(1)
Avg Function
355(1)
Count Function
356(2)
Max Function
358(1)
Min Function
359(1)
Grouping Data
360(3)
Restricting Aggregated Output
363(1)
Nesting Functions
364(1)
Statistical Group Functions
365(3)
Stddev Function
365(2)
Variance Function
367(1)
Enhanced Aggregation for Reporting
368(13)
Grouping Sets
370(2)
Cube
372(2)
Rollup
374(7)
Chapter Summary
381(1)
Syntax Summary
381(2)
Review Questions
383(1)
Multiple Choice
384(4)
Hands-On Assignments
388(1)
Advanced Challenge
389(1)
Case Study: City Jail
389(2)
Subqueries and Merge
391(42)
Subqueries and Their Uses
392(1)
Single-Row Subqueries
393(7)
Single-Row Subquery in a Where Clause
393(4)
Single-Row Subquery in a Having Clause
397(1)
Single-Row Subquery in a Select Clause
398(2)
Multiple-row Subqueries
400(9)
In Operator
400(1)
All and Any Operators
401(5)
Exists Operator
406(2)
Multiple-Row Subquery in a Having Clause
408(1)
Multiple-column Subqueries
409(3)
Multiple-Column Subquery in a From Clause
409(2)
Multiple-Column Subquery in a Where Clause
411(1)
Null Values
412(5)
NVL in Subqueries
413(1)
Is Null in Subqueries
413(2)
Correlated Subqueries
415(2)
Nested Subqueries
417(1)
Merge Statement
418(4)
Chapter Summary
422(1)
Syntax Summary
423(1)
Review Questions
424(1)
Multiple Choice
424(6)
Hands-On Assignments
430(1)
Advanced Challenge
430(1)
Case Study: City Jail
431(2)
Views
433(34)
Creating a View
436(8)
Creating a Simple View
438(2)
DML Operations on a Simple View
440(4)
Creating a Complex View
444(9)
DML Operations on a Complex View with an Arithmetic Expression
444(3)
DML Operations on a Complex View Containing Data from Multiple Tables
447(3)
DML Operations on a Complex View Containing Functions or Grouped Data
450(1)
DML Operations on a Complex View Containing Distinct or Rownum
451(2)
Summary Guidelines of DML Operations on a Complex View
453(1)
Dropping a View
453(1)
Creating an Inline View
454(2)
``Top-N'' Analysis
454(2)
Materialized Views
456(3)
Chapter Summary
459(1)
Syntax Summary
459(1)
Review Questions
460(5)
Hands-On Assignments
465(1)
Advanced Challenge
465(1)
Case Study: City Jail
466(1)
Formatting Readable Output
467(36)
Column Command
469(11)
Format Option
470(5)
Heading Option
475(3)
Null Option
478(2)
Headers and Footers
480(5)
Linesize
481(2)
Pagesize
483(2)
Break Command
485(2)
Clear Command
487(1)
Compute Command
488(2)
Spool Command
490(1)
HTML Output
491(2)
Chapter Summary
493(1)
Syntax Summary
494(2)
Review Questions
496(1)
Multiple Choice
496(4)
Hands-On Assignments
500(1)
Advanced Challenge
500(1)
Case Study: City Jail
501(2)
Exploring SQL topics in Application Development
503(24)
SQL in Application code
504(2)
Tuning Concepts and Issues
506(10)
Identifying Problem Areas in Coding
507(1)
Processing and the Optimizer
508(2)
The Explain Plan
510(5)
Timing Feature
515(1)
Selected SQL Tuning Guidelines and Examples
516(7)
Avoiding Unnecessary Column Selection
517(1)
Index Suppression
518(2)
Concatenated Indexes
520(1)
Subqueries
521(1)
Optimizer Hints
521(2)
Using SQL With different Databases
523(3)
Unduplicate rows
523(1)
Locate value within String
523(1)
Current Date
524(1)
Default Date Format
524(1)
Null Value Replacement for Text Data
524(1)
Add Time to Dates
525(1)
Extracting Values from a String
525(1)
Concatenation
525(1)
Data Structures
526(1)
Chapter Summary
526(1)
Appendix A
527(6)
Tables for the JustLee Books Database
527(6)
Customers Table
527(1)
Books Table
528(1)
Orders Table
528(1)
Orderitems Table
529(1)
Author Table
530(1)
Bookauthor Table
531(1)
Publisher Table
532(1)
Promotion Table
532(1)
Appendix B SQL Plus and iSQL Plus User's Guide
533(16)
Client SQL Plus
533(4)
Connecting to Oracle
533(4)
iSQL Plus
537(7)
Connecting to i SQL Plus
537(3)
Loading a Script
540(1)
History Feature
541(1)
Preferences
542(1)
Help
543(1)
iSQL Plus Versus Client SQL Plus
544(5)
The @ or Start Command
544(1)
Text Output Option
544(5)
Appendix C SQL Syntax Guide
549(20)
Appendix D Introduction to the Toad Third-Party Tool
569(4)
Toad
570(3)
Appendix E
573(22)
Oracle 10g Practice Exams (A--E)
573(22)
Practice Exam A
573(4)
Practice Exam B
577(6)
Practice Exam C
583(4)
Practice Exam D
587(5)
Practice Exam E
592(3)
Appendix F
595(2)
Oracle Resources
595(2)
Oracle Academic Initiative (OAI)
595(1)
Oracle Certification Program (OCP)
595(1)
Oracle Technology Network (OTN)
595(1)
International Oracle Users Group (IOUG)
595(2)
Appendix G SQL Loader
597(4)
Read a Fixed Format File
598(2)
Read a Delimited File
600(1)
Glossary 601(6)
Index 607


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