The best suited audience to attend this course can be -
Data Warehouse Administrator
Business / Project Heads
This course is designed to introduce you about the fundamentals of PL/SQL. This course will help you to understand how to use PL/SQL with real-world scenarios. The key points which will be in focus during the PL/SQL Fundamental training can be-
To describe and introduce various features of PL/SQL with syntax.
To design anonymous block using PL/SQL.
To write PL/SQL code and control code flow like loops, control structures and explicit cursors.
To handle runtime errors and trapping exceptions
To work with stored procedures and functions.
After completing this course you will be able to handle a RDBMS using PL/SQL queries in an effective way by ensuring reliability, security and high performance. You will learn how to optimize workloads of a RDBMS and how to deliver a higher service quality. This course will help you to learn -
Features and Syntax of PL/SQL
Designing and executing anonymous block in PL/SQL
Write PL/SQL code to interface with the database
Handling runtime errors and trapping exception
Working with stored procedures and functions