oracle


Training Objectives

At the end of Oracle training course, participants will understand:

DBMS & RDBMS
SQL
DDL,DML,DCL,TCL
DBA
PL/SQL

Prerequisites
Understanding of fundamental computer concepts.

Training Duration
45 Hours

Syllabus

  • Introduction to DBMS, RDBMS, ORDBMS
    • Manual database, Computerized Database
    • Facilities of database management system
    • Drawbacks in the traditional file oriented approach
    • ADVANTAGES OF DBMS/NEED FOR DBMS
    • THREE VIEWS OF DATA/ THREE LAYERS OF DBMS
    • Database users
    • Terminology used in RDBMS
  • Introduction to oracle
    • The tools/utilities of oracle
    • Features of SQL
    • SQL prompt
    • Database homepage
    • Back end, Front end
  • Classification of SQL commands
    • DDL (Data Definition Language
    • DML (Data Manipulation Language)
    • DCL (Data Control Language):
    • TCL (Transaction control language):
  • About the SQL Buffer
  • Default tables
  • Items in the select clause
    • Relational operators
    • Substitution variables
  • FUNCTIONS
    • DUAL table
    • String functions
    • Arithmetic functions
    • DATE Functions
    • Miscellaneous functions
    • User environment
    • Group functions
    • SET OPERATORS
  • Table creation
    • Data types available in oracle
    • Inserting rows into a table
  • Integrity constraints
    • ALTER COMMAND
    • Delete Command
    • Update Command
    • Truncate Command
    • Rename command
    • Drop Command
    • Recycle bin
  • JOINS
    • Equi join.
    • Non-equi join.
    • Outer join.
    • Self join.
    • ALIASES
  • TRANSACTION CONTROL LANGUAGE
    • Commit
    • ROLLBACK:
    • Save point
  • Database Objects
    • Views
    • Indexes
    • Synonym
    • Sequences
    • Materialized Views
  • USERS AND SECURITY
    • DBA privileges
    • Creating a new user
    • Roles:
    • Data dictionary view
    • Cluster
  • SQL Command Line COMMANDS
    • REPORT GENERATION
    • SPOOL COMMAND
    • Lab Exercise
  • PL/SQL
    • Anonymous blocks
    • Sub-programs
    • Structure of pl/sql block
    • Pl/sql data types
    • CONTROL STRUCTURES
    • LOOPS
    • EXCEPTION HANDLING
    • User defined exceptions
    • CURSORS
  • SUBPROGRAMS
    • Procedures
    • Functions
    • Packages
    • Built in procedures
    • Database triggers
    • Database Links
  • About the Application Builder
    • Creating an Application
    • Add Pages
  • New features in oracle 10g
  • New features in oracle 11g
  • New Features in oracle 12c