Learning PL SQL - Beginner to Advanced - The Example Way
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
***The most comprehensive PL/SQL course to make you a genius***
***Continuously new lectures/revisions to be added every week to keep pace with ever demanding industry***
*****************************************************************************
***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. The SQL course launched by this same faculty on UDEMY went HOT in just few days to reach to one of the top selling coursed on this prestigious learning platform.
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
Introduction2 lectures • 57min
- IntroductionPreview23:39
- PL SQL Exception Handling33:46
PLSQL Special Datatypes2 lectures • 38min
PLSQL Control Structures2 lectures • 45min
PLSQL Cursors3 lectures • 1hr 17min
PLSQL Cursor Variables - REF CURSOR5 lectures • 1hr 19min
Stored Procedures and Functions2 lectures • 48min
PLSQL Packages4 lectures • 1hr 21min
PLSQL Triggers7 lectures • 2hr 25min
Object Oriented PLSQL3 lectures • 54min
Instructor
![Prashant Munshi](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 480 Reviews
- 34,825 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.