Course Details

Oracle : PL/SQL PL/SQL is the procedural language over SQL.If you have basic knowledge of database and looking to start your career in database programmer then this course is ideal for you. This course will cover basic plus advanced features of PL/SQL i.e program design ,packages, cursors and collections.As in Oracle 11g various new features has been added which is very helpful for database developer , we cover all those 11g features. Prerequisites Knowledge of SQL Duration : 40 Hours Training Highlights : Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Student learn to write powerful PL/SQL programs such asprocedures, packages, functions & triggers. Best trainers having Industry experience in current technology. We assist in OCA Certification and provides Interview tips.   Course Content 1. PL/SQL Structure Variables Data type 2. Creating the Executable Section Comments6 Literals Operator Output Statement Accepting input from user Variable scope Function Programs using SQL Statements in PL/SQL 3. Writing Control Structures If statement in PL/SQL If…else statement in PL/SQL Else if ladder statement in PL/SQL LOOPs in PL/SQL 4. Working with Composite Data Types PL/SQL Records Collections 5. Cursors PL/SQL Attributes Cursor Attributes Using cursor with for …loop 6. Exception Handling What is an Exception? How to handle Exception? Predefined Exception Get information about error with – SQLCODE and SQLERRM Non Predefined Error User Defined Exception 7. Stored Procedures Advantages of procedures Creating procedure Formal and actual parameters in procedure Using Anonymous block to invoke a procedure Default option for parameters Using Sub Procedures Calling procedure from another procedure Handled and Unhandled Exception when procedure called Delete procedure 8. Functions Advantages of Functions Calling function in SQL statement Restriction on calling function in SQL statement Deleting a Function Difference between function and procedure 9. Packages Advantages of packages Package Structure Executing the procedure and function Removing package 10. Triggers Creating a trigger Accessing a column using row trigger Using Statement trigger Modifying a Trigger Enabling and Disabling a trigger Dropping a trigger 11. Oracle Architecture- Complimentary Session