Course details
Introduction
This three-day instructor-led course will teach participants how to make use of the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Learn how to create powerful PL/SQL programs through the use of the more advanced features of program design, packages, cursors, collections and extended interface methods. In addition topics such as programming efficiency, using external routines written in Java and C, and implementing fine-grained access control are also covered.
Course Content
- Lesson 1: Introduction
- Lesson 2: PL/SQL Programming Concepts: Review
- Lesson 3: Designing PL/SQL Code
- Lesson 4: Working with Collections
- Lesson 5: Manipulating Large Objects
- Lesson 6: Using Advanced Interface Methods
- Lesson 7: Performance and Tuning
- Lesson 8: Improving Performance with Caching
- Lesson 9: Analyzing PL/SQL Code
- Lesson 10: Profiling and Tracing PL/SQL Code
- Lesson 11: Implementing FineGrained Access Control for VPD
- Lesson 12: Safeguarding Your Code against SQL Injection Atta cks
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
- ZAR 805
ZAR 5,737Duration: Upto 20 Hours - Oracle DBA (Video-Based) UplatzZAR 230Duration: Upto 10 Hours
