Database Systems Using Oracle

Name: Database Systems Using Oracle
Availability: OutOfStock
ISBN: 9780131911802

ISBN-10: 0131911805

ISBN-13: 9780131911802

Edition: N/A

Authors: Nilesh Shah

30 day, 100% satisfaction guarantee!

Out of stock

We're sorry. This item is currently unavailable.

what's this?

Rush Rewards U
Members Receive:

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

For Database Systems courses focusing on SQL and/or Oracle, Oracle and SQL courses offered in the departments of Computer Science, CIS, MIS, IT, and Continuing Education. Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a valuable future reference. Part IV, Advanced Topics, allows students to further…

Book details

Publisher: Prentice Hall
Pages: 456
Size: 6.00" wide x 7.85" long x 0.61" tall
Weight: 1.232




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