Table of Contents
Most chapters end with In a Nutshell, Exercise Questions, and a Lab Activity.
I. DATABASE CONCEPTS. 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.
II. THE ORACLE SQL. 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.
III. PL/SQL. 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.
IV. MISCELLANEOUS TOPICS. 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.Index.
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.