Udemy

Learning PL/SQL - Truly Basic to Advanced The Example Way

Enroll Now
  • 446 Students
  • Updated 1/2021
4.3
(52 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
10 Hour(s) 23 Minute(s)
Language
English
Taught by
Prashant Munshi
Rating
4.3
(52 Ratings)

Course Overview

Learning PL/SQL -  Truly Basic to Advanced The Example Way

Rapid PL/SQL interview preparation - PL/SQL Cursors, Procedures, Functions, Packages & Triggers - Object Oriented PL/SQL

*****************************************************************************

Added lecture PL/SQL Object Table & Row Object *** Section - Object Oriented PLSQL (09 Jan 2020)

*****************************************************************************

After a successful study in SQL, now you need to know the PL/SQL thoroughly to make make you a genuine back end programmer. Even if you are an acclaimed front-end programmer, with the study of SQL coupled with PL/SQL through this course you will become virtually invincible in the field as database analyst/programmer, DBA and trainer.

If you have already wasted your time and money in hunting for a complete yet concise course in PL/SQL through random youtube videos mostly offered by inexperienced people and not certified for their authenticity and quality - then you are at the right place here. This course brings step-by-step lessons in its logical series of videos to help you master the programming in PL/SQL. Moreover this same channel brings to you a complete course in SQL to make a one stop shop for all your database side learning.

This course has been brought by an highly experienced faculty who have had 20+ years of experience in working as Oracle developer and DBA out of which 6 years onside in USA and UK. The faculty has been working in Oracle field ranging from Oracle version 6 to the latest 19C.

Who this course is for?

  • Students seeking database side prestigious career as Programmer Analyst

  • Working professionals who are next targeting to become a DBA must know the SQL & PL/SQL thoroughly

  • All UG students from Engineering, Science and Commerce streams stepping into the field of Information Technology

  • Project analysts, analysts and designers

  • All those who have studied SQL must learn PL/SQL to make the circle complete

Course Content

  • 9 section(s)
  • 30 lecture(s)
  • Section 1 Introduction
  • Section 2 PLSQL Special Datatypes
  • Section 3 PLSQL Control Structures
  • Section 4 PLSQL Cursors
  • Section 5 PLSQL Cursor Variables - REF CURSOR
  • Section 6 Stored Procedures and Functions
  • Section 7 PLSQL Packages
  • Section 8 PLSQL Triggers
  • Section 9 Object Oriented PLSQL

What You’ll Learn

  • Oracle PL SQL Programming
  • Block Structure of PL SQL
  • Exception handling / different types of exceptions
  • Special PL SQL Anchored and Record Datatypes
  • Concept and types of PL SQL Cursors
  • Writing Procedure, Function, Package, Trigger, Object Types
  • Object Oriented Programming in PL SQL
  • PL/SQL Collections - Nested Tables and Varrays


Reviews

  • U
    Ujjwal Gupta
    3.5

    could have more examples

  • M
    Mary Rogers
    3.0

    I have a hard time understanding accents.

  • S
    Saurabh Ratnaparkhe
    4.0

    The course coverage is good for learning Oracle PL/SQL. Please also consider a course video with SQL Developer tool.

  • F
    Fauz Aziz
    5.0

    Amazing, your videos are very well structured and easy to understand. wonderful you make things easy for us

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed