Oracle PL/SQL Tutorial for Beginners: Learn in 7 Days

Training Summary


Oracle PL/SQL is an extension of SQL language, designed for seamless processing of SQL statements enhancing the security, portability, and robustness of the database. This PL/SQL online programming course explains some important aspect of PL SQL language like block structure, data types, packages, triggers, exception handling, etc.



What should I know?


Basic knowledge of SQL programming will be required.

Here is what we cover in the Course

 TutorialWhat Is PL/SQL? Introduction & Architecture
 TutorialSQL Vs. PL/SQL Vs T-SQL: Key Differences
 TutorialPL/ SQL Block: STRUCTURE, Syntax, ANONYMOUS Example
 TutorialPL/SQL First Program: Hello World Example
 TutorialOracle PL/SQL Data Types: Character, Number, Boolean, Date, LOB
 TutorialOracle PL/SQL Variable Identifiers Tutorial with Examples
 TutorialOracle PL/SQL Collections: Varrays, Nested & Index by Tables
 TutorialOracle PL/SQL Records Type with Examples
 TutorialOracle PL/SQL IF THEN ELSE Statement: ELSIF, NESTED-IF
 TutorialOracle PL/SQL: CASE Statement with Examples
 TutorialOracle PL/SQL LOOP with Example
 TutorialOracle PL/SQL FOR LOOP with Example
 TutorialOracle PL/SQL WHILE LOOP with Example
 TutorialOracle PL/SQL Stored Procedure & Functions with Examples
 TutorialOracle PL/SQL Exception Handling: Examples to Raise User-defined Exception
 TutorialOracle PL/SQL Insert, Update, Delete & Select Into [Example]
 TutorialOracle PL/SQL Cursor: Implicit, Explicit, Cursor FOR Loop [Example]
 TutorialOracle PL/SQL BULK COLLECT: FORALL Example
 TutorialAutonomous Transaction in Oracle PL/SQL: Commit, Rollback
 TutorialOracle PL/SQL Package: Type, Specification, Body [Example]
 TutorialOracle PL/SQL Trigger Tutorial: Instead of, Compound [Example]
 TutorialOracle PL/SQL Object Types Tutorial with EXAMPLES
 TutorialOracle PL/SQL Dynamic SQL Tutorial: Execute Immediate & DBMS_SQL
 TutorialNested Blocks & Variable Scope in Oracle PL/SQL Tutorial [Example]
 CheckPL/SQL Interview Questions

Post a Comment

0 Comments