What you'll learn

Basics of PL/SQL
Variables and Constants
Conditional, Looping and Sequential Statements
Exception Handling
Cursor Handling
Sub-Programs, Functions and Procedures
Triggers
DBMS:: Get chance to enroll in Simplified Approach to DBMS Course completely free after completion of this course

Requirements

Zero prior technical experience is required! All you need is a passion to learn and experiement new things.

Description

In modern world, no application is possible without involving the use of database. There is a growing demand for database experts all over the world. And this course is intended to fill this gap. This course on PL/SQL has been specially designed to better equip the learners for their academic and professional career.

This course is aimed at beginners, and it will guide you on a wonderful journey to transform you from naïve to expert of PL/SQL. In this course, you'll learn the PL/SQL using Oracle, i.e., the most widely used Database Software in the world.

In this course you will learn how to use PL/SQL statements to implement business logic with the use of Cursors, Procedures, Functions and Triggers. All these concepts are covered through lot of examples to make the learning fun and exciting. The main strength of the course is explanation with the practical examples so that learners can grasp the contents easily.

Bonus: All those learners who will complete this course will get chance to register for another Online Udemy Course Simplified Approach to DBMS completely free.

Do not miss this opportunity. On completion just send your course completion certificate at [email protected] and get coupon code for Simplified Approach to DBMS as token of appreciation from the instructor and continue embark your journey on mastering databases.

Overview of Course Contents:

Section-1: Basics of PL/SQL

· Introduction to PL/SQL

· Architecture of PL/SQL

· PL/SQL Language Elements

· Structure of PL/SQL Block

Section-2: Variables and Constants

· Variables in PL/SQL

· Select into Statement of PL/SQL

· Constants in PL/SQL

· Variable Attributes

Section-3: Conditional, Looping and Sequential Statements

· Conditional Statements

· Simple Loop

· While Loop

· For Loop

· Sequential Control

· Assignments and Its Solution

Section-4: Exception Handling

· Major strengths of this course is as follows:

· Types of Exceptions

· Handling of Predefined and Non-Predefined Oracle Server Errors

· Explicit Exceptions

· Error Trapping Functions

· Exceptions raised in Declare Section

· Propagation of Exceptions

· Re-raising of Exceptions

· Demonstrations

· Assignment and Its Solution

Section-5: Cursor Handling

· Concept of Cursor

· Implicit Cursor

· Explicit Cursor

· Demonstrations

· Cursor For Loop

· Cursor with Parameters

· Cursor Assignments and Its Solutions

Section-6: Sub-Programs, Functions and Procedures

· Sub Programs & Its Types

· Local Functions

· Stored Functions

· Demonstrations

· Local Procedures

· Stored Procedures

· Assignments & Its Solutions

Section 7: Trigger

· Concept of Trigger

· Uses and Applications of Trigger

· Types of Trigger

· Before Statement & Row Level Trigger

· After Statement & Row Level Trigger

· Syntax of Trigger

· Old and New Keywords

· Raising Application Errors

· Assignments & Its Solutions

Strengths of Course

· More than 9 Hours of Video Contents

· More than 70 Video Sessions

· Enough Reading Material to Brain Map the Concepts

· Quizzes after each section to check your progress

· Every Section has Assignments to have learning by doing pedagogy

· Excellent course to prepare for DBMS

· Excellent way to become expert of PL/SQL before placement and Interviews

Who this course is for:

Anyone who is interested in learning more about PL/SQL.
Students taking DBMS Course
Professionals working in the area of databases
Students preparing for placements & Interviews
Students preparing for competitive exams

Homepage: https://www.udemy.com/course/mastering-plsql/

Download Part 01

Download Part 02

Click Here for More Tutorial