Oracle Database 19c: Advanced PL/SQL Techniques - course RUB 43,490. from Specialist, training 24 academic hours, date of May 7, 2023.

Expert teacher of Oracle and Java courses. Oracle Certified Specialist, Candidate of Technical Sciences. He is distinguished by his diverse experience in practical and teaching activities.
In 2003, Alexey Anatolyevich graduated with honors from MIREA. In 2006, he defended his PhD thesis on the topic of building secure automated information systems.
A major specialist in the field of database security, building secure java and web applications for Oracle DBMS and SQL Server, developing stored program modules in PL/SQL and T-SQL. Automated the activities of large state-owned enterprises. Provides consulting and advisory services in the development of complex distributed web applications based on the Java EE platform.
Alexey Anatolyevich’s teaching experience in the postgraduate education system exceeds 7 years. Worked with corporate clients, trained employees of the companies “BANK PSB”, “Internet University of Information Technologies (INTUIT)”, “SINTERRA”.
Author of several educational and methodological manuals on programming and working with databases. From 2003 to 2005, Alexey Anatolyevich was engaged in the adaptation and technical translation of foreign literature on web programming and working with databases. Published over 20 scientific papers.
Grateful graduates invariably note the accessible manner of presentation of even the most complex topics, detailed answers to questions from students, and the abundance of living examples from the teacher’s professional practice.

Teacher with 27 years of experience, Oracle expert, holder of international certifications Oracle, MySQL, Microsoft, IBM. Has extensive experience in programming in SQL, PL/SQL, Java, C, C++, R, Python, Unix / Linux administration, using the Git system, creating virtual machines (VMWare, Virtualbox, HYPER-V), administering Oracle databases, IBM Informix, configuring server hardware and RAID.
Since 1991, Ilya Andreevich has been teaching IT courses at Moscow State University, including their application in business. Its graduates include employees of the largest enterprises in the Russian Federation. He has authored many works in economic publications about trends in the use of IT in business. He also regularly conducts training to improve the skills of IT specialists and speaks at seminars.
Polite, with a sense of humor, patient, responsible - this is how students characterize their teacher. He knows how to convey his experience to every student in simple and accessible language, which makes him a truly high-quality teacher.

Module 1. Introduction (1 ac. h.)

Course Objectives
Course Schedule
Description of development environments
Tables, data and tools used in this course

Module 2. Review of PL/SQL programming concepts (1 ac. h.)

PL/SQL Block Structure
Packages, procedures and functions
Cursors
Exception Handling
Dependencies

Module 3. PL/SQL code design (2 ac. h.)

Description of predefined data types
Create subtypes based on types present in the application
Using different approaches when designing cursors
Using Variable Cursors
White list

Module 4. Review of collections (2 ac. h.)

Collections overview
Using Associative Arrays
Navigation using associative methods
Using Nested Tables
Using Variable Length Arrays
Comparing nested tables and variable-length arrays

Module 5. Using collections (2 ak. h.)

Writing PL/SQL Programs Using Collections
Using Collections Effectively
Improvements to bind variable types in PL/SQL

Module 6. Manipulation of large objects (2 ac. h.)

Working with LOB
SecureFile LOB Review

Module 7. Using advanced interface methods (2 ac. h.)

Calling external programs from PL/SQL
Benefits of calling external procedures
Calling external procedures written in other programming languages
Calling procedures written in C from PL/SQL
Calling procedures written in Java from PL/SQL

Module 8. Tuning PL/SQL code performance (2 ac. h.)

Compiler influence
Customizing PL/SQL Code
Controlling Automatic Subroutine Embedding
Identifying memory usage problems and tuning them
Network problems

Module 9. Increasing performance through caching (2 ac. h.)

Description of caching results
Using the Query Results Cache
Using the PL/SQL Function Cache
Overview of PL/SQL Function Cache Features

Module 10. Analysis of PL/SQL code (2 ac. h.)

Code Information
PL/SQL Scopes
Package DBMS_METADATA
PL/SQL Improvements

Module 11. Profiling and tracing PL/SQL code (2 ac. h.)

PL/SQL execution trace
PL/SQL Trace Steps

Module 12. Implementation of a virtual private database using granular access control (2 ac. h.)

Description of how fine-grained access control works
Description of fine-grained access control methods
Description of the application context
Creating an Application Context
Applying Application Context
DBMS_RLS package procedures
Policy Enforcement
Data dictionary views containing fine-grained access control information

Module 13. Code protection from SQL injections (2 ac. h.)

Description of SQL injections
Reducing areas vulnerable to SQL injections
Using DBMS_ASSERT