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

Ratings: 4.26 / 5.00




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

What You Will 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

Who Should Attend!

  • 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