This course provides students with product knowledge and skills needed to develop database driven web applications with Oracle Application Express (APEX).

At the end of the course, students will:

• understand the APEX architecture (instance - workspace - application);
• be able to use the 'SQL Workshop & Utilities' component of APEX;
• be able to develop data(base)-centric web applications - focusing on the development of new, full-functioning APEX applications;
• be able to build and use application components to be integrated in APEX applications;
• be able to build and use navigation components integrated in APEX - including the use of Shared Components in an APEX application;
• understand workspace management - manage workspace users and groups; import/export workspaces and applications.

Schedule

datum	duur	taal	plaats	prijs
25 Nov	3	?	Woerden  (NL)	1275 EUR  (BTW-vrij)	gegarandeerd
SESSIE-INFO EN INSCHRIJVEN

Intended for

This course is intended for web application developers in an Oracle APEX context who want to build data(base) driven websites. Reference Oracle APEX versions: 18.1 and 19.1.

Background

Before attending this course, students must have a working knowledge of relational databases and SQL (see SQL and relational databases fundamentals); some experience with PL/SQL (see PL/SQL database programming) might come in handy. For more advanced topics - typically beyond the scope of this text - it is recommended, that students have basic knowledge of HTML and CSS (see HTML5).

Main topics

• Introducing APEX
• Architecture: instance - workspace - application
• Managing Workspaces - managing users
• Starting with Oracle APEX
• Building an Application
• Basics of APEX application development
• From scratch - (From Spreadsheet - Building WebSheets)
• Import and Export (Workspaces, Applications)
• About Pages and Regions:
• Pages: Page Definition, Page rendering and Page processing, Page manipulations, Page Zero
• Regions: Region Definition
• About Themes and Templates - and overruling settings and attributes
• Application components (I) - Creating Reports
• Creating reports from scratch
• Creating distinct report 'types' (classic, interactive, subtype and special reports)
• Report headers - report templates - break formatting - column formatting
• Navigation and Layout
• The APEX List Manager: Lists, List regions, Trees
• Application Navigation Interface
• Breadcrumbs
• Session management - State management
• Application components (II) - Creating Forms & Items
• Creating forms from scratch
• Creating distinct form 'types' (procedure, table, master detail, interactive grid, SQL based, ...)
• Editing form attributes - form specifics
• Items
• Buttons
• Buttons
• Shared components
• List of Values - Types of LOVs
• Lists
• (substitution) variables

Training method

Class training alternated with exercises (60% of the allocated time is dedicated to exercises). Each student receives and individual APEX environment.

Duration

3 days.

Course leader

Kris Van Thillo.

Ververs deze pagina om andere commentaren te zien.

Ook interessant

Cursisten van deze training hebben ook volgende cursussen gevolgd:

• Python: basiscursus
• Oracle basiscursus
• PL/SQL database programmeren
• Linux/UNIX basiscursus