Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle PL/SQL Programming & Certification
Rating: 3.9 out of 5(65 ratings)
2,401 students

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 section8 lectures2h 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