Advanced PL SQL Schulung:
Learn to write powerful PL/SQL programs
In this course, students learn to use 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. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered. Students learn to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance. Students are also introduced to Virtual Private Database (VPD) to implement security policies and they also learn techniques and tools to strengthen their applications against SQL injection attacks. Learn To: PL/SQL designing best practicesCreate PL/SQL applications that use collectionsImplement a virtual private database with fine-grained access controlWrite code to interface with external C and Java applicationsWrite code to interface with large objects and use SecureFile LOBsWrite and tune PL/SQL code effectively to maximize performanceA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.