This title includes: Section - I: Setting Up Oracle 9i, Database Concepts, Installation Of Oracle 9i, Post Installation Steps, Setting Up Interactive Sql Plus, Section - Ii: Setting Up The Business Model, A Business Model For Retail Banking, Project Planning For The Retail Banking Model, Section - Iii: Structured Query Language (Sql), Interactive Sql Part-I, Interactive Sql Part - Ii, Interactive Sql Part - Iii, Interactive Sql Part - Iv, Section - Iv: Advance Sql, Sql Performance Tuning, Security Management Using Sql, Oops In Oracle, Advance Features In Sql Plus, Section - V: Pl / Sql, Introduction To Pl/Sql, Pl / Sql Transactions, Pl/Sql Security, and, Pl/Sql Database Objects.

The book also several illustrative examples, which have a logical link between them.There are objective and subjective illustrative questions raised at the end of various chapters to help revise the material studied.The examples in this material will help build strong DBMS skills. This will develop a great deal of confidence in the use of SQL & PL/SQL.Contents:Chapter 1: Introductory Concepts of DBMSChapter 2: Relational ModelChapter 3: Entity Relationship ModelChapter 4: Relational Database DesignChapter 5: Query Processing and Query OptimizationChapter 6: Transaction ManagementChapter 7: SecurityChapter 8: SQL ConceptsChapter 9: PL/SQL Concept

There are also Hands on exercises and their solutions to support the illustrative examples.andEach set of examples and their associated Hands on exercises helps build skills that will take the reader to the next set of examples, which in turn lead upwards untill a great deal of confidence has been established in the use of SQL & PL/SQL.andThe topics covered are:Database ConceptsClient/Server ComputingRDBMS TechnologiesCODD's RulesData ModelsNormalization TechniquesER DiagramsData Flow DiagramsData integrity Data Security