Learning PL/SQL - Truly Basic 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
*****************************************************************************
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
Instructor
- 4.4 Instructor Rating
- 3,450 Reviews
- 67,936 Students
- 6 Courses
I have more than 27 years of extensive experience in Oracle Database Administration (DBA) including onsite experience in US and UK of about 6 years. I have been a distinguished corporate trainer and adjunct faculty in the subjects of database engineering and software technologies; attached with various prestigious engineering & tech colleges in Central India since last 15 years.