Database Systems Using Oracle

Name: Database Systems Using Oracle
Price: 23.21 USD
Availability: InStock
ISBN: 9780131018570

ISBN-10: 0131018574

ISBN-13: 9780131018570

Edition: 2nd 2004

Authors: Nilesh Shah

List price: $193.32

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $23.21

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and introduction to advanced SQL topics makes this a must for busy professionals. The many examples, with output shown as screenshots, provide ample opportunity for the reader to easily understand and learn to use Oracle and SQL.First introducing relational database concepts, the book covers SQL (Structured Query Language); Programming Language (the extension to SQL); and then proceeds to advanced topics, which include Oracle architecture and database administration with enterprise tools.For any IT…

Book details

List price: $193.32
Edition: 2nd
Copyright year: 2004
Publisher: Pearson Education
Publication date: 5/13/2004
Binding: Paperback
Pages: 456
Size: 7.00" wide x 9.10" long x 0.70" tall
Weight: 1.430
Language: English




Relational Database Concepts



Database Concepts: A Relational Approach



Database Design: Data Modeling and Normalization



Oracle Sql



Oracle 9i: An Overview



Oracle Tables: Data Definition Language (DDL)



Working with Tables: Data Manipulation and Retrieval



Working with Tables: Functions and Grouping



Multiple Tables: Joins and Set Operators



Subqueries: Nested Queries



Advanced Features: Objects, Transactions, and Data Control


SQL Review: Review of SQL Statements Covered in Chapters 3-9 with a Sample Database



PL/SQL



PL/SQL: A Programming Language



More on PL/SQL: Control Structures and Embedded SQL



Cursors and Exceptions



PL/SQL Composite Data Types: Records, Tables, and Varrays



PL/SQL Named Blocks: Procedure, Function, Package, and Trigger



Advanced Topics



Connecting to Oracle Database: JDBC, SQLJ



Oracle 9i Architecture and Administration



Sample Databases Table Definitions



Quick Reference to SQL & PL/SQL Syntax



Reference to SQL*Plus Commands



Object Orientation with Oracle



Additional References Websites and Books