Oracle Database 12c R2: Advanced PL/SQL Ed 2 (ToD) On Demand.
- Seminar
- E-Learning
- Zurzeit keine Termine
- 24 Unterrichtseinheiten
- Teilnahmebescheinigung
Seminarnummer: 27514
This is an original ORACLE Training on Demand online product.
Nutzen
In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.
Learn To:
Learn To:
- Apply PL/SQL designing best practices.
- Create PL/SQL applications that use collections.
- Work with JSON data in the database.
- Implement a virtual private database with fine-grained access control.
- Write code to interface with external C and Java applications.
- Write code to interface with large objects and use SecureFile LOBs.
- Write and tune PL/SQL code effectively to maximize performance.
Zielgruppe
Datenbankadministratoren
Anforderungen
- Basic Knowledge of SQL, PL/SQL.
- Knowledge of PL/SQL Program Units.
- Familiarity with programming languages.
- Oracle Database: SQL Workshop I Ed 2.
- Oracle Database: Develop PL/SQL Program Units Ed 2.
Inhalte
- Oracle Database Exadata Express Cloud Service
- Overview of Collections
- Using Collections in PL/SQL
- Manipulating Large Objects
- Working with JSON Data
- Using Advanced Interface Methods
- Performance and Tuning
- Improving Performance with Caching
- Analyzing PL/SQL Code
- Profiling and Tracing PL/SQL Code
- Securing application through PL/SQL
- Safeguarding Your Code Against SQL Injection Attacks
- Security Features implemented through PL/SQL