Course Detail

Course Description

Introduction to RDBMS

• Approach to Data Management Database Management:
• An evolution Phenomenon Introduction to DBMS Database Models
• Hierarchical Model Network Model Relational Model
• The 12 Rules for an RDBMS (CODD’s
• Rule) Zero rule
• Need for an Extended Service form an
• RDBMS
• Why Oracle?
• New Features of Oracle
• Oracle as an Object Relational Database Management System (ORDBMS) Networking Computing Architecture (NCA)
• Oracle Products

2. Introduction to SQL * Plus

• • Introduction to SQL *Plus
  • Oracle Data types
  • Information Representation
  • Starting SQL *Plus
  • Querying database Tables

     

    • Guaranteed Access
    • Systematic Treatment of Null
    • Systematic Treatment of Null
      Conditional Retrieval of Rows
    • Values

• Working with NULL Values4.Database Description Rule
• Matching a pattern with a5.Comprehensive Data Sub- Language
• Column from a table6.View Updating
• Summarizing data with Aggregate7.High-Level Update, Insert, Delete
• Functions8.Physical Data Independence
• Ordering the Result of a Query9.Logical Data Independence
• Command Summary of SQL *Plus Editor10.The Distribution Rule

3.Querying Multiple Table

• Collating Information
  • •  
• E-R Modeling
• Degree of Relationship
• Normalization
• Need for Normalization
• Steps in Normalization
• Present Scenario for Data Management Relational Database Management System
• Features of Oracle
• Equi Joins
• Cartesian Joins
• Outer Joins
• Self Joins
• SET Operators Union Intersect Minus
• Nested Queries
• Correlated Sub query
• Using Special Operators in Sub
• Defining Header, Footer and Column
• queries
• Headings
• Column Functions
• Formatting the Columns
• Arithmetic Functions
• Control Break Reports
• Data Functions

4.PL/SQL

• General Functions
• Introduction
• PL/SQL Block Structure
• PL/SQL Architecture
• Variables and Constants

5.Data Manipulation and Control -1

• Conditional and Iterative Control
• Creating tables
• Writing the PL/SQL Code
• Applying column constraints
• Cursor Management in PL/SQL
• Introduction to VIEWS
• Explicit Cursor Attributes
• Inserting Values into a Table
• Implicit Cursor Attributes
• Inserting the result of a query
• Composite Data types
• Inserting through Parameter

6.Advanced PL/SQL

• SQL *Plus Reporting
• DETAbase triggers nad how to create them
• Stored Packege
• Using stored Function in SQL Statement