oracle


  • 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