Best Software Training Institute in Ongole

28 years of Excellence

An ISO 9001 : 2015 Certified Institute

Biggest A/C Labs with 300 Computers

Permitted by Government of India

Database

Oracle

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

  1. 2. Introduction to SQL * Plus

Introduction to SQL *Plus

Oracle Data types

 

1. Information Representation Starting SQL *Plus

Querying database Tables

2. Guaranteed Access
3. Systematic Treatment of Null   Conditional Retrieval of Rows
  Values   Working with NULL Values
4. Database Description Rule   Matching a pattern with a
5. Comprehensive Data Sub- Language   Column from a table
6. View Updating   Summarizing data with Aggregate
7. High-Level Update, Insert, Delete   Functions
8. Physical Data Independence   Ordering the Result of a Query
9. Logical Data Independence   Command Summary of SQL *Plus Editor
10. The Distribution Rule 3. Querying Multiple Table
11. Non-Subversion   Collating Information

 

  1. 12. Integrity Rule

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 7. PL/SQL
General Functions   Introduction

PL/SQL Block Structure

PL/SQL Architecture

  Variables and Constants
4. 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   PL/SQL Records
  substitution   Exception Handling in PL/SQL
  Updating Column(s) of a Table   Scope Rules
  Deleting Row(s) From a Table   Exception Propagation
  Manipulating Table(s) the Base table(s) 8. Advanced PL/SQL
  through VIEWS   Subprograms in PL/SQL
5. Data Manipulation and Control –II   Procedure
  Database Security and Privileges   Functions
  GRANT and REVOKE   Argument modes
  Application Privileges Management   Database Triggers
  Enhancing Performance   Creating a database Trigger
  Clustering   Stored Packages
  Sequences   Using Stored Functions in SQL
  Manipulating Database Objects   Statements
  COMMIT and ROLLBACK    
  Granting Privileges on columns    
  Revoking Object Privileges and Roles    
6. SQL *Plus Reporting    
  Introduction    
  SQL *Plus Environment Commands    
  Manipulating Variables