Course details
Introduction
This three day Advanced PL/SQL training course teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections.
Discover how to write PL/SQL routines that analyse the PL/SQL applications and caching techniques that can improve performance. By investing in this course, you'll be introduced to the Virtual Private Database (VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.
Course Content
- Lesson 1: Introduction
- Lesson 2: PL/SQL Programming Concepts: Review
- Lesson 3: Designing PL/SQL Code
- Lesson 4: Overview of Collections
- Lesson 5: Using Collections
- Lesson 6: Manipulating Large Objects
- Lesson 7: Using Advanced Interface Methods
- Lesson 8: Performance and Tuning
- Lesson 9: Improving Performance with Caching
- Lesson 10: Analysing PL/SQL Code
- Lesson 11: Profiling and Tracing PL/SQL Code
- Lesson 12: Implementing FineGrained Access Control for VPD
- Lesson 13: Safeguarding Your Code against SQL Injection Attacks
Course Location
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Programmer - CPD Certified Apex LearningZAR 3,335Duration: Upto 165 Hours
- ZAR 229Duration: Upto 3 Hours
