Skip to content

Oracle SQL by Example

Spend $50 to get a free DVD!

ISBN-10: 0131451316

ISBN-13: 9780131451315

Edition: 3rd 2004 (Revised)

Authors: Alice Rischert

List price: $69.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Oracle SQL by Example, Third Edition is a convenient, quick way to master Oracle SQL. This unique integrated book-and-Web learning solution teaches all the SQL skills you will need to succeed in an Oracle environment. Through hands-on, real-world labs, exercises, projects, and a superb Web-based training site, the book teaches administrators and programemrs alike the core skills required for their jobs. Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions. Each chapter contains review exercises that help the reader master the important skills before they move on.
Customers also bought

Book details

List price: $69.99
Edition: 3rd
Copyright year: 2004
Publisher: Prentice Hall PTR
Publication date: 6/17/2004
Binding: Paperback
Pages: 960
Size: 6.75" wide x 9.00" long x 1.50" tall
Weight: 2.948
Language: English

Alice Rischert, formerly chair of Columbia University�s Database Application Development and Design program, has taught classes in Oracle SQL, PL/SQL, and database design to hundreds of students. Ms. Rischert�s wide-ranging technology experience encompasses systems integration, database architecture, and project management for a number of companies in the United States, Europe, and Asia. Ms. Rischert has presented on SQL and PL/SQL topics at Oracle conferences and has worked with Oracle since version 5.

(Note:Each chapter concludes with Test Your Thinking.) Foreword
Acknowledgments
About the Author
Introduction
Sql and Data
Data, Databases, and the Definition of sql
Table Relationships
The Student Schema Diagram
Sql: The Basics
The Sql*Plus Environment
The Anatomy of a Select Statement
Editing a Sql Statement
The Where Clause: Comparison and Logical Operators
The Order By Clause
Character, Number, and Miscellaneous Functions
Character Functions
Number Functions
Miscellaneous Single-Row Functions
Date and Conversion Functions
Applying Oracle's Date Format Models
Performing Date and Time Math
Understanding Timestamp and Time Zone Datatypes
Performing Calculations with the Interval Datatypes
Converting from One Datatype to Another
Aggregate Functions, Group By, and Having
Aggregate Functions
The Group by and Having Clauses
Equijoins
The Two-Table Join
Joining Three or More Tables
Subqueries
Simple Subqueries
Correlated Subqueries
Inline Views and Scalar Subquery Expressions
Any, Some, and All Operators in Subqueries
Set Operators
The Power of Union and Union All
The Minus and Intersect Set Operators
Complex Joins
Outer Joins
Self-Joins
Insert, Update, and Delete
Creating Data and Transaction Control
Updating and Deleting Data
Create, Alter, and Drop Tables
Creating and Dropping Tables
Altering Tables and Manipulating Constraints
Views, Indexes, and Sequences
Creating and Modifying Views
Indexes
Sequences
The Data Dictionary and Advanced Sql*Plus Commands
The Oracle Data Dictionary Views
Advanced Sql*Plus Commands
Security
Users, Privileges, Roles, and Synonyms
Regular Expressions and Hierarchical Queries
Regular Expressions
Hierarchical Queries
Exploring Data Warehousing Features
Advanced Sql Concepts, Analytical Functions, and the with Clause
Rollup and Cube Operators
Sql Optimization
The Oracle Optimizer and Writing Effective Sql Statements
Answers to Self-Review Questions
SQL Formatting Guide
SQL*Plus Command Reference
Student Database Schema
Table and Column Descriptions
Additional Example Tables
Navigating through the Oracle Documentation
Resources
Oracle Datatypes
Index