Oracle
SV Infotech Offers Oracle Training in Dilsukhnagar Hyderabad. Oracle PL,SQL Course training institute in Dilsukhnagar Hyderabad Telangana
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
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