Oracle9iTM DBA JumpStartTM

by
Format: Paperback
Pub. Date: 2003-03-01
Publisher(s): Sybex
List Price: $24.99

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Get Up to Speed for Oracle9i Administration Training Courses--Fast! Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL*Plus and iSQL*Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL*Plus reporting techniques * Creating and maintaining database objects * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting

Author Biography

Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin.

Table of Contents

Introduction xii
Relational Database Concepts
1(11)
Are Spreadsheets Like Databases?
2(1)
Relational Databases
3(6)
Tables, Rows, and Columns
4(1)
Primary Keys, Datatypes, and Foreign Keys
5(1)
Data Modeling
6(3)
Object-Relational Databases
9(3)
Abstraction
9(1)
Methods and Encapsulation
10(1)
Inheritance
10(1)
Object-Relational Support
10(2)
SQL*Plus and iSQL*Plus Basics
12(32)
Some SQL Formalities
14(1)
Tools for Running SQL
14(11)
SQL*Plus
15(3)
iSQL*Plus
18(3)
SQL*Plus Worksheet
21(1)
Third-Party Tools
22(1)
ODBC/JDBC
22(2)
OCI
24(1)
The Ubiquitous SELECT Statement
25(4)
Column Specification
25(2)
Column Renaming
27(1)
Duplicate Removal
27(1)
Expressions
28(1)
DML for Making Changes
29(5)
The UPDATE Statement
30(2)
The INSERT Statement
32(1)
The DELETE Statement
33(1)
The MERGE Statement
34(1)
DDL for Handling Database Objects
34(6)
The CREATE Statement
35(2)
The ALTER Statement
37(1)
The DROP Statement
38(1)
The RENAME Statement
38(1)
The TRUNCATE Statement
39(1)
DCL for Handling Privileges
40(4)
The GRANT Statement
40(1)
The REVOKE Statement
41(3)
Oracle Database Functions
44(26)
Query Basics
46(6)
The DUAL Table
46(2)
NULLs: What, When, Why, and How
48(1)
String Literals and Concatenating Strings
49(1)
Numeric Literals
50(1)
Operators and Operator Precedence
50(2)
Built-in Single-Row Functions
52(13)
String Functions
52(3)
Numeric Functions
55(3)
Date Functions
58(2)
Conversion Functions
60(2)
General Functions
62(3)
User-Defined Functions
65(5)
Restricting, Sorting, and Grouping Data
70(24)
The WHERE Clause
72(11)
Comparison Conditions
72(2)
And, Or, and Not
74(2)
Between, In, and Like
76(5)
Is Null and Is Not Null
81(2)
The Order By Clause
83(2)
Group Functions and the Group By Clause
85(9)
Group Functions
85(2)
The Group By Clause
87(2)
Using NVL with Group Functions
89(1)
The Having Clause
90(4)
Using Multiple Tables
94(24)
Join Syntax: Out with the Old and In with the New (SQL:1999)
96(1)
Equijoins
96(7)
Pre-Oracle9i Equijoin Syntax
97(2)
Oracle9i Equijoin Syntax
99(4)
Non-equijoins
103(2)
Pre-Oracle9i Non-equijoin Syntax
103(1)
Oracle9i Non-equijoin Syntax
104(1)
Outer Joins
105(6)
Pre-Oracle9i Outer Join Syntax
105(3)
Oracle9i Outer Join Syntax
108(3)
Self-Joins
111(3)
Pre-Oracle9i Self-Join Syntax
112(1)
Oracle9i Self-Join Syntax
113(1)
Cartesian Products: The Black Sheep of the Family
114(4)
Pre-Oracle9i Cartesian Product Syntax
114(1)
Oracle9i Cartesian Product Syntax
115(3)
Advanced SQL Queries
118(22)
Subqueries
120(6)
Single-Row Subqueries
120(1)
Multiple-Row Subqueries
121(2)
Correlated Subqueries
123(2)
Multiple-Column Subqueries
125(1)
Set Operators
126(8)
Union and Union All
126(4)
Intersect
130(2)
Minus
132(2)
Rollup and Cube
134(6)
Rollup
135(1)
Cube
136(4)
Logical Consistency
140(16)
Constraints
142(9)
Not Null
142(2)
Check
144(2)
Unique
146(1)
Primary Key
147(2)
Foreign Key
149(2)
Transaction Processing
151(5)
The Commit Statement
152(1)
The Rollback Statement
153(1)
The Savepoint Statement
154(2)
Installing Oracle and Creating a Database
156(22)
Oracle Components Overview
158(8)
Logical Storage Structures
158(2)
Physical Storage Structures
160(2)
Oracle Memory Structures
162(3)
Background Processes
165(1)
Installing Oracle Software
166(5)
Using the Oracle Universal Installer
166(3)
Using the Oracle Enterprise Manager and Tools
169(2)
Creating an Oracle Database
171(7)
Disk and Memory Requirements
171(1)
Using the Database Configuration Assistant
171(7)
Reporting Techniques
178(22)
iSQL*Plus Configuration
180(4)
Interface Options
180(2)
System Variables
182(2)
Change Password
184(1)
Report Formatting
184(8)
Headers and Footers
185(3)
Column Formatting
188(1)
Break Processing
189(2)
Summary Operations (Totals)
191(1)
Substitution Variables
192(3)
Saving and Running Scripts
195(5)
Creating and Maintaining Database Objects
200(22)
Creating Tables
202(6)
Relational Tables
202(1)
Create Table As Select (CTAS)
203(2)
External Tables
205(3)
Temporary Tables
208(1)
Creating Indexes
208(2)
Creating and Using Views
210(7)
User-Defined Views
210(2)
Data Dictionary Views
212(3)
Dynamic Performance Views
215(2)
Creating Sequences and Synonyms
217(5)
Sequences
217(2)
Synonyms
219(3)
Users and Security
222(18)
Creating User Accounts
224(3)
Assigning Passwords
224(1)
Creating and Assigning Profiles
225(1)
Assigning Default Tablespaces and Quotas
226(1)
Granting and Revoking Privileges
227(7)
System Privileges
228(1)
Object Privileges
229(3)
Creating and Assigning Roles
232(2)
Auditing
234(6)
Statement Auditing
234(2)
Object Auditing
236(4)
Making Things Run Fast (Enough)
240(26)
Oracle's Tuning Methodology
242(1)
Indexes
243(8)
When to Create Indexes
243(1)
Index Types
244(3)
Creating, Dropping, and Maintaining Indexes
247(1)
Monitoring Indexes
248(2)
Data Dictionary Index Information
250(1)
Data Design Tuning
251(5)
Partitioned Tables
251(3)
Materialized Views
254(2)
SQL Application Tuning
256(5)
Top SQL Tool
256(1)
Explain Plan Graphical Tool
257(1)
The Oracle Optimizer
258(3)
Memory Tuning
261(5)
Saving Your Stuff (Backups)
266(22)
Database Failures
268(1)
User Backup and Recovery Methods
268(8)
Export and Import for Users
269(4)
Flashback Query
273(3)
DBA Backup and Recovery Methods
276(12)
Export and Import for DBAs
276(5)
Cold Backups
281(1)
Hot Backups
281(1)
Log Miner
282(2)
Recovery Manager
284(4)
Troubleshooting
288(15)
The Alert Log File
290(3)
Locating the Alert Log File
290(1)
Viewing the Alert Log File
291(1)
Maintaining the Alert Log File
291(2)
OEM's Event Manager
293(3)
System Trace Files
296(1)
User Trace Files
297(6)
Enabling Tracing
298(1)
Locating the User Trace Files
298(2)
Converting the Trace File
300(3)
Appendix A Answers to Review Questions
303(12)
Chapter 1
304(1)
Chapter 2
304(1)
Chapter 3
305(1)
Chapter 4
306(1)
Chapter 5
307(1)
Chapter 6
307(1)
Chapter 7
308(1)
Chapter 8
309(1)
Chapter 9
309(1)
Chapter 10
310(1)
Chapter 11
311(1)
Chapter 12
312(1)
Chapter 13
312(1)
Chapter 14
313(2)
Appendix B Glossary
315(12)
Appendix C Common Database Platforms
327(4)
Index 331

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.