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:

one Day

Faculty Incharge

Dr. Manjot Bhatia & Ms. C. Komalavalli