home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data et analyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
Oracle Application Express (Apex)

Objectives

This course provides students with product knowledge and skills needed to Develop Basic Database Driven Web Applications.

At the end of the course, students will be able to:

  • Install and configure Oracle Application Express;
  • Develop a database-centric Web application;
  • Utilize and manage Shared Components in an application;
  • Build queries of database objects and incorporate them in an application;
  • Manage users and groups;
  • Manage Access Control by authorizing and authenticating users;
  • Administer Oracle Application Express Workspaces;
  • Load and unload data or application com

Main topics

  • Introducing APEX
  • Architecture
  • Basics of Oracle Web Applications
  • Managing Workspaces
  • User Roles
  • Starting with Oracle APEX
  • Language issues
  • Building an Application
  • From scratch
  • From Spreadsheet
  • Import and Export
  • Creating Reports
  • Creating reports from scratch
  • Interactive reports
  • Report headers
  • Report templates
  • Break formatting
  • Column formatting
  • Creating Forms
  • Creating a form on a table with report
  • Creating a tabular form
  • Creating a master detail form
  • Editing form attributes
  • Pages and Regions
  • Pages
  • Page Definition
  • Page rendering and Page processing
  • Page manipulations
  • Page Zero
  • Regions
  • Region Definition
  • Items and Buttons
  • Items
  • Buttons
  • Button names
  • Shared components
  • List of Values
  • Types of LOV's
  • Themes and Templates
  • Definitions
  • Themes and Applications
  • Templates
  • Template type and Classes
  • Template Files
  • Template Subscriptions
  • Navigation and Layout
  • Tabs
  • Navigation Bars
  • Breadcrumbs
  • Lists
  • Trees
  • Implementing Security
  • Pre-configured authentication schemes
  • Creating an authentication scheme
  • Application Express account credentials
  • Custom authentication
  • Session State Protection (SSP)
 

Intended for

This course is intended for Web Application Developers who have experience with Microsoft Access, Oracle Developer Suite and PL/SQL.

Background

Before attending this course, students must have a basic knowledge of the Microsoft Windows operating system and its core functionality, a working knowledge of relational databases and SQL (see SQL and relational databases fundamentals), and some experience with PL/SQL (see PL/SQL database programming). In addition, it is recommended, but not required, that students have basic knowledge of HTML and CSS (see HTML5).

Training method

Class training alternated with exercises. Each student disposes of a workstation.

Course leader

Kris Van Thillo.

Duration

2 days.

Schedule

Vous pouvez vous inscrire en cliquant sur une date
dateduréelang.  lieu  prix
29 Jun2?Leuven  (BE)850 EUR  (excl. TVA) 
30 Nov2?Leuven  (BE)850 EUR  (excl. TVA) 
21 Dec2NWoerden  (NL)850 EUR  (exempte de TVA) 

Score global

   
4.4/5 (basé sur 17 évaluations)

Reviews

     
Goed, geeft een goed overzicht wat APEX is en kan (, )
     
Prima cursus, voldoende handvatten om verder mee aan de slag te kunnen. (, )
     
Goed. Beter op 3 of 4 dagen (, )
     
Cursus over 3 dagen had beter geweest (, )
     
Goed overzicht als basis (, )
     
Zeer goed. Cursus in 2 dagen is misschien wat kort (, )
     
Heel goed (, )
     
heel goed, maar ook heel veel informatie in één keer (, )
     
uitstekend (, )