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.
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.