Oracle DB Developer (OSS)
-
Oracle Database 12c: Advanced PL/SQL NEW |
24 Hrs |
-
Introduction
- Course Objectives
- Course Agenda
- Describe the development environments
- Identify the tables, data, and tools used in this course
PL/SQL Programming Concepts: Review
- Identify PL/SQL block structure
- Packages, procedures and functions
- Cursors
- Handle exceptions
- Dependencies
Designing PL/SQL Code
- Describe the predefined data types
- Create subtypes based on existing types for an application
- List the different guidelines for cursor design
- Describe cursor variables
- White List
Overview of Collections
- Overview of collections
- Use Associative arrays
- Navigate using associative methods
- Use Nested tables
- Use Varrays
- Compare nested tables and varrays
Using Collections
- Write PL/SQL programs that use collections
- Use Collections effectively
- Enhancements to PL/SQL Type Binds
Manipulating Large Objects
- Working with LOBs
- Overview of SecureFile LOBs
Using Advanced Interface Methods
- Calling External Procedures from PL/SQL
- Benefits of External Procedures
- Understand how an external routine is called from PL/SQL
- C advanced interface methods
- Java advanced interface methods
Performance and Tuning
- Understand and influence the compiler
- Tune PL/SQL code
- Enable intra unit inlining
- Identify and tune memory issues
- Recognize network issues
Improving Performance with Caching
- Describe result caching
- Use SQL query result cache
- Use PL/SQL function cache
- Review PL/SQL function cache considerations
Analyzing PL/SQL Code
- Finding Coding Information
- PL/Scope Concepts
- DBMS_METADATA Package
- PL/SQL Enhancements
Profiling and Tracing PL/SQL Code
- Tracing PL/SQL Execution
- Tracing PL/SQL: Steps
12:Implementing VPD with Fine-Grained Access Control
- Understand how fine-grained access control works overall
- Describe the features of fine-grained access control
- Describe an application context
- Create an application context
- Set an application context
- List the DBMS_RLS procedures
- Implement a policy
- Query the dictionary views holding information on fine-grained access
Safeguarding Your Code Against SQL Injection Attacks
- SQL Injection Overview
- Reducing the Attack Surface
- Filtering Input with DBMS_ASSERT
-
Using Java - for PL/SQL and Database Developers |
16 Hrs |
-
Introduction
- Describe the course objectives
- Describe the course prerequisites and suggested prerequisites
- Describe lesson contents and agenda
- List the schemas and appendices used in this course
- Identify the relevant documentation and other resources
- Describe the Course Technical Environment and data
Introduction to Java
- Java and OOP Technology
- Key features of Java
Introduction to JDBC
- JDBC Architecture
- JDBC Drivers: Overview
- JDBC Specification
- Essential of JDBC Programming
Accessing and Manipulating SQL Data using JDBC
- Key Metadata in JDBC
- Manipulating Oracle Data Types with JDBC
- Accessing and Manipulating LOBs using JDBC
- Result Set support in JDBC
- Rowset
JDBC Quality of Services and Best Practices
- Introduction to Transaction Services
- Introduction to Security Services
- Best Practices and tips
Introduction to SQLJ Technology
- Overview of SQLJ
- SQLJ Database Access
Universal Connection Pool
- Introduction to Universal Connection Pool (UCP)
- Universal Connection Pool for JDBC Overview
- UCP for JDBC design-time and run-time requirements
- Basic Connection Steps
- Packages of the UCP for JDBC API
- Database Connections
Stored Procedures as Database Programming Model
- Overview of Stored Procedures
- Introduction to Java Stored Procedures
- Advantages of Java Stored Procedures
Oracle JVM
- Define Oracle JVM and its architecture
- Using Java in Oracle Database
- Difference between OracleJVM Architecture and JDK VM Architecture
- Automated Storage Management with Garbage Collection
- Dynamic Class Loading
- Performance Enhancement of Oracle JVM
Developing and Running Java in the Database
- Creating or Loading Java in the Database
- Removing Java Sources, Classes and Resources from the Database
- Setting/Querying Environment Variable and System Properties
- Java Compiler within the Database
- Converting Java in the Database into Stored Procedure
- Invoking Java in the Database
- Error and Exception Handling
- Managing Java in the Database
لمشاهدة فيديو حول التراك إضغط هنا
|