Visa utbildning.se som: Mobil

Oracle Application Express – Level 1

Informator
Kort om utbildningen
3 dagar
20 150 SEK Momsfri
Nästa tillfälle: Efter överenskommelse - Distans
Onlineutbildning
   
Distans

Kursbeskrivning



This level 1 course is for anyone who wants to learn the basics of Application Express (APEX)

Introducing Application Express

What is Application Express(APEX)
Benefits of APEX
History of APEX
Architecture Overview - logical and physical
APEX Repository Overview
Out of the box development features
SQL Developer and APEX
Building integrated applications
Integrating APEX & BI Publisher

Getting Started with Application Express

What is a Workspace?
Different types of APEX users
How to access APEX
Application Express Components
What is an Application?
What is a Packaged Application?

Working with the SQL Workshop

What is SQL Workshop?
Browsing, creating and modifying objects
Processing ad hoc SQL and PL/SQL statements
Managing scripts
Using the Utilities

Creating a Database Application

Types of Application
Components of an application
Application Builder Home Page
An Application's Home Page
Page Definition
Creating an application from scratch
Creating an application from a spreadsheet

Creating Forms

Different Types of Forms
Creating Forms based on a Table or a View
Running the Page and the Developer Toolbar
Page Definition
Creating Tabular Forms
Creating Master-Detail Forms

Creating Reports

Types of Reports
Creating Wizard Reports
Linking a Report to a Form
Creating SQL or Classic Reports
Creating Interactive Reports

Understanding Pages and Regions

What is a Page in APEX?
Different Sections of a Page
Page Rendering
Page Processing
Shared Components
Page Attributes
What is a Region?
Lists, Breadcrumbs and Calendar Regions
Positioning Regions

Working with Items & Buttons

Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
Types of Buttons
Creating a Report Filter

Page Processing

Types of Page Processing
Types of Computations
Types of Processes
Types of Validations
Types of Branches

Understanding Session State

Understanding Sessions
Session IDs and APEX URLs
What is Session State?
Viewing Session State
Referencing Session State in your Application
In-built Substitution Variables
f?p syntax example

Working with Shared Components

What is a Shared Component?
Types of Shared Components
What are List of Values (LOVs)?
Creating Cascading LOVs
Uploading and Referencing Images
Application Items, Computations and Processing
Creating Tabs

Themes and Templates

Understanding Themes
Switching Themes
Changing Theme Defaults
Understanding Templates in APEX
Understanding CSS in APEX
How to incorporate your own look and feel by customizing themes, templates & CSS

Oracle APEX Workspace Administration

Workspace Administration Topics
Manage Services
Manage Users and Groups
Monitor Activity
Dashboards
Workspace Utilization
Feedback Form
Team Development

APEX Security Features

Understanding the Security Options in APEX
Creating Custom Authentication
Understanding Authorization - Access Control Page
Session State Protection.

Packaging & Deploying Applications

Understanding Different Deployment Options
Exporting an Application
Including Supporting Objects
Importing and Installing an Application

 

 

Introducing Application Express

What is Application Express(APEX)
Benefits of APEX
History of APEX
Architecture Overview - logical and physical
APEX Repository Overview
Out of the box development features
SQL Developer and APEX
Building integrated applications
Integrating APEX & BI Publisher

Getting Started with Application Express

What is a Workspace?
Different types of APEX users
How to access APEX
Application Express Components
What is an Application?
What is a Packaged Application?

Working with the SQL Workshop

What is SQL Workshop?
Browsing, creating and modifying objects
Processing ad hoc SQL and PL/SQL statements
Managing scripts
Using the Utilities

Creating a Database Application

Types of Application
Components of an application
Application Builder Home Page
An Application's Home Page
Page Definition
Creating an application from scratch
Creating an application from a spreadsheet

Creating Forms

Different Types of Forms
Creating Forms based on a Table or a View
Running the Page and the Developer Toolbar
Page Definition
Creating Tabular Forms
Creating Master-Detail Forms

Creating Reports

Types of Reports
Creating Wizard Reports
Linking a Report to a Form
Creating SQL or Classic Reports
Creating Interactive Reports

Understanding Pages and Regions

What is a Page in APEX?
Different Sections of a Page
Page Rendering
Page Processing
Shared Components
Page Attributes
What is a Region?
Lists, Breadcrumbs and Calendar Regions
Positioning Regions

Working with Items & Buttons

Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
Types of Buttons
Creating a Report Filter

Page Processing

Types of Page Processing
Types of Computations
Types of Processes
Types of Validations
Types of Branches

Understanding Session State

Understanding Sessions
Session IDs and APEX URLs
What is Session State?
Viewing Session State
Referencing Session State in your Application
In-built Substitution Variables
f?p syntax example

Working with Shared Components

What is a Shared Component?
Types of Shared Components
What are List of Values (LOVs)?
Creating Cascading LOVs
Uploading and Referencing Images
Application Items, Computations and Processing
Creating Tabs

Themes and Templates

Understanding Themes
Switching Themes
Changing Theme Defaults
Understanding Templates in APEX
Understanding CSS in APEX
How to incorporate your own look and feel by customizing themes, templates & CSS

Oracle APEX Workspace Administration

Workspace Administration Topics
Manage Services
Manage Users and Groups
Monitor Activity
Dashboards
Workspace Utilization
Feedback Form
Team Development

APEX Security Features

Understanding the Security Options in APEX
Creating Custom Authentication
Understanding Authorization - Access Control Page
Session State Protection.

Packaging & Deploying Applications

Understanding Different Deployment Options
Exporting an Application
Including Supporting Objects
Importing and Installing an Application

Hur påverkar COVID-19 denna utbildning?

Vi på utbildning.se är övertygade om att kunskap driver människor och organisationer framåt. Det gör även de arrangörer vi samarbetar med.
Många utbildningar ställs exempelvis om från klassrums- till distansutbildning.

För att ta reda på om en utbildning påverkas med anledning av COVID-19, kontakta gärna arrangören.

Intresseanmälan

Fyll i formuläret för att få mer information om Oracle Application Express – Level 1, direkt från arrangören. Det är gratis och inte bindande!

Informator

Informator

Utbildningsutbud

Informator är utbildningsföretaget som stärker din konkurrenskraft genom att underhålla, uppdatera och tillföra relevant kunskap inom IT och management där och när du behöver det. Vi har vuxit tillsammans med svensk mjukvaruindustris ledande företag och utbildat utvecklare, tekniker, projektledare och chefer sedan...


Läs mer om Informator och visa alla utbildningar.

Kontaktuppgifter

Informator

Karlavägen 108
115 26 Stockholm

 Visa telefonnummer

Intresseanmälan

För att få mer information om utbildningen Oracle Application Express – Level 1 från Informator, fyll i dina uppgifter:

Recensioner
Kursrecensioner
Bli den första att recensera Oracle Application Express – Level 1!

Arrangörsrecensioner
(4,5)
Baseras på 712 recensioner.
Alla recensioner för arrangören

Liknande utbildningar