Oracle is one of the biggest technology giants in the world, offers IT products and services which are recognized and revered throughout the world. A relational database management system (RDMS) that's formally called Oracle Database. The database software sits at the center of many corporate IT environments, supporting a mix of transaction processing, business intelligence and analytics applications.

Introductions

  • Introduction to Databases
  • Introduction to DBMS and RDBMS
  • Normalization

SQL

  • Introduction to SQL
  • Data Types and Constraints in Tables
  • Data Definition Language(DDL) – Create, Alter, Drop, Rename
  • Data Manipulation Language(DML) – Insert, Update, Delete
  • SQL Operators
  • Set Operators
  • Number Functions
  • Character Functions
  • Date Functions
  • Group Functions
  • Sub Queries
  • Joins
  • Views
  • Sequences
  • Indexes

PL/SQL

  • Simple Programming in PL/SQL
  • Programming with % rowtype
  • If Statement, Control Structure
  • Exception Handling
  • Cursors
  • Sub Programs – Procedures, Functions
  • More Exceptions
  • Packages
  • Database Triggers
  • Select a Theme

Quick Inquiry

Note: WE'LL REVERT BACK TO YOU SOON.

Working hours

Monday 8:00 am - 8.00 pm
Tuesday 8:00 am - 8.00 pm
Wednesday 8:00 am - 8.00 pm
Thursday 8:00 am - 8.00 pm
Friday 8:00 am - 8.00 pm
Saturday 8:00 am - 8.00 pm