Skip to content

Oracle SQL by Example

Best in textbook rentals since 2012!

ISBN-10: 0137142838

ISBN-13: 9780137142835

Edition: 4th 2010

Authors: Alice Rischert

List price: $90.95
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!

The best hands-on guide to Oracle SQL - now updated for Oracle 11gand reorganized for even faster learning° Classroom-tested worldwide! Teaches Oracle SQL through hundreds of practical labexercises crafted by one of the world's leading database instructors° 100% focused on Oracle SQL for Oracle 11g, today's #1 database platform -- not"generic" SQL!° Reflects key Oracle 11g innovations, including new data warehousing features° Supported by a thorough, highly-useful web siteSummaryOracle users, administrators, and developers don't want to settle for a genericSQL guide: they need one that helps them make the most of Oracle'simplementation of SQL. For years, Alice Rischert's Oracle SQL by…    
Customers also bought

Book details

List price: $90.95
Edition: 4th
Copyright year: 2010
Publisher: Prentice Hall PTR
Publication date: 9/10/2009
Binding: Paperback
Pages: 960
Size: 7.00" wide x 9.10" long x 2.00" tall
Weight: 3.278

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.

SQL and Data
SQL: The Basics
Character, Number, and Miscellaneous Single-Row Functions
Date and Conversion Functions
Aggregate Functions, Group By, And Having
Equijoins
Complex Joins
Subqueries
Set Operators
Insert, Update, and Delete
Create, Alter, and Drop Tables
Views, Indexes, and Sequences
The Data Dictionary and Advanced SQL Scripts
Security
Regular Expressions and Hierarchical Queries
Exploring Data Warehousing Features
SQL Optimization
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