| |
The Topics Covered
* THE PURPOSE OF DATABASE SYSTEMS: Basic Database Concepts
* ENTITY RELATIONSHIPS MODELLING: E.R. Database Schemas
* THE RELATIONAL MODEL: Relational Algebra, Tuple Relational Calculus
* STRUCTURED QUERY LANGUAGE: Table Fundamentals, ANSI SQL Statements (DDL, DML, DQL, DCL), Data Constraints, The SET Operations, Views
* SQL TRANSACTIONS: Reversing Transactions, Cursors-Implicit And Explicit
* CONCURRENCY CONTROLS: Locking Protocol, Deadlock Handling, Locks
* QUERY OPTIMIZATION: Query Executed, EXPLAIN PLAN Command
* RELATIONAL DATABASE DESIGN: Decomposition And Normalization
* OTHER RELEVANT ADVANCED TOPICS AND APPLICATIONS
* ORACLE - FORMS: Creating A Data Entry Form Via The Forms Builder
* ORACLE - REPORTS: Creating A Report Via The Reports Builder.
Each topic is liberally sprinkled with examples that are mapped to applications, which fit in the real world. At the end of each chapter there is a material review section consisting of Fill in the blanks and True or False questions. This should help in providing a quick but accurate way of measuring how the material has been absorbed.
Where applicable each chapter has several Hands-on exercises. These exercises will help reinforce the concepts studied. The solutions to these hands-on exercises have also been provided at the very end of the book.
|
| |
|