Course Details: Oracle Advanced PL/SQL & OCP Exam Prep
|
Course Title: Advanced PL/SQL & OCP Exam Prep
Course Number: JE-202
Length: 5-Day Seminar
Format: Onsite, Instructor-Led, Hands-on Labs
Tuition: $2,495
Synopsis:
This course gives students the knowledge needed in advanced PL/SQL programming required for an certification as a Advanced PL/SQL Developer Certified Professional (OCP) . The exam it targets is: 1Z0-146 Advanced PL/SQL.
Professionals seeking this certification must complete this exam and already have their Oracle PL/SQL Developer Certified Associate (OCA) or complete the following:
One of these exams:
1Z0-051: Oracle Database 11g SQL Fundamentals
1Z0-047: Oracle Database SQL Expert
as well as:
1Z0-147: Programming With PL/SQL
Students will cover details of advanced PL/SQL features in detail with heavy emphasis on security, tuning and performance of programs.
Audience:
Primary: Perfect course for those wishing to take the 1Z0-146 Advanced PL/SQL exam in pursuit of the Advanced PL/SQL Developer Certified Professional (OCP) certification. All relevant topics on that exam will be covered.
Secondary: This course is also extremely useful for any person requiring knowledge of higher PL/SQL features. Database administrators will also find the knowledge most useful in unlocking security and tuning features of the Oracle Database related to PL/SQL programs.
Prerequisites:
- Oracle Database Concepts (tables, columns, keys)
- Firm grasp of SQL
- Prior PL/SQL Experience
Course Breakdown:
This course is presented a series of Instructor-led modules, each targeting a specific area of the Oracle databases as it relates to the PL/SQL programming language. Hands-on labs support the modules during the course hours. The only external course work given will be reading assignments.
Course JE-202 Module Breakdown
- An overview of Oracle Database PL/SQL technology stack
- Using SQL*Developer to create PL/SQL
- Creating Stored Procedures
- Building Functions
- Building SQL Callable functions
- Deploying Program Units using Packages
- Advanced Package Concepts
- Using Parameters and their various Modes
- PL/SQL Error Handling
- Leveraging built-in Packages
- Dynamic SQL
- Developing Triggers with PL/SQL
- Working with Code objects in the Data Dictionary
- Manipulating Large Objects with PL/SQL
Provided Items:
Students attending JE-20 are provided the following as part of their enrollment:
- A copy of the book, Developing PL/SQL Program Units Exam Guide
- A Free PDF Copy of the book, Practical Oracle SQL Functions
- Copies of all course notes, hand-outs, and exercises with binders
- A 2 GB Flash Drive for saving student work
- Access to a laptop for use in the classroom for their use (not shared unless a shared system is requested) – these remain at the training center
- Complimentary pens, pencils, and paper
- Complimentary beverages and snacks each evening
- Access to the Stetson e-Education Blackboard System for downloading course materials and access to online content
Course JE-202 Topic List
Oracle11g: Advanced PL/SQL
[ ] PL/SQL Architecture Review
PL/SQL Programming Concepts: Review
[ ] Invoking stored procedures
[ ] Calling functions from SQL expressions
[ ] Handling exceptions
[ ] Manage dependencies
[ ] Using packaged program units
[ ] Use Oracle-supplied packages
;Designing PL/SQL Code
[ ] Identify guidelines for cursor design
[ ] Implicit/Explicit Cursors
[ ] Use cursor variables
[ ] Create subtypes based on existing types
Working with Collections
[ ] Create collections
[ ] Use collections methods
[ ] Manipulate collections
[ ] Distinguish between collection types
Using Advanced Interface Methods
[ ] Execute external C programs from PL/SQL
[ ] Execute Java programs from PL/SQL
Implementing Fine-Grained Access Control
[ ] Explain the process of fine-grained access
[ ] Implement and test fine-grained access
Manipulating Large Objects
[ ] Create and manage LOB data types
[ ] Use the DBMS_LOB PL/SQL package
[ ] Use of temporary LOBs
Administering SecureFile LOBs
[ ] Describe SecureFile LOB features
[ ] Deduplication, compression, and encryption
[ ] Migrate LOBs to the SecureFile LOBs
Performance and Tuning
[ ] Native vs interpreted compilation methods
[ ] Tune PL/SQL code
[ ] Enable intraunit inlining
Improving Performance with Caching
[ ] Caching SQL result sets
[ ] Write queries that use the result cache hint
[ ] PL/SQL result caching
Analyzing PL/SQL Code
[ ] Run reports on source code
[ ] Determine identifier types and usages
[ ] Use DBMS_METADATA
Profiling and Tracing PL/SQL Code
[ ] Trace PL/SQL program execution
[ ] Profile PL/SQL applications
Safeguarding Against SQL Injection Attacks
[ ] Describe SQL injections
[ ] Reduce attack surfaces
[ ] Use DBMS_ASSERT
[ ] Design immune code
[ ] Test code for SQL injection flaws
|
|
|
|
 |
|
