Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Oracle Pl/SQL

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
Rating: 4.5 out of 54.5 (30 ratings)
333 students
Created by Prashant Munshi
Last updated 1/2020
English
English [Auto]
30-Day Money-Back Guarantee

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

Requirements

  • UG degree in any branch
  • Some background in SQL is advised

Description

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

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

Who this course is for:

  • Students of computer science and engineering, fresher or experienced
  • Professionals working in other front end languages like Java, Python, Dot NET
  • Students aspiring to make career in Databases, Data Mining, Data Science
  • Candidates aspiring to learn Database side Backend programming
  • Students who have studied SQL

Course content

9 sections • 30 lectures • 10h 23m total length

  • Preview23:39
  • PL SQL Exception Handling
    33:46

  • PL SQL Anchored Datatype %TYPE
    18:56
  • PL SQL Record Datatype %ROWTYPE
    18:46

  • PL SQL Conditional Statements
    27:05
  • PL SQL Looping Statements
    17:29

  • Preview07:06
  • PL SQL Explicit Cursor
    46:20
  • PL SQL Implicit Cursor
    23:14

  • Preview13:28
  • PL SQL Strong Typed REF CURSOR
    19:16
  • PL SQL Weak Typed REF CURSOR
    20:05
  • PL SQL Built In SYS_REFCURSOR
    11:19
  • PL SQL Cursor Subqueries
    14:45

  • Preview23:20
  • PL SQL Stored Procedures
    24:38

  • Preview22:27
  • Program Overloading in Package
    17:03
  • PL SQL Package Initialization
    22:26
  • PL SQL Forward Program Calling
    18:49

  • Preview17:17
  • PL SQL DML Triggers
    25:35
  • PL SQL Mutating Table Trigger Error
    23:36
  • PL SQL Trigger Predicates
    18:13
  • PL SQL Trigger WHEN Clause
    23:03
  • PL SQL System Level Triggers
    16:04
  • PL SQL Instead of Triggers
    21:31

  • Preview18:19
  • PL SQL Object Type Creation
    23:07
  • PL SQL Object Table and Row Objects
    12:22

Instructor

Prashant Munshi
Distinguished Database Analyst and Oracle Corporate Trainer
Prashant Munshi
  • 4.4 Instructor Rating
  • 671 Reviews
  • 47,177 Students
  • 5 Courses

I have degree in electronics and power engineering. I have more than 20 years of experience in Oracle Database Administration (DBA). Apart from onsite experience on foreign soil of about 6 years , I have been a distinguished corporate trainer and adjunct faculty in the subject of database engineering attached with various prestigious engineering colleges in Central India.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.