Australasia's Biggest Online Store

New Zealand's Lowest Prices. Guaranteed

Database Systems Using Oracle


Product Description
Product Details

Table of Contents

Most chapters end with In a Nutshell, Exercise Questions, and a Lab Activity.


1. Database Concepts: A Relational Approach.

Database: An Introduction. Relationships. Database Management System (DBMS). The Relational Database Model. Integrity Rules. Theoretical Relational Languages.

2. Database Design: Data Modeling and Normalization.

Data Modeling. Dependency. Database Design. Normal Forms. Dependency Diagrams. Denormalization.


3. Oracle 8: An Overview.

Personal Databases. Client/Server Databases. Oracle 8: An Introduction. The SQL*Plus Environment. Structured Query Language. Logging In to SQL*Plus. SQL*Plus Commands. Sample Databases. Alternate Text Editors. Oracle Online Help.

4. Oracle Tables: Creation and Modification.

Naming Conventions. Data Types. Constraints. Creating an Oracle Table. Displaying Table Information. Altering an Existing Table. Dropping a Table. Renaming a Table. Truncating a Table. Spooling.

5. Working with Tables: Data Management and Retrieval.

Adding a New Row/Record. Customized Prompts. Updating Existing Rows/Records. Deleting Existing Rows/Records. Dropping a Constraint. Disabling/Enabling Constraints. Retrieving Data from a Table. Arithmetic Operations. Restricting Data with a WHERE Clause. Sorting. Built-in Functions. Grouping Data. Nesting Group Functions. Revisiting Substitution Variables. DEFINE Command.

6. Multiple Tables: Joins and Sub-Queries.

Join. Set Operators. Sub-Query. Top-N Analysis.

7. Advanced Features: Objects, Transactions, and Control.

Views. Sequences. Synonyms. Index. Transactions. Locking Rows for Update. Controlling Access. SQL Review: Supplementary Examples.


8. PL/SQL: Programming Language Basics.

A Brief History of PL/SQL. Fundamentals of PL/SQL. PL/SQL Block Structure. Comments. Data Types. Other Scalar Data Types. Variable Declaration. Anchored Declaration. Assignment Operation. Bind Variables. Substitution Variables in PL/SQL. Printing in PL/SQL. Arithmetic Operators.

9. SQL and Control Structures in PL/SQL.

Control Structures. Nested Blocks. SQL in PL/SQL. Data Manipulation in PL/SQL. Transaction Control Statements.

10. Cursors and Exceptions.

Cursors. Implicit Cursors. Explicit Cursors. Explicit Cursor Attributes. Implicit Cursor Attributes. Cursor FOR Loops. SELECT . . . FOR UPDATE Cursor. WHERE CURRENT OF Clause. Cursor with Parameters. Cursor Variables: An Introduction. Exceptions. Types of Exceptions. Sample Programs.

11. Composite Data Types: Records and Tables.

Composite Data Types. PL/SQL Records. PL/SQL Tables. Sample Programs.

12. Procedures, Functions and Packages.

Procedures. Functions. Packages.


13. Oracle Database Administration.

Database Administrator (DBA). Oracle Architecture: An Overview. Installation. Networking. Security. System Privileges. Roles. Users. Oracle Tools. SQL*Plus. Oracle Data Dictionary.

14. Oracle 8i: An Overview and Web Tools.

Oracle8i Core Package. An Object. SQL Queries for Objects. Internet Computing and Oracle8i. WebDB. JDeveloper.

Appendix A: Sample Databases: Table Definitions.

The Indo-US College Student Database. The NamanNavan Corporation College Database.

Appendix B: Quick Reference to SQL & PL/SQL Syntax.
Appendix C: Additional References.

Web Sites. Books and Other Published Material on Oracle.


About the Author

Nilesh Shah, Ph.D., has been teaching for more than a decade. He is currently an Assistant Professor at the New Jersey campus of DeVry. He also works as a systems analyst at Monroe College, New York. Dr. Shah is associated with many prestigious technology companies as a freelance consultant.

Ask a Question About this Product More...
Write your question below:
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by, Inc.
Back to top