Oracle Database 19c: Advanced PL/SQL
Duration : 3 Days (24 Hours)
Oracle Database 19c: Advanced PL/SQL Course Overview:
The Oracle Database 19c Advanced PL/SQL certification is intended for professionals seeking to validate their expertise in designing, creating, and managing PL/SQL application components within the Oracle 19c database. PL/SQL, or Procedural Language for SQL, is Oracle’s proprietary extension that enhances SQL commands with procedural capabilities. The certification covers advanced topics such as PL/SQL stored program units, server-side PL/SQL applications, and triggers. Holding this certification demonstrates advanced proficiency in handling complex database tasks, making it highly valuable in the IT industry, especially for roles like database administrators, software developers, and system analysts. It equips professionals with the skills to manage data-driven applications efficiently and securely.
Intended Audience:
- Experienced Oracle Database users seeking advanced skills
- IT professionals responsible for managing Oracle Database
- Database administrators wanting in-depth understanding of PL/SQL
- Software developers familiar with Oracle looking to enhance PL/SQL coding skills
- System analysts working on Oracle applications
- IT consultants utilizing Oracle Database in their projects
Learning Objectives of Oracle Database 19c: Advanced PL/SQL:
The Oracle Database 19c: Advanced PL/SQL course is designed to provide learners with an in-depth understanding of the features of Oracle Database 19c. The course focuses on mastering advanced aspects of PL/SQL, including writing efficient PL/SQL code, optimizing performance, and utilizing application architect features. Learners will also acquire knowledge on creating, managing, and effectively using collections, as well as implementing advanced coding techniques.
Moreover, the course covers topics related to handling packages, dealing with large objects, making use of compiler features, and executing external procedures. By the end of the course, learners will be proficient in designing and tuning PL/SQL code for optimal performance in their work environment.
Module 1: Introduction
Module 2: Working with Exadata Express Cloud Service
Module 3: Overview of Collections
Module 4: Using Collectionss
Module 5: Handling Large Objects
Module 6: JSON Data in Database
Module 7: Advanced Interface Methods
Module 8: Performance and Tuning
Module 9: Improving Performance with Caching
Module 10: Analyzing PL / SQL Code
Module 11: Profiling and Tracing PL / SQL Code
Module 12: Securing Applications through PL / SQL
Module 13: Safeguarding Your Code against SQL Injection Attacks
Module 14: Advanced Security Mechanisms
Oracle Database 19c: Advanced PL/SQL Course Prerequisites:
• Knowledge of SQL and PL/SQL fundamentals.
• Expertise in Oracle Database 12c or higher.
• Prior experience in database administration or application development.
• Understanding of database concepts and architecture, relational databases, data modeling, and basic UNIX commands.
• Familiarity with Oracle data types, triggers, packages, procedures, functions, and exception handling.
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
