Mastering PL/SQL

[LeeAndro]

h264, yuv420p, 1280x720 |ENGLISH, 44100 Hz, 2channels | 10h 45mn | 3.19 GB

Zero prior technical experience is required!

Simplified way to learn PL/SQL
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

Requirements

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 acad and professional career.

This course is aimed at bners, 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.

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



DOWNLOAD
uploadgig

https://uploadgig.com/file/download/114Beab6e44dd7C3/thBFhNAC__Mastering_.part1.rar
https://uploadgig.com/file/download/422db2718c727601/thBFhNAC__Mastering_.part2.rar
https://uploadgig.com/file/download/c832Be3DFb5daD34/thBFhNAC__Mastering_.part3.rar
https://uploadgig.com/file/download/589bA13eb3d680A8/thBFhNAC__Mastering_.part4.rar

rapidgator

https://rapidgator.net/file/a2d8017f25167d1597ddd2a8c828f969/thBFhNAC__Mastering_.part1.rar
https://rapidgator.net/file/a620b9b17e7dc03b9a494274b3aa6ec5/thBFhNAC__Mastering_.part2.rar
https://rapidgator.net/file/8b016554720cfdbc839bf3dc38701e9b/thBFhNAC__Mastering_.part3.rar
https://rapidgator.net/file/c9cac97b902bc55113a6a45bd5efd30b/thBFhNAC__Mastering_.part4.rar

nitroflare

http://nitroflare.com/view/98548F8E3594DAC/thBFhNAC__Mastering_.part1.rar
http://nitroflare.com/view/862827D1448D439/thBFhNAC__Mastering_.part2.rar
http://nitroflare.com/view/55B5DBDB2D066A5/thBFhNAC__Mastering_.part3.rar
http://nitroflare.com/view/0F7B96B3AD7A317/thBFhNAC__Mastering_.part4.rar