Bundle Course - Oracle APEX and APEX AdminLearn Oracle Application Express (APEX) from scratch & develop web-based applications. Manage APEX instances, configuration, metadata, user, workspace
Preview Bundle Course - Oracle APEX and APEX Admin coursePrice Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate
- 83% Started a new career
BUY THIS COURSE (
USD 23 GBP 49)
- 79% Got a pay increase and promotion
Students also bought -
- Oracle Forms
- 10 Hours
- GBP 12
- 799 Learners
- Career Path - Oracle Consultant
- 200 Hours
- USD 45
- 6123 Learners
- Oracle ICS (Integration Cloud Service)
- 20 Hours
- USD 17
- 58 Learners
Uplatz provides this bundle course on:
1) Oracle APEX
2) Oracle APEX Administration
Oracle Application Express (APEX) is a free Oracle product that enables developers to quickly create web-based applications on an Oracle database by using just a web browser. The APEX tool runs in a web browser and allows the creation of web applications in a declarative manner, by simply selecting pre-built components, configuring them and bundling them up in a web application, all without the need to write too much code.
APEX is a web application that is tightly coupled to an Oracle database. It has several uses: you can use its SQL Workshop tool to query the database, modify its contents, or change its structure; you can use its Application Builder tool to create your own web applications that interact with the database, and you can run the web applications created by you and others.
The APEX application builder is especially interesting because it provides a simple, nontraditional way to build web pages. You do not specify code for the page directly; instead, you choose from a set of built-in templates. There is a template for the overall page and templates for each kind of component that you want to put on the page (such as reports, buttons, and so on). Each template has a set of properties, whose values determine where each component is located on the page, what it looks like, and how it behaves. You create a page simply by choosing templates for the components you want and assigning values to their properties.
Instance administrators manage an entire APEX hosted instance using the Oracle APEX Administration Services (Administration Services) application. Their key tasks are:
1) Understanding Administration Services
2) Managing Requests
3) Managing Feature Configuration
4) Configuring Oracle APEX Security
5) Configuring Oracle APEX Instance Settings
6) Purging Inactive Workspaces
7) Managing Public Themes
8) Managing Meta Data
9) Installing Exported Applications in Oracle Application Express Runtime Environment
10) Communicating Using Messages, Banners, and Resources List
11) Creating a Service Signup Wizard
12) Managing Schemas
13) Creating Workspaces in Administration Services
14) Managing Existing Workspaces
15) Managing Users Across an Oracle APEX Instance
16) Monitoring Activity Across an Oracle Application Express Instance
17) Configuring and Deleting Logs and Log Entries
Course/Topic 1 - Oracle APEX - all lectures
This video entails the terms Oracle Application Express (APEX) which is an easy to use platform for developing data-centric web-based applications. Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.
In the lecture you will learn about the App Builder which is a low code, high productivity integrated development environment where you can develop applications on top of your data.
This video shows Oracle Forms and Reports, there are several options available to you to modernize the web stack. Some of these options, place a facade on Oracle Forms, requiring customers to pay ongoing support and maintenance fees for Oracle Forms and Reports as well as the Web logic licensing to support these technologies.
In this video you will learn about build pages in the Page which is Designer by dragging components from the Components palette and positioning them on the canvas to create business objects, design forms and to organize page elements.
In this tutorial you will see master detail form which reflects a one to many relationships between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows. When you create a master detail form using the Create Page or Create Application Wizards, you choose the tables on which to build the master form and the detail form.
In this video you will learn about Column attributes enable developers to control the display, features, and column behavior. Developers edit Column attributes to alter nearly all aspects of column behavior, including altering the layout and appearance, defining column links, creating column filters, and adding support for export and printing.
In this tutorial you will learn about an interactive grid presents users which is a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page and the interactive reports enable the user to customize the appearance of the data through searching, filtering, sorting, column selection, highlighting, and other data manipulations.
This Video Covers Menu in Oracle Apps Menu which is nothing but a logical or hierarchical listing of functions (forms) so that the user can easily navigate through the forms once he is in a responsibility. Every responsibility will be assigned only one main menu. Under that main menu, you can have either have other sub menus or functions.
In this tutorial you will cover APEX Tree region is intentionally very simple. It is just for display of a hierarchy with simple single selection or navigation. The tree View widget can do much more but the “documentation” is only in the source file. Also it can be difficult to change some settings because you don’t have direct access to how the widget is created
This Tutorial Video teach you about Oracle provides a number of authentication and authorization which is a mechanisms to meet user requirements, from simple locally based password authentication to centralized directory service integration to handle both authentication and authorization.
In this video you will learn about the page which is the basic building block of a database application. Individual pages are organized using containers called regions.
In this session you will learn about the A template has what you need to get started with a site, including the site code framework, a default site with sample pages and content, a theme with styling, resources such as images, and even custom components. A theme defines the general look-and-feel the overall style of a site, including color scheme, font size, font type, and page backgrounds.
This Video Tutorial will teach you about the validation which is an edit check. Validations specific to a single item are page item validations. Validations that apply to an entire page are page validations. Validations for tabular forms specific to a single column are column level validations. Validations for tabular forms that do not apply to a single column are tabular form row validations.
This session will teach you about the page process which performs an action at a specified point during the rendering or submission of the page. For example, you can create a page process to execute logic or to make a call to the Application Express engine. A page process is a unit of logic that runs when a specific event occurs, such as loading or submitting a page.
This video will teach you about the how to create a Branch Process to open another page after submitting the current page. Because a Branch process executes on the page submit. Using the Branch Process in Oracle Apex, you can open a dialog page or a normal page
This video will teach you about the Shared components which are common elements that can be display or be applied on any page within an application. You can use the tools and wizards on the Shared Components page either at the application-level or on specific pages.
This video will teach you about the a list of values (LOV) which is a static or dynamic set of values used to display a specific type of page item, such as popup lists of values, a select list, a check box, a radio group, or multiple select lists.
This tutorial will teach you about the use of Performance Management Architect to create Essbase (ASO) and Essbase (BSO) applications, providing reporting based on the dimensionality of Essbase as well as other applications, such as Planning or Profitability and Cost Management.
This video will teach you about the Global Page which is a special page. Unlike all other pages it has no processes, validations or branches. It functions as a master page in that APEX renders all the components you add to this page onto every page within your application
This tutorial will teach you about the export an application and which is related files, you must import them into the target Oracle Application Express instance and then install them.
Course/Topic 2 - Oracle APEX Administration - all lectures
Oracle APEX is a fully integrated, low-code development platform for building, deploying, and maintaining data-driven applications.
In this session, you will learn about the installation of windows 10 on Oracle VM.
In this session, you will learn about the Installation of Oracle Database 19c and Create Database.
In this session, you will learn about the Installation and Configuration of APEX 20.1.
In this session, you will learn about the Installation of Tomcat.
This video will give an introduction to ORDS. It then shows you how to install ORDS feasible for a production environment using WebLogic Server and an Oracle 12c.
This section describes tasks an Oracle Application Express administrator performs when administering an Oracle Application Express hosted instance.