Udemy – [NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c 2023-9

[NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c Course. This comprehensive course teaches Oracle’s PL/SQL programming language from beginner to advanced level based on the latest Oracle 21c release. First, basic concepts such as PL/SQL block structure, variable definition, data types, and execution statements are presented. Then, database interaction through SELECT statements, transaction management, and working with SQL Cursors are taught. Flow control topics including IF and CASE conditional statements, loops, and exception handling are fully covered. In more advanced sections, creating and using Stored Procedures, Functions, Packages, and Triggers are taught with practical examples. Advanced concepts such as Dynamic SQL, Collections, and Object Dependencies are also reviewed. This course is designed by an experienced professional with an OCP certification and 19 years of experience in the Oracle field and is suitable for database developers who want to improve their PL/SQL skills.

What you will learn:

• Anonymous Block
• Control Structure
• Error handling
• Cursors
• Procedure and Function
• Triggers
• Packages
• Dynamic SQL
• Collections
• PL/SQL Compiler
• Dependencies
• Pipeline Functions
• Handling LOBs
• Security
• Performance Tuning
• Bulk Collect
• Caching
• Best Practices
• Real life Examples
• Lots of coding practice
• Latest PL/SQL version in Oracle 21c
• Course by professionals for professionals
• Instructor has over 10 years of real-world experience in PL/SQL
• Brand new course released on September 16, 2023

Who is this course suitable for?

• Database Developers
• Data Analysts
• ETL Developers
• Database Administrators
• Application Designers
• QA Professional to write stored procedures for data validations
• Database Administrators For Automating Jobs and Security Implementation (DBA)
• Anyone Interested in Learning PL/SQL Programming Language
• Anyone looking for Advanced PL/SQL concepts

Course Details [NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c

• Publisher:  Udemy
• Instructor:  Global Trainers
• Training level: Beginner to advanced
• Training duration: 19 hours and 38 minutes
• Number of courses: 180

Course syllabus as of 2025/4

Course Prerequisites [NEW] Oracle PL/SQL – An Ultimate Bootcamp – 21c

• Students should have prior knowledge of SQL
• Should have a Desktop or Laptop with Internet

Course images

Sample course video

Download link

Download Part 1 – 2 GB

Download Part 2 – 2 GB

Download Part 3 – 2 GB

Download Part 4 – 83 MB

File(s) password: www.downloadly.ir

File size

6.08 GB