Management Development Programme

Oracle 12c

Introduction

Database consolidation is a key step in the journey to the cloud. Oracle Database 12c makes the process far faster and simpler, enabling the high density of schema-based consolidation—without requiring changes to existing applications

Programme Objectives

  • How to execute SQL queries in Oracle 12C
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Write dynamic SQL for more coding flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently

Programme Contents

  • SQL commands and SQL statements
  • Joins and Subqueries, Using built in functions
  • Pl/SQL introduction: Defining variables and Data types; Using SQL in Pl/SQL
  • Program structure to control execution flow; Using cursors
  • Using composite data types; Exception Handling
  • Using and managing Procedures, user defined Functions, Triggers

Pedagogy

Mix of lectures and hands-on exercises

For Whom

  • Developers from IT industry at the junior levels

Duration:

Saturday 7th October, 2017.

Faculty Incharge

Dr. Manjot Bhatia & Ms. C. Komalavalli

[email protected]
+91-9871097501