Oracle Database 19c: Advanced PL/SQL

Master enterprise-level Oracle Database programming under the guidance of industry authorities. Enroll in our comprehensive training program tailored specifically for advanced PL/SQL development to gain expertise in cloud integration, performance optimization, security implementation, and sophisticated data handling techniques for a thorough professional skill set.

Online Jan 26-28, 2026 9:00 AM - 5:00 PM Mohammad Mehdi Lotfinejad
updated
intermediate
Oracle Database 19c: Advanced PL/SQL
We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
6 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
group discussion
q&A

Subsidies

HRDC Claimable logo

What you'll learn

  • Implement advanced collection types and bulk operations for optimal performance
  • Optimize PL/SQL code performance using profiling and caching strategies
  • Implement comprehensive security measures including VPD and SQL injection prevention
  • Analyze code quality using PL/Scope and static analysis tools effectively
  • Integrate external systems using advanced interface methods and web services
  • Handle Large Objects and JSON data efficiently in enterprise applications
  • Deploy and manage PL/SQL applications on Oracle Exadata Express Cloud Service
  • Apply encryption and data protection techniques using DBMS_CRYPTO package

Why should you attend?

This advanced Oracle Database 19c PL/SQL course provides comprehensive training in sophisticated database programming techniques, cloud integration, and enterprise-level application development. Participants will master advanced collection types including associative arrays, nested tables, and VARRAYs, while learning to implement high-performance bulk operations and multi-level data structures. The curriculum covers critical skills for working with Oracle Exadata Express Cloud Service, including provisioning, deployment, and cloud-based application migration strategies. The course delves deeply into handling complex data types such as Large Objects (LOBs) and JSON documents, equipping developers with the expertise to build modern REST APIs and manage multimedia content efficiently. Students will explore advanced interface methods including external procedure calls, Java stored procedure integration, and web service connectivity using UTL_HTTP and other utility packages. Performance optimization forms a core component, covering native compilation, result caching, deterministic functions, and comprehensive tuning methodologies. Security and code quality receive extensive attention through modules on SQL injection prevention, Virtual Private Database policies, fine-grained access control, and encryption techniques using DBMS_CRYPTO. Participants will gain proficiency in code analysis tools including PL/Scope, DBMS_PROFILER, and hierarchical profiling for identifying bottlenecks and improving application performance. The hands-on approach ensures practical experience with real-world scenarios, from implementing multi-tier caching solutions to creating comprehensive security frameworks and conducting thorough code reviews for enterprise applications.

Course Syllabus

Day 1 - Foundations, Cloud Environment, and Collections
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Data Handling and Performance Optimization
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Advanced Security, Code Analysis, and Best Practices
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years

Instructor

Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

Instructor Reviews

ML

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

FAQ

Frequently Asked Questions About This Course

Why should you attend?

This advanced Oracle Database 19c PL/SQL course provides comprehensive training in sophisticated database programming techniques, cloud integration, and enterprise-level application development. Participants will master advanced collection types including associative arrays, nested tables, and VARRAYs, while learning to implement high-performance bulk operations and multi-level data structures. The curriculum covers critical skills for working with Oracle Exadata Express Cloud Service, including provisioning, deployment, and cloud-based application migration strategies. The course delves deeply into handling complex data types such as Large Objects (LOBs) and JSON documents, equipping developers with the expertise to build modern REST APIs and manage multimedia content efficiently. Students will explore advanced interface methods including external procedure calls, Java stored procedure integration, and web service connectivity using UTL_HTTP and other utility packages. Performance optimization forms a core component, covering native compilation, result caching, deterministic functions, and comprehensive tuning methodologies. Security and code quality receive extensive attention through modules on SQL injection prevention, Virtual Private Database policies, fine-grained access control, and encryption techniques using DBMS_CRYPTO. Participants will gain proficiency in code analysis tools including PL/Scope, DBMS_PROFILER, and hierarchical profiling for identifying bottlenecks and improving application performance. The hands-on approach ensures practical experience with real-world scenarios, from implementing multi-tier caching solutions to creating comprehensive security frameworks and conducting thorough code reviews for enterprise applications.


What you'll learn

  • Implement advanced collection types and bulk operations for optimal performance
  • Optimize PL/SQL code performance using profiling and caching strategies
  • Implement comprehensive security measures including VPD and SQL injection prevention
  • Analyze code quality using PL/Scope and static analysis tools effectively
  • Integrate external systems using advanced interface methods and web services
  • Handle Large Objects and JSON data efficiently in enterprise applications
  • Deploy and manage PL/SQL applications on Oracle Exadata Express Cloud Service
  • Apply encryption and data protection techniques using DBMS_CRYPTO package

Course Syllabus

Day 1 - Foundations, Cloud Environment, and Collections
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Data Handling and Performance Optimization
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Advanced Security, Code Analysis, and Best Practices
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor Reviews

Mohammad Mehdi Lotfinejad

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
6 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
group discussion
q&A

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years
Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

FAQ

Frequently Asked Questions About This Course

Close menu