+91 - 7569397388, +91 - 7799071404

Oracle SQL


 (Online Training Materials are providing ORACLE SQL real time training) 

In time views

Roll -number ( )

Rank ( )

Dense -rank ( )

Roll num

Roll id

Views

Simple view

Complex view

Triggers (p1/sql)

Statement level. Triggers

Roll-level triggers

Materialized view

Complete refresh

Fast refresh

Privileges

System privileges

Object privileges

Normal forms

1st NF

2nd NF

3rd NF

BCNF

4th NF

Synonyms

Sequences

Oracle server architecture

Storage area{ data files, control, files, online, redo log files}

Instance

SGA

Pro Asses

Table space

Indexes

SET operators

Conversions

Implicit or automatic conversions

Explicit conversion

Partitions

Range partition

List partition

High partition

Locks

Roll level locks

Table level locks

Nested table

Books

Flat files

Database

Flat files disadvantages

Data retrieval

Data redundancy

Data integrity

Data security

Data indexing

End user side

(Best ORACLE SQL training was held by Online Training Materials)

Prev Next

Training Enquiry