Oracle PL/SQL Programming & Certification

Oracle PL/SQL Developer with IDE SQL Developer Demonstration and Certification objectives and resources

Created byAnjali Singh

Last updated 7/2019

English

What you'll learn

In this course, students can learn how to write PL/SQL Script to control database access with advance features
This course include Oracle PL/SQL Developer Certified Professional objectives and resources

Course content

1 section • 8 lectures • 2h 12m total length

Introduction of PL/SQL14:39
In this session, we will be introducing the PL/SQL concepts and fundamentals along with advantages of PL/SQL over SQL. This will also include PL/SQL sample block of code along with demonstration and HOMEWORK to practice. Thank you so much for watching and please subscribe to the channel for more upcoming videos.

Special Content in Bonus Lecture :
1. 1z0-144 OCP Program with PL/SQL Certification practice test
2. Oracle PL/SQL Programming Ebook
PL/SQL - Chapter 2 - Stored Procedure13:26
In this session, you will be learning all about STORED PROCEDURE in detailed along with demonstration and project practice design to implement for hands-on experience.
PL/SQL - Chapter 3 - Stored Functions13:38
In this session, you will be learning all about stored functions declaration, definition and demonstration with practice project in HOMEWORK section.
PL/SQL Chapter 4 - Trigger18:40
In this session, you will be learning all about TRIGGER in detail along with demonstration and project practice for Home work and hands on experience.
PL/SQL Chapter 5 - Cursors19:02
Today in this video, we will be learning one of the most important and complicated concept in PL/SQL , Cursor in detail along with demonstration and execution with HOMEWORK to practice and have some hands on experience. For more assistance, feel free to reach us on techranch2019@gmail.com. Thank you for enrolling this course.
PL/SQL Chapter 6 - Packages21:03
In this session, you will be learning all about PL/SQL Packages and their application development and demonstration along with reviewed project design to implement for hands on experience and practice concepts. For more videos, please subscribe http://www.youtube.com/techranch and press bell icon for notification and stay tune for more upcoming videos.
PL/SQL IDE - SQL Developer Demonstration17:14
In this session, we will be presenting you complete live demonstration of Oracle SQL Developer IDE with download, installation, database connection and user defined report.
Bonus Lecture - PL/SQL Interview Tips & Preparation15:17
In this session, you will be learning about all PL/SQL technical interview questions and some information about PL/SQL Developer Oracle Certification Associate level. Thank you so much for watching this video and please subscribe to Tech-Ranch and don't forget to press bell icon for update on videos. LET's MAKE CODING FUN!
For more assistance please feel free to send an email to techranch2019@gmail.com and subscribe for more updates on http://www.youtube.com/techranch
Thank you so much for enrolling this course. We will be having educational announcement for practice projects assignments with their solutions soon. Please keep learning and keep coding for better learning experience.

Special Content :
1. 1z0-144 OCP Program with PL/SQL Certification practice test
2. Oracle PL/SQL Programming Ebook
For more information please feel free to email on techranch2019@gmail.com

Requirements

Database concepts, SQL (refer to SQL course)

Description

In this course, we will be presenting you the complete course and resources on Oracle PL/SQL Development profile with live demonstration with example and practice projects for Homework. In this course, you will be provided PDFs , PPT, Source code and downloadable videos for your reference along with educational announcement of assignment and solutions through email for hands-on experience. Here, we will be sharing information about OCP (Oracle Certified Professional ) and share sample technical PL/SQL interview questions.

Enroll to this course, get Certification resources and earn Oracle Professional Badge in your career.

Who this course is for:

Database Administration responsibilities, SQL beginner, PL/SQL developer