The second edition of this book provides a complete guide to the practical implementation of DBMS concepts including SQL, Oracle, Oracle Administration, PL/SQL development Forms and Reports using Oracle and developer 2000. This book assumes no prior knowledge by reader on the subject. It is very useful for B.E., B.Tech, B.C.A, PGDCA, PGDIT, MCA, B.Sc (CSE/IT), M.I.T, M.B.A and M.Tech of all universities, computer institutes and also DOEACC students of O, A & B levels.
Additional Info
  • Publisher: Laxmi Publications
  • Language: English
  • Chapter 1

    Introduction Price 2.99  |  2.99 Rewards Points

    Objectives:

    • DBMS & RDBMS
    • Codd's Rules for a Fully Relational DBMS
    • Introduction of Various Types of Keys of DBMS
    • Different Types of Relationships
    • Introduction to DDL, DML & DCL
      Exercise
  • Chapter 2

    Getting Started Price 2.99  |  2.99 Rewards Points

    • Introduction to Oracle
    • Oracle File Structure
    • SQL vs SQL *Plus
    • Various Data Types of Oracle
    • Creating a Table
    • Reserved Words of SQL
    • Constraints
    • Inserting Rows to the Table
    • Sequence
    • To View the Rows in the Table
    • Where Clause
    • Rownum
    • To Delete Rows From a Table
    • Commit Statement
    • The Rollback Statement
    • The Savepoint Statement
    • The Set Transaction Statement
    • The Lock Table Statement
    • To Update Rows in the Table
    • Operators in SQL *Plus
    • Not in
    • Between
    • Not Like
    • Order By
    • Column Aliases
    • Column Format
    • Some Important Commands
      Lab Assignment - 1
      Lab Assignment - 2
      Lab Assignment - 3
      Lab Assignment - 4
  • Chapter 3

    Alter , Views And Index Price 2.99  |  2.99 Rewards Points

    • Alter Commands
    • Synonym
    • Views
    • Index
    • Lab Assignment - 5
  • Chapter 4

    SQL * Plus Functions Price 2.99  |  2.99 Rewards Points

    • Date Functions
    • Numeric Functions
    • Character Functions
    • Conversion Functions
    • LOB and Miscellaneous Functions
    • Aggregate Functions (Group Function)
      Lab Assignment - 6
      Lab Assignment - 7
  • Chapter 5

    Normalization Price 2.99  |  2.99 Rewards Points

    • First Normal Form
    • Second Normal Form
    • Third Normal Form
    • Fourth Normal Form
    • Fifth Normal Form
  • Chapter 6

    Relations, Join, Reports Price 2.99  |  2.99 Rewards Points

    • Foreign Key
    • Join
    • Set Operators
    • Group by Clause
    • Having Clause
    • Subquery
    • SQL*Plus Report Commands
      Lab Assignment - 8
      Lab Assignment - 9
      Lab Assignment - 10
  • Chapter 7

    Introduction to PL/SQL Price 2.99  |  2.99 Rewards Points

    Objectives:

    • Introduction
    • The Anonymous PL/SQL Block
    • Lexical Units
    • Reserved Words
    • Variables and Data Types
    • Records in PL/SQL
    • Operator Precedence
    • Control Structures
    • Sequential Control
    • Exception Handlers
    • Advantages of PL/SQL
      Lab Assignment - 11
      Lab Assignment - 12
  • Chapter 8

    Cursors Price 2.99  |  2.99 Rewards Points

    • Cursors in PL/SQL
    • Types of Cursors
    • Cursors Operations
    • Declaring Cursors
    • Opening Cursors
    • Fetching from Cursors
    • Closing Cursors
    • Cursor Attributes
    • Cursor Variables
    • The Cursor FOR Loop
      Lab Assignment - 13
      Lab Assignment - 14
  • Chapter 9

    Trigger Price 2.99  |  2.99 Rewards Points

    • Assertions
    • Introduction
    • Basic Trigger Syntax
    • Trigger Events
    • Type of Triggers
    • Trigger Example
    • Viewing Defined Trigger
    • Advantages of Trigger
      Lab Assignment - 15
      Lab Assignment - 16
  • Chapter 10

    Subprograms : Procedure and Functions Price 2.99  |  2.99 Rewards Points

    • Subprograms
    • Advantages of Subprograms
    • Modular Code
    • Functions
    • Actual and Formal Parameters
    • Matching Actual and Formal Parameters in PL/SQL
    • Recursion
      Lab Assignment - 17
  • Chapter 11

    Packages Price 2.99  |  2.99 Rewards Points

    Objectives:

    • Introduction
    • Advantages of Packages
    • Public andPrivate Package Elements
    • How to Reference Package Elements
    • Quick Tour of a Package
    • Packages without Bodies
    • Overloading
    • Product-Specific Packages
      Lab Assignment - 18
  • Chapter 12

    Oracle Utilities Price 2.99  |  2.99 Rewards Points

    • Oracle Enterprise Manager
    • Database Administration Tools
    • Oracle Net 9
    • Partioning
    • Backup
    • Export
    • Import
    • SQL* Loader Basics
  • Chapter 13

    Oracle Forms Price 2.99  |  2.99 Rewards Points

    • Introduction
    • Prerequisites
    • Developer Tools
    • The Oracle Forms Designer Main Screen
    • Forms Design
    • Creating and Running a Form with a Single Block
    • Creating a Master-Detail Form
    • List of Values (LOV) and Non-Base Table Fields
    • Oracle Forms Program Units and Stored Program Units
    • Adding Alerts
      Lab Assignment - 19
  • Chapter 14

    Oracle Reports Price 2.99  |  2.99 Rewards Points

    Objectives:

    • Oracle Reports Basics
    • Starting Developer Tools Under Windows 95/98/NT/2000
    • The Oracle Reports Object Navigator
    • Creating Menus In Oracle Forms
    • Assigning Commands To Menu Items
    • Graphics and the Chart Wizard
    • Oracle Schema Builder
    • Adding Relationships between Tables
  • Chapter 15

    Objects and Basic Database Administration Price 2.99  |  2.99 Rewards Points

    Objectives:

    • Object Views
    • Methods
    • Large Objects
    • Tablespace
    • The Oracle Database Administrator
    • Data Dictionary
    • Remote Data Access
      Lab Assignment - 20
  • Chapter 16

    FAQs Price 2.99  |  2.99 Rewards Points

    Frequently Asked Questions

  • Chapter 17

    Competitive Questions Price 2.99  |  2.99 Rewards Points

    Compettitive Questions Asked by Reputed Companies like Infosys, Satyam, HCL, TCS, Oracle, Peoplesoft, Baan,etc

  • Chapter 18

    Appendix Price 2.99  |  2.99 Rewards Points

    Glossary of Database Terms
    (Useful for Interview/Viva-Voce Purpose)

About the Author

M.SC ( Comp. Sc ), Masters in I.T view complete profile

M.C.A, M.Tech. (Comp. Sc) view complete profile