| 1 |
Friday |
09:00 |
Introduction to Computing |
Introduction to Computing, Computational Thinking and the History of Computing |
| 2 |
Friday |
10:00 |
Introduction to Databases |
The Evolution of the Modern Database and Storage Structures |
| 3 |
Friday |
11:00 |
Introduction to Databases |
Relational Algebra Operations and Entity-Relationship Diagrams |
| 4 |
Friday |
12:05 |
Introduction to Databases |
Entities, Attributes, Relationships, Keys, Integrity Constraints, Uniqueness, Normal Forms |
| 5 |
Friday |
13:05 |
Introduction to Databases |
DBMS and ACID; Object Orientation (Abstraction, Inheritance, Encapsulation, Polymorphism); Software Development Life Cycle and Data Modelling |
| 6 |
Friday |
14:05 |
Introduction to Computing |
Hardware vs Software; Operating Systems vs Applications; Programming Languages and Platforms |
| 7 |
Friday |
15:10 |
Introduction to Computing |
Operating Systems in Practice: Windows vs Linux; Free Software, Open Source, Licences and Community |
| 8 |
Friday |
16:10 |
Introduction to Computing |
Hands-On: Installing Oracle Linux on a Virtual Machine |
| 9 |
Friday |
17:10 |
Introduction to Databases |
Key Database Technologies, Data Structures and Paradigms |
| 10 |
Friday |
18:15 |
Introduction to SQL |
Hands-On: Creating Tables, Populating and Projecting Data, Schemas and Tablespaces; Data Types, Key Modelling and Integrity Constraints |
| 11 |
Friday |
19:15 |
Introduction to Computing |
Introduction to Programming, Algorithms, Variables, Conditionals, Functions and Data Structures |
| 12 |
Friday |
20:15 |
Introduction to Databases |
Multi-Tier Applications; The Oracle Technology Portfolio; Product Versioning |
| 13 |
Friday |
21:20 |
Introduction to SQL |
Introduction to SQL: DDL, DML, DCL, TCL, DQL. SQL Syntax and Transactions |
| 14 |
Friday |
22:20 |
Introduction to SQL |
Core Syntax: SELECT; Projecting Columns; Column Lists; Table Structures, Aliasing and Prefixing |
| 15 |
Friday |
23:20 |
Introduction to SQL |
Functions and Notation; Arithmetic and Aggregate Operations (Hands-On) |
| 16 |
Saturday |
00:25 |
Introduction to SQL |
Simple and Compound Filters; Sorting and Grouping (Hands-On) |
| 17 |
Saturday |
01:25 |
Introduction to SQL |
Numeric and String Functions; Format Masks; Type Conversion and Casting |
| 18 |
Saturday |
02:25 |
Introduction to SQL |
Conditional Queries: CASE and DECODE; Regular Expressions |
| 19 |
Saturday |
03:30 |
Introduction to SQL |
SQL CHALLENGE |
| 20 |
Saturday |
04:30 |
Introduction to SQL |
SQL Challenge Review |
| 21 |
Saturday |
05:30 |
Introduction to Databases |
Constraints; Views; Materialised Views; Sequences; Types; Auto-increment |
| 22 |
Saturday |
06:35 |
Introduction to Databases |
Synonyms; Database Links; Heterogeneous Services and Data Integration |
| 23 |
Saturday |
07:35 |
Introduction to SQL |
Set Operations and Subqueries |
| 24 |
Saturday |
08:35 |
Introduction to SQL |
Joins (Inner, Left, Right, Full, Cross, Natural) + Antijoins and Semi-Joins |
| 25 |
Saturday |
09:40 |
Introduction to SQL and Databases |
Indexes and SQL |
| 26 |
Saturday |
10:40 |
Introduction to SQL |
CTEs vs Temporary Tables vs Materialised Views; OVER PARTITION; Compound Inserts |
| 27 |
Saturday |
11:40 |
Introduction to SQL |
SQL Performance and Transaction Control: Locks |
| 28 |
Saturday |
12:45 |
Introduction to Computing |
Parallel Programming and Parallelism; Classic Problems and Race Conditions |
| 29 |
Saturday |
13:45 |
Database Administration |
The Basic Structure of an Oracle Instance; Key Processes and Memory Structures |
| 30 |
Saturday |
14:45 |
Database Administration |
Physical Structures and Data Storage in Oracle; Undo and Redo Logs |
| 31 |
Saturday |
15:50 |
Database Administration |
Hands-On: Preparing the Server for OUI and GUI; Prerequisites; Compatibility and Technical Documentation |
| 32 |
Saturday |
16:50 |
Database Administration |
Hands-On: OUI with a Response File; Optimal Flexible Architecture; Oracle Managed Files |
| 33 |
Saturday |
17:50 |
Database Administration |
Hands-On: OUI via the Command Line; Automatic Diagnostic Repository |
| 34 |
Saturday |
18:55 |
Database Administration |
Hands-On: Database Configuration Assistant (DBCA); NETCA |
| 35 |
Saturday |
19:55 |
Database Administration |
Multitenant Architecture; Startup and Shutdown Modes |
| 36 |
Saturday |
20:55 |
Database Administration |
Logs and Diagnostic Files: Alert Logs, Traces, Dumps |
| 37 |
Saturday |
22:00 |
Database Administration |
Hands-On: Log Multiplexing; Sizing Redo Logs |
| 38 |
Saturday |
23:00 |
Database Administration |
Hands-On: Converting Non-CDB to Multitenant; Cloning PDBs |
| 39 |
Saturday |
00:00 |
Database Administration |
Labs on Non-CDB to Multitenant Conversion and PDB Cloning |
| 40 |
Sunday |
01:05 |
— |
REST |
| 41 |
Sunday |
02:05 |
High Availability |
Clustering Fundamentals: Oracle RAC |
| 42 |
Sunday |
03:05 |
High Availability |
Standby and Oracle Data Guard; Physical and Logical Standby; DG Broker |
| 43 |
Sunday |
04:05 |
High Availability |
Oracle GoldenGate; Oracle Enterprise Manager; Oracle ODI and other tools |
| 44 |
Sunday |
05:10 |
High Availability |
Oracle Maximum Availability Architecture (MAA); Resource Manager and Best Practices |
| 45 |
Sunday |
06:10 |
Database Administration |
Oracle Versioning and Licensing Basics; Oracle Packs and Options; Certification Paths |
| 46 |
Sunday |
07:10 |
Database Administration |
Data and Object Administration: Users; Privileges; Roles; Passwords and Tablespaces |
| 47 |
Sunday |
08:15 |
High Availability |
Oracle ASM: Fundamentals; Mirroring and Striping; ASMLib; ASM Filter Driver |
| 48 |
Sunday |
09:15 |
High Availability |
Oracle ASM — Installation and Initial Configuration |
| 49 |
Sunday |
10:15 |
High Availability |
Oracle ASM — Basic Administration; ASMCMD; Oracle High Availability Services (OHAS) |
| 50 |
Sunday |
11:20 |
High Availability |
Oracle ASM — Managing Disks and Diskgroups; Failgroups; KFED; KFOD |
| 51 |
Sunday |
12:20 |
High Availability |
Hands-On: ASM Exercises; Installing a Database with ASM |
| 52 |
Sunday |
13:20 |
High Availability |
Hands-On: Disk Loss; VM Corruption; Disaster Scenarios |
| 53 |
Sunday |
14:25 |
High Availability |
Backup and Disaster Recovery: RPO vs RTO vs SLAs; Introduction to RMAN |
| 54 |
Sunday |
15:25 |
High Availability |
Configuring RMAN Backup on the Database and the FRA |
| 55 |
Sunday |
16:25 |
High Availability |
Backup Strategies and How to Implement Them |
| 56 |
Sunday |
17:30 |
High Availability |
Hands-On: RMAN and Data Loss |
| 57 |
Sunday |
18:30 |
High Availability |
DBV; Backup Validation and Other Tools; Recovery Catalog |
| 58 |
Sunday |
19:30 |
High Availability |
RMAN: Duplexing; Encryption; Compression; Retention |
| 59 |
Sunday |
20:35 |
High Availability |
Other Data Loading Tools: Data Pump; Export/Import; SQL*Loader; and others |
| 60 |
Sunday |
21:35 |
High Availability |
Database Jobs; Traces |
| 61 |
Sunday |
22:35 |
Performance Tuning |
TKProf and Other Tools for Trace Analysis |
| 62 |
Sunday |
23:40 |
— |
REST |
| 63 |
Monday |
00:40 |
Performance Tuning |
Introduction to Oracle Tuning: OWI; General Concepts and Best Practices |
| 64 |
Monday |
01:40 |
Performance Tuning |
Best Practices for Configuring Servers, the OS and Basic Infrastructure |
| 65 |
Monday |
02:40 |
Performance Tuning |
Best Practices for Configuring Databases for Performance |
| 66 |
Monday |
03:45 |
Performance Tuning |
Common Mistakes and Hands-On |
| 67 |
Monday |
04:45 |
Performance Tuning |
Best Practices for Database Modelling |
| 68 |
Monday |
05:45 |
Performance Tuning |
Best Practices for Writing SQL |
| 69 |
Monday |
06:50 |
Performance Tuning |
Tuning Tools |
| 70 |
Monday |
07:50 |
Security |
Database Security: DBSAT, Oracle Auditing, Advanced Security, Label Security, Database Vault and Others |
| 71 |
Monday |
08:50 |
Security |
Additional Tools for Database Configuration and Assessment |
| 72 |
Monday |
10:00 |
Cloud Computing |
Introduction to Cloud Computing; OCI: Key Components |
| 73 |
Monday |
10:55 |
Cloud Computing |
Oracle Database as a Service and Its Specifics |
| 74 |
Monday |
12:00 |
Cloud Computing |
Hands-On: Launching an Oracle Instance on the Free Tier |
| 75 |
Monday |
13:00 |
— |
REST |
| 76 |
Monday |
14:00 |
Artificial Intelligence |
Oracle Vector Database |
| 77 |
Monday |
15:00 |
Artificial Intelligence |
Oracle Database AI and Best Practices |
| 78 |
Monday |
16:00 |
Artificial Intelligence |
Oracle as a Multimodel Database |
| 79 |
Monday |
17:15 |
Artificial Intelligence |
Configuring RAG on Oracle Database |
| 80 |
Monday |
18:30 |
DBA |
Best Practices and Tuning for AI |
| 81 |
Monday |
19:00 |
— |
RECORD ESTABLISHED |