Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Purchase Benefits
What is included with this book?
Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters.
Critical Database Concepts | |
Oracle Database 11gArchitecture Options | |
Installing Oracle Database 11gand Creating a Database | |
Upgrading to Oracle Database 11g | |
Planning Oracle Applicationsn++Approaches, Risks, and Standards | |
SQL and SQL*Plus | |
The Basic Parts of Speech in SQL | |
Basic SQL*Plus Reports and Commands | |
Getting Text Information and Changing It | |
Searching for Regular Expressions | |
Playing the Numbers | |
Dates: Then, Now, and the Difference | |
Conversion and Transformation Functions | |
Grouping Things Together | |
When One Query Depends upon Another | |
Some Complex Possibilities | |
Changing Data: insert, update, merge, and delete | |
DECODE and CASE: if, then, and else in SQL | |
Creating and Managing Tables, Views, Indexes, Clusters, and Sequences | |
Partitioning | |
Basic Oracle Security | |
Beyond the Basics | |
Advanced Securityn++Virtual Private Databases | |
Advanced Security: Transparent Data Encryption | |
Working with Tablespaces | |
Using SQL*Loader to Load Data | |
Using Data Pump Export and Import | |
Accessing Remote Data | |
Using Materialized Views | |
Using Oracle Text for Text Searches | |
Using External Tables | |
Using Flashback Queries | |
Flashbackn++Tables and Databases | |
SQL Replay | |
PL/SQL | |
An Introduction to PL/SQL | |
Online Application Upgrades | |
Triggers | |
Procedures, Functions, and Packages | |
Using Native Dynamic SQL and DBMS_SQL | |
PL/SQL Tuning | |
Object-Relational Databases | |
Implementing Types, Object Views, and Methods | |
Collectors (Nested Tables and Varying Arrays) | |
Using Large Objects | |
Advanced Object-Oriented Concepts | |
Java in Oracle | |
An Introduction to Java | |
JDBC Programming | |
Java Stored Procedures | |
Hitchhiker's Guides | |
The Hitchhiker's Guide to Oracle Data Dictionary | |
The Hitchhiker's Guide to Tuning Applications and SQL | |
SQL Result Cache and Client-Side Query Cache | |
Case Studies in Tuning | |
Advanced Architecture Options--DB Vault, Content DB, and Records DB | |
Oracle Real Application Clusters | |
The Hitchhikern++s Guide to Database Administration | |
The Hitchhikern++s Guide to XML in Oracle | |
Alphabetical | |
Reference | |
Index | |
Table of Contents provided by Publisher. All Rights Reserved. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.