PL/SQL Tutorial


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.

Training Summary

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

What is Oracle PL/SQL?

Oracle PL/SQL is an extension of SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super powerful SQL queries. PL/SQL means instructing the compiler 'what to do' through SQL and 'how to do' through its procedural way.

What will I learn in this PL/SQL Tutorial?

In this PL/SQL Tutorial, you will learn basic introduction to PL/SQL and basic concepts like structure, syntax, etc. Moreover in the advanced stuff in this PL/SQL tutorial in Oracle, you will learn Data types, variables, collections, Loops, stored procedure, exception handling, packages, triggers, and so on.

Are there any prerequisites for this PL/SQL Tutorial?

There are some prerequisites for the PL/SQL Tutorial for beginners. If you have a basic knowledge of Database, source code, text editor, basic software programming concepts, program execution, etc., you will be able to learn and understand all the concepts much faster and easier.

Who is this PL/SQL Tutorial for?

This Oracle PL/SQL Tutorial is specially designed for the Software Professionals who are interested to learn PL SQL. This PL SQL tutorial will help you learn PL/SQL programming in a simple and easy way and will help you to understand all the PL/SQL concepts.

Why should you learn PL/SQL?

PL/SQL is more than SQL, which allows you to query, transform, update, design and debug data and provides more features than SQL. Moreover, it is widely used in various sectors like banking, ticket booking, eCommerce, etc. so, there are vast opportunities available for the PL/SQL programmers. However, you can learn PL/SQL to enhance your knowledge and SQL programming skills.