Course Overview
This 5-day, 20-hour immersive program equips IT professionals with end-to-end knowledge of applying AI in Oracle APEX environments. Participants will explore Oracle’s AI-powered features in APEX 24.2 and Oracle 23ai, including the AI Assistant, vector search, OCI AI Services, and application security and prompt engineering best practices. Each day blends theoretical instruction with high-impact workshops that challenge learners to think like problem-solvers — not button-clickers.
Schedule Overview
| Day | Focus | Modules |
|---|---|---|
| Monday | Foundations of AI in Oracle APEX | 1–4 |
| Tuesday | AI Assistant & App Development | 5–8 |
| Wednesday | Vector Search & Contextual Intelligence | 9–12 |
| Thursday | OCI AI Services | 13–16 |
| Friday | Ethics, Security, Optimization | 17–20 |
Prerequisites
Familiarity with APEX app development and basic SQL/PLSQL. No AI or OCI experience required.
Technical Requirements
Nothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here.
Tip: We strongly recommend using two monitors for this class.
Course Features
- Lecture 0
- Quiz 0
- Duration 5 Half Days (~20 hours)
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
Day 1 – Foundations of AI in Oracle APEX
Module 1 – Introduction to AI for APEX Developers
Topics
- Course overview and structure
- What is AI? Definitions and domains
- AI vs traditional automation
- Key enterprise use cases
- The evolution of AI in Oracle
- AI + APEX = next-level development
- AI-enhanced decision making
- Risk, hype, and realism
- What this course covers
- What you’ll walk away with
- Setup & environment notes
Module 2 – Oracle APEX 24.2 AI Features Overview
Topics
- APEX + AI: a natural fit
- Meet the APEX AI Assistant
- From idea to page in seconds
- Code generation with context
- AI in SQL Workshop
- AI for app tuning and edits
- Templates, wizards, and accelerators
- Smart features enhance UI/UX
- APEX version-specific highlights
- When (not) to use the Assistant
Module 3 – AI Fundamentals in Oracle 23ai
Topics
- What is Oracle 23ai?
- Introduction to vector data types
- Semantic search vs traditional search
- Embeddings explained simply
- Oracle AI Vector Search integration
- Creating and storing vectors
- Querying vectors for similarity
- APEX + vectors = smarter UIs
- Preview: embedding models from OCI
- Summary: you now own Search 2.0
Module 4 – Data Privacy and Ethics in AI Apps
Topics
- Why privacy matters in AI development
- Understanding personally identifiable information (PII)
- Prompt injection & data leakage risks
- Obfuscation techniques for display
- Anonymization and data minimization
- Transparent AI behavior
- Logging & auditing AI interactions
- Consent & disclaimers for AI features
- Oracle’s position on ethical AI
- Preparing users to trust AI features
Day 2 – AI Assistant and App Development
Module 5 – AI-Powered Page Creation
Topics
- The Assistant as a page generator
- Supported page types and their use cases
- Prompt templates for different components
- Overriding defaults with precision
- Performance implications of auto-generated pages
Module 6 – AI Assistant for SQL Development
Topics
- Assistant integration in SQL Workshop
- Common prompt styles and patterns
- Understanding the generated output
- Rewriting and explaining existing queries
- Security considerations
Module 7 – Assistant-Driven Form Generation
Topics
- Single-table form generation
- Master-detail logic through prompting
- Defaults, validations, and calculations
- Reviewing Assistant logic in Page Designer
- Common edits and fix-ups
Module 8 – Smart Filters and Assisted Search
Topics
- What are smart filters?
- When to use smart filters
- Building filters with Assistant
- Enhancing the user experience
- Performance and security
Day 3 – Vector Search and Contextual Intelligence
Module 9 – Introduction to Vector Search in Oracle 23ai
Topics
- What are embeddings and why they matter
- Vectors in Oracle 23ai: the “VECTOR” data type
- How vector search differs from traditional WHERE clauses
- Embedding strategies for APEX
- Using embeddings in end-user features
Module 10 – Scoring Results with VECTOR_COSINE_DISTANCE
Topics
- What is cosine distance?
- Introducing VECTOR_COSINE_DISTANCE()
- Using bind variables for live input
Module 11 – Building Semantic Search Interfaces in APEX
Topics
- Overview of semantic UIs
- Mocking the embedding process for demos
- Building the interaction flow
Module 12 – Contextual Filters with Tags or Topics
Topics
- Combining AI and metadata for precision
- Best practices for tagging
- Query structure with context
Day 4 – OCI AI Services in Oracle APEX
Module 13 – Introduction to OCI AI Services
Topics
- What are OCI AI Services?
- When should you use OCI services?
- AI without complexity
- Authentication and security
- What you’ll be building:
- Analyzing sentiment
- Extracting data from uploaded documents
- Object detection in uploaded photos
Module 14 – Integrating OCI Language AI for Sentiment and Key Phrases
Topics
- Language AI capabilities
- APEX integration flow
- Input best practices
Module 15 – Document Understanding with OCI
Topics
- How Document Understanding works
- Supported file types and best practices
- Interpreting the response
Module 16 – Adding Image Intelligence via OCI Vision AI
Topics
- Vision AI use cases
- Image workflow in APEX
- Limits and biases
Day 5 – Ethics, Security, and Optimization in APEX + AI
Module 17 – Responsible AI: Bias, Trust, and Explainability
Topics
- The problem of bias
- Explainability and user consent
- Testing for fairness and inclusivity
Module 18 – Securing AI Data Flows
Topics
- Review of risks
- APEX-specific best practices
- Prompt injection protection
Module 19 – Performance and Cost Optimization
Topics
- Understanding latency and limits
- Caching and reuse
- Asynchronous processing patterns
Module 20 – Scaling AI-Aware APEX Apps
Topics
- Logging and auditing interactions
- Monitoring API usage and errors
- Future-proofing prompt templates
