ORACLE APEX / 2-MONTH ONLINE COURSE
Turn business ideas into
useful applications.
A structured, practical 2-month course with 8 planned teaching weeks. Learn through demonstrations, guided practice, weekly assignments and a final project.
3 classes per week · 1 hour per class
Teaching plan: 8 weeks × 3 classes × 1 hour = 24 live hours. Calendar dates and holiday adjustments are confirmed in the batch timetable. Independent practice is additional.
YOUR LEARNING OUTCOMES
Build skills you can put to work.
WHO THIS IS FOR
Start with curiosity.
Progress through practice.
Students, aspiring application developers and professionals interested in business applications.
Your starting point
- Basic computer and browser skills
- Comfort with spreadsheets and tabular data
- Basic SQL is helpful; foundations are included
- No prior APEX experience required
TOOLS & SETUP
Be ready for the first class.
A laptop or desktop, reliable internet and an APEX workspace. Workspace access is arranged or confirmed before the batch; do not purchase hosting before confirming requirements.
Recommended independent practice: 2–3 hours per week, in addition to live classes.
THE COMPLETE STUDY PLAN
8 weeks.
A practical path forward.
Each week contains three instructor-led classes and an independent deliverable. Open a module to see the class-by-class plan.
Week 1: Workspace & SQL foundations
WEEK 1 · CLASSES 1–3 · 3 LIVE HOURS
- Class 1Workspace setup, App Builder and SQL Workshop
- Class 2Tables, data types, primary keys and constraints
- Class 3SELECT, WHERE and sorting with a sample product table
Practice & deliverable: Create a product dataset and query worksheet.
Week 2: Relational data & business queries
WEEK 2 · CLASSES 4–6 · 3 LIVE HOURS
- Class 4INSERT, UPDATE, DELETE and transaction basics
- Class 5Relationships, joins and aggregate queries
- Class 6Introductory PL/SQL blocks and simple business rules
Practice & deliverable: Model customers, orders and order items.
Week 3: Your first working APEX application
WEEK 3 · CLASSES 7–9 · 3 LIVE HOURS
- Class 7Create an application and understand Page Designer
- Class 8Build a report-and-form CRUD flow
- Class 9Form items, validations and friendly error messages
Practice & deliverable: Deliver a customer management mini-app.
Week 4: Reports, grids & useful dashboards
WEEK 4 · CLASSES 10–12 · 3 LIVE HOURS
- Class 10Interactive reports, filters and saved views
- Class 11Editable interactive grids and constraints
- Class 12Charts, dashboard layout and midpoint practical review
Practice & deliverable: Build a searchable sales dashboard.
Week 5: Business flows & dynamic actions
WEEK 5 · CLASSES 13–15 · 3 LIVE HOURS
- Class 13Master-detail pages for orders and line items
- Class 14Dynamic actions, conditions and computations
- Class 15Page processes and server-side validation
Practice & deliverable: Implement order entry with totals and validation.
Week 6: Security & application usability
WEEK 6 · CLASSES 16–18 · 3 LIVE HOURS
- Class 16Authentication versus authorization and user roles
- Class 17Session state protection and safe data handling
- Class 18Navigation, Universal Theme and responsive checks
Practice & deliverable: Restrict editing by role and test access rules.
Week 7: Integration basics & delivery workflow
WEEK 7 · CLASSES 19–21 · 3 LIVE HOURS
- Class 19Guided REST data source demonstration using a public API
- Class 20Debugging, application export/import and release checklist
- Class 21Capstone build clinic and defect review
Practice & deliverable: Prepare an exportable capstone candidate.
Week 8: Capstone, verification & presentation
WEEK 8 · CLASSES 22–24 · 3 LIVE HOURS
- Class 22Complete the inventory/order flow and documentation
- Class 23Run functional, permission and responsive checks
- Class 24Final demonstration, feedback and improvement plan
Practice & deliverable: Present the Inventory & Order Management App.
THE FINAL CAPSTONE
Inventory & Order Management App
Build a small application with products, customers, orders and order items; stock validation, an order report, a summary dashboard and controlled user access. Keep the scope to one working business flow.
Build progressively, review the draft and use the final week to refine, test and present your work.
What you finish with
- Application export and database setup script
- Schema diagram and sample data
- Test checklist covering invalid inputs and access rules
- Short user guide and live walkthrough
A working project or portfolio you can present, with the decisions and process behind it.
HOW YOU WILL LEARN
Learn. Practice.
Review. Improve.
Each 60-minute class balances a focused explanation (10 minutes), instructor demonstration (15 minutes), guided build (25 minutes) and questions or review (10 minutes).
Weekly assignments develop independence. Keep your files organised, submit your work for review and apply feedback to the next version.
RECOMMENDED ASSESSMENT
Progress measured through your work.
Suggested weighting for this study plan; the academy confirms grading and completion requirements before the batch.
Show your progress.
Course completion certificate, recommendation letter and course/program details. Completion requirements are confirmed by the academy.
Explore your next opportunity.
Ask about relevant online internships, eligibility and availability after developing your skills.
Find the current offer.
Contact our team for fees, admission discounts and the next batch date.
BEFORE YOU JOIN
Your questions, answered.
How long is the course?
2 months, with 3 classes per week and 1 hour per class. The syllabus uses 8 teaching weeks, 24 sessions and 24 live hours. Exact dates follow the batch calendar.
Is this suitable for beginners?
Basic computer and browser skills. Comfort with spreadsheets and tabular data. Basic SQL is helpful; foundations are included. No prior APEX experience required. Share your experience with our team before enrolling.
Do I need to practise outside class?
Yes. Plan for 2–3 hours per week of independent practice. This is additional to 3 live hours per week.
Which tools will I need?
A laptop or desktop, reliable internet and an APEX workspace. Workspace access is arranged or confirmed before the batch; do not purchase hosting before confirming requirements.
What will I build?
Inventory & Order Management App. Weekly exercises prepare you for the capstone; the deliverables and class plan are listed above.
What are the fees and class timings?
Message the academy for the next batch dates, session timings, fees and available discounts.
Is a job or internship guaranteed?
No. Online internship opportunities depend on eligibility and availability. Course completion does not guarantee employment.
Official learning references
Supporting resources for further study. This is Pixora Academy’s course plan, not a claim of vendor accreditation.
Oracle APEX features ↗Oracle APEX getting started ↗ORACLE APEX / 2 MONTHS
Ready to start building?
Get the next batch timetable and admission details.