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