This tutorial is designed for Software Professionals/students, who are willing to learn PL/SQL Programming Language in simple and easy steps. This course will give you great understanding on PL/SQL Programming concepts, and after completing this course, you will be at intermediate level of expertise from where you can take yourself to higher level of expertise.

Topics Covered

1.Basics of PL/SQL PL/SQL architecture PL/SQL and SQL*Plus PL/SQL Basics, Variables, Constants, data types & error handling PL/SQL wrapper utility 2.PL/SQL structures Simple blocks Control structures PL/SQL records Recognizing the Basic PL/SQL Block and Its Sections Describing the Significance of Variables in PL/SQL Distinguishing Between PL/SQL and Non-PL/SQL Variables Declaring Variables and Constants Executing a PL/SQL Block 3.Stored procedures, functions and packages Basics of stored procedures Basics of functions Basics of packages Defining stored procedures & functions Function and stored procedures prototypes Passing arguments to functions and stored procedures Recompiling functions and stored procedures Pinning packages in the SGA with dbms_shared_pool.keep Package forward declaration Package dependency Package overloading Listing package information 4.Error checking – exception handling Defining exceptions Using the when others clause Ensuring complete error checking Passing error messages to calling routine Boolean logic in PL/SQL 5.Control Structures Constructing an IF Statement Constructing and Identifying Different Loop Statements Controlling Block Flow Using Nested Loops and Labels If-then-else structure Testing for numbers characters and Booleans For loop While loop 6.Nested blocks in PL/SQL Creating nested blocks Understanding scope in nested blocks 7.Cursors in PL/SQL Cursor basics Using a cursor for a multi-row SQL query 8.Triggers in PL/SQL Triggers and database events Defining a trigger Timing a trigger Enabling and disabling a trigger 9.Dynamic SQL in PL/SQL Introduction to the dbms_sql package Creating a dynamic SQL statement 10.PL/SQL tables: Defining PL/SQL tables Reasons to use PL/SQL tables Populating a PL/SQL table Retrieving from a PL/SQL table 11.Bulking in PL/SQL: Bulk queries Bulk DML (forall statement) Using cursor attributes Analyzing impact of bulk operations

Who should attend

-Students willing to upgrade their skill set. -Developers -DBA's

Pre-requisites

Basic understanding of database concepts and SQL.

What you need to bring

Inclination to learn new concepts."

Key Takeaways

Write a PL/SQL block using all elements of block structure. Write PL/SQL statements using lexical units, declared variables, and assignment statements. Use control structures to loop, branch, and jump. Use PL/SQL named exceptions and user-defined exceptions. Use explicit cursors,triggers,packages,procedures,functions Bulk Processing