PL/SQL Tutorial: Learn Oracle PL/SQL in 7 Days
Richard Peterson
PL/SQL Tutorial 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.
Oracle PL/SQL Syllabus
Introduction
| 👉 Lesson 1 | What is PL/SQL? — Full Form, Architecture of PL/SQL Developer |
| 👉 Lesson 2 | SQL Vs PL/SQL Vs T-SQL — Key Differences |
| 👉 Lesson 3 | PL/ SQL Block — STRUCTURE, Syntax, ANONYMOUS Example |
| 👉 Lesson 4 | PL/SQL First Program — Hello World Example |
Advanced Stuff
| 👉 Lesson 1 | Oracle PL/SQL Data Types — Boolean, Number, Date [Example] |
| 👉 Lesson 2 | PL/SQL Variables Naming Convention — Learn with Example |
| 👉 Lesson 3 | Oracle PL/SQL Collections — Varrays, Nested & Index by Tables |
| 👉 Lesson 4 | Oracle PL/SQL Records Type — Learn with Example |
| 👉 Lesson 5 | Oracle PL/SQL IF THEN ELSE Statement — ELSIF, NESTED-IF |
| 👉 Lesson 6 | Oracle PL/SQL CASE Statement — Learn with Example |
| 👉 Lesson 7 | Oracle PL/SQL LOOP — Learn with Example |
| 👉 Lesson 8 | Oracle PL/SQL FOR LOOP — Learn with Example |
| 👉 Lesson 9 | Oracle PL/SQL WHILE LOOP — Learn with Example |
| 👉 Lesson 10 | Oracle PL/SQL Stored Procedure & Functions — Learn with Example |
| 👉 Lesson 11 | Oracle PL/SQL Exception Handling — Examples to Raise User-defined Exception |
| 👉 Lesson 12 | Oracle PL/SQL Insert, Update, Delete & Select Into — Learn with Example |
| 👉 Lesson 13 | Oracle PL/SQL Cursor — Implicit, Explicit, Cursor FOR Loop [Example] |
| 👉 Lesson 14 | Oracle PL/SQL BULK COLLECT — FORALL Example |
| 👉 Lesson 15 | Autonomous Transaction in Oracle PL/SQL — Commit, Rollback |
| 👉 Lesson 16 | Oracle PL/SQL Package — Type, Specification, Body [Example] |
| 👉 Lesson 17 | Oracle PL/SQL Trigger Tutorial — Instead of, Compound [Example] |
| 👉 Lesson 18 | Oracle PL/SQL Object Types Tutorial — Learn with Example |
| 👉 Lesson 19 | Oracle PL/SQL Dynamic SQL Tutorial — Execute Immediate & DBMS_SQL |
| 👉 Lesson 20 | Nested Structure — PL/SQL Variable Scope & Inner Outer Block |
Must Know!
| 👉 Lesson 1 | PL/SQL Interview Questions — Top 65 PL/SQL Interview Questions & Answers |
| 👉 Lesson 2 | PL/SQL Tutorial PDF — Download Oracle PL/SQL Tutorial PDF for Beginners |
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.