Oracle PLSQL - Procedures and Functions

This Amazing course is based on Mastering Explicit Cursors and Exceptions concepts in PLSQL. You will learn in detail about The WHERE CURRENT OF Clause, Creating Procedures, Creating Functions etc.

377

 3h 15m | 28 Videos | 89619 Views |   Intermediate

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Participants learn to create PL/SQL Writing Explicit Cursors, Advanced Explicit Cursor Concepts, Handling Exceptions, Creating Procedures, Creating Functions. All this topics will be taught along with the practical examples in the software.

Participants use Oracle SQL Developer to develop these program units.

This Oracle PL/SQL tutorial teaches you the basics of database programming in PL/SQL with appropriate PL/SQL tutorials with coding examples.

PLSQL stands for “Procedural Language extensions to SQL”, and is an extension of SQL that is used in Oracle. PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.

PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database.

PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Serverhave Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2]which conforms to theISO SQL’s SQL/PSM standard.

PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.

What are the requirements?

– Ability to relate to a customer centric thinking
– Intuitive problem solving abilities
– Data Mining ability
– A PC with internet

What am I going to get from this course?

– Over 16 lectures and 1 hour of content!
– To study what drives customer behavior at every stage of his lifecycle and henceforth capitalizing on his unique behavior at every time point so as to attract and retain profitable customers as well as make unprofitable customers profitable.
– We will be tracing the entire campaign management system from its origin to the end as well and will also be showing the interaction with the business at each stage.

What is the target audience?

– Students especially ones from the economics , finance and statistics background
– Professionals especially freshers as well as experienced professionals shifting their domains
– Consultants

Back to top ^