Oracle Database 12c Course Details

This course covers concepts of DBMS, SQL and PL/SQL. This is a must-to-do course for any programmer using database as back-end.

prerequisite Knowledge of computers. Programming knowledge is a plus.
Theory Fee Rs.3000/-
Lab Fee Rs.500/-
Software Required

Introduction to DBMS

  • What is DBMS
  • Relational Data Models
  • Data integrity rules
  • Normalization
  • Introduction to data processing methods - Client/Server
  • Oracle Architecture
  • What is cloud? What does 12c mean?

SQL

  • Creating Tables
  • Identify columns
  • Integrity Constraints
  • Adding, updating and dropping columns
  • Transaction and locking
  • Functions
  • Grouping data
  • Using ROLLUP and CUBE
  • Query Row Limits and Row Offsets
  • Joining tables
  • ANSI Join
  • Sub queries
  • Working with TOPn analysis
  • Views
  • Materialized Views
  • Using indexes
  • Security
  • External table
  • Flashback query
  • MERGE statement
  • Multitable insert
  • Using Regular Expressions
  • Fine Grained Dependency tracking

PL/SQL Programming

  • What is PL/SQL
  • Structure of PL/SQL block
  • Control statement
  • CASE expression
  • Creating and using Records
  • Working with Collections
  • Exception handling
  • Cursor handling
  • Writing stored procedures and functions
  • Definer rights vs. Invoker's rights
  • Packages
  • Autonomous transactions
  • Database triggers
  • Compound Triggers
  • Dynamic SQL with Native dynamic SQL

Object Features

  • Object types
  • Object Inheritance
  • Varrays
  • Nested tables
  • Object views