What you'll learn
The course provides the entire toolbox you need to become an Oracle APEX developer
Impress interviewers by showing an understanding of the complete Oracle APEX platform
Unfold the power of low code platform
Learn how to build a new web application from scratch
Build, use and customize different types of charts in your application
Customize the look and feel of your application using theme roller
Implement security in your application, Authentication and Authorization
Migrate your application between environments, DEV, UAT and Production
Requirements
Basic Knowledge of SQL and PL/SQL
HTML, CSS and jаvascript is beneficial
Basic understanding of Web applications
Description
This is a very comprehensive course, specially designed for students, beginners and professionals. We will start from oracle Apex foundations and move towards advance topics gradually. we will cover following contents in this course.Oracle APEX Overview and ArchitectureDescribe Oracle Application ExpressExplain the key features of Oracle Application ExpressWhat is Oracle APEXDescribe Oracle Application Express architectureWorkspace and Applications in Oracle APEXDevelopment and development options in Oracle APEXCreate Workspace (Local, Cloud and Autonomous Database)Internal Workspace in Oracle APEXMultiple Schema AssignmentList and describe the components of Oracle Application ExpressMajor components of Oracle APEXLog into Oracle Application ExpressBrowser as IDE for Oracle APEX developmentInstall and run a packaged applicationsSQL Workshop OverviewDescribe SQL Workshop and list its componentsWhat is SQL Workshop?Object BrowserSQL CommandsSQL ScriptsExecute SQL CommandsCreating, Executing, Saving, Importing and Export SQL Scripts between WorkspacesOracle APEX UtilitiesLoad CSV,XLSX,XML and JSON data into Database TableUnload Data into Text or XMLQuery Builder Utility - Declarative wayMethods on Tables Utility - Create Package and proceduresQuick SQL Utility to create SQL.RESTful ServicesBrowse through database objects using the Object BrowserCreate and modify database objectsCreate a lookup tableRun SQL commands and SQL scripts Generate DDL statementsCreating Database ApplicationsExplain App Builder conceptsDescribe the types of applications you can build using Application ExpressCreate database application in Oracle APEXEdit database application propertiesCreate applications from JSON,XLSX,XML and text files List the components of a database applicationDetermine your application user interfaceCreate a database application from scratchCreate a database application from a spreadsheetCreate a mobile web applicationOracle APEX Page Designer OverviewExplain application page componentsCreate an application page and view its definitionManage pages in page designerDescribe page designer UI elementsAdd page componentsReports Development Oracle APEXList the type of reports that you can create in ApexDescribe the different ways of creating reports in Application ExpressCreate an interactive reportCreate an interactive gridCreate a classic reportCreate a report with formManaging and Customizing Interactive Reports Describe interactive report componentsSearching for information in an interactive reportSearching for information within a specific columnShow or Hide columns in interactive reportAdding a filter in an interactive report Describe types of filtersAdding column filter and row filterSelecting column sort order in interactive reportCreating aggregation in interactive reportAdding a computed columnPerforming a Flashback query in interactive report Creating a control breakAdding highlighting a row in interactive reportCreating a group by in interactive report Specifying a group by Sort orderSaving an Interactive reportResetting a reportDownloading a reportsUsing Column Heading MenuCustomizing an interactive report as a developersEditing Interactive Report Region Attributes Modifying an interactive Report Source QueryEditing interactive report attributesCustomizing the search barCustomizing the Actions MenuSpecifying the download formatsManaging Link ColumnsUse and customize an interactive report as an end userManage interactive report attributesConfigure the display of interactive report controls as a developerPerform a Flashback queryColumn Headers & Linking ColumnsSingle Row View of Interactive ReportsManaging and Customizing Interactive Grids Customizing an Interactive Grid as a DeveloperMaking an interactive Grid EditableAdding column group headersManage interactive grid attributesControl Interactive Grid Pagination Create error messages Configure the Search bar, Action menu, and download optionsControl if and how users save the reportConfigure supported views.Customize the Interactive Grid ToolbarEnable Users to Save Public Interactive GridModifying SQL Source of an Interactive GridCustomize interactive grid as an end userRearranging and Resizing Grid ColumnsChanging column display width in interactive gridAdjusting column display orderToggling columns buttonCreating filter, highlight row or ColumnDownloading or Emailing an Interactive gridRefresh an interactive GridInteractive grid Flashback, Reversing an interactive Grid to a Previous StateClassic Reports OverviewCustomization of Classic ReportsUsing Different Templates for Classic ReportsUsing Classic Reports as CardsUsing Classic Reports as Media ListUsing Classic Reports as TimelineUsing Classic Reports as Value Attribute PairsClassic Report with Download and Printing OptionsFaceted Search in Oracle ApexDesign Cards in oracle ApexURL Types in Oracle APEXRedirect to other pages in APEXAPEX_UTIL.PREPARE_URL UtilityCall Saved Reports & Apply Filters RuntimeCreating and Using Forms in Oracle APEXDescribe an application form in Application ExpressUnderstanding form typesUnderstanding Item TypesList the different types of application forms that you can createList the different wizards you use to create formsCreate a form on a table and link a report to a formCreate an editable interactive gridCreating a master detail formDifferent types of master detail forms and reports in APEXEditing a form using Quick Edit optionModifying Display Type of a Page ItemAltering Display order of page itemsCreating Application Page ControlsIdentifying different types of ItemsDifferent types of page itemsCreate and use page level items and edit Item attributesCreate and use application level itemsReferencing items values in SQL, PL/SQL and static textCreating a Quick Pick SelectionAdding Help Text along with Page Items.What is a List of Values (LOV)? And Types of LOVsUsage of Select List, Popup LOV, Radio Group, Checkbox and Shuttle component in APEXPopup LOV with Additional OutputsCreating a Static and Dynamic LOVsCreating shared LOVs to use on Multiple pages within applicationAssociating a Named LOV (Shared Component) with an ItemCreating a Cascading LOVCreate and use buttonsAuto Complete Text Field and Rich Text EditorDate Picker, Checkboxes and Radio ButtonsComputations, Validations, Processes and BranchingExplain page rendering and page processingShow page (page rendering) and Accept Page (Page Processing) processesWhat is a computation?Creating a page-rendering computation.Creating a page-processing Computation.What is a process?Create form wizard automatic data manipulation ProcessesAutomatic Row Fetch ProcessAutomatic Row Processing processCreate a page level processCreating on submit processCreate on Load ProcessApplication Level ProcessPage Rendering ProcessUnderstanding ValidationsCreating a Validation for a Page ItemCreating a SQL Validation TypeCreating a PL/SQL Validation TypeCreating a Regular Expression Validation TypeCreating a Row Validation in an Interactive GridUnderstanding BranchingCreate a branch within an ApplicationImplementing Navigation in ApplicationDescribe the use of shared components in an applicationUnderstanding Navigational Shared ComponentsCreate, edit, and use the following shared components that aid navigation in an application: Lists Navigation MenusBreadcrumbsNavigation bar entriesWhat are Lists?APEX Support for ListsWhat are Static and Dynamic Lists?Creating Static List.Adding Entries to a List.Creating a Dynamic ListAdding a list to a page. What is a Navigation Menu?Creating a Navigation Menu Entry.What is Breadcrumb?Creating a Breadcrumb.Adding Breadcrumb Entries.Adding a Breadcrumb Region in a Page.What is a Navigation Bar Entry?Accessing a Navigation bar List.Creating a Navigation bar List.Using Themes and Theme Styles in Oracle APEXDescribe themes and templatesTypes of Themes supported in APEX.Standard themes and custom themesAccessing Themes Page in Shared ComponentsEditing APEX Universal ThemeCreating a new theme from the Repository.Creating a Copy of an Existing Theme.Switching an Active ThemeUnderstanding Universal themeUsing theme StylesCreating a Theme StyleEnabling Users to select a theme style as per their choice.Using Theme Roller, Declarative way to style your applicationsUnderstanding Templates and Template OptionsCreating Template OptionsUsing Live Template OptionsUsing Custom Cascading Style Sheets.Uploading CSS, jаvascript, icons and images to static filesImplementing Security in Oracle ApexHow to secure an APEX application?Establish User Identity through Authentication.How to implement authentication in APEX?Built-in Authentication in APEXCustom Authentication in APEX.Creating Authentication scheme based on Pre-configured SchemeOpen Door CredentialsApplication Express AccountsDatabase AccountsLDAP DirectoryNo Authentication (Using DAD)Oracle Application Server Single Sign-OnCustomHTTP Header VariableProviding Security through AuthorizationCreate and use an authentication scheme for your applicationCreate and attach an authorization scheme to your entire application, page, regionor componentsHow to implement Authorization.Creating an Authorization scheme from Scratch.Creating Access Control Administration Page.Creating an Authorization Scheme to an Application.Attaching an Authorization Scheme to a Page.Attaching an Authorization Scheme to a Control or components.Enable and configure Session State Protection.Creating and Using Dynamic Actions and plug-ins in Oracle APEXDescribe Dynamic ActionsCreate and use Dynamic ActionsUnderstanding Dynamic action EventsCategories of EventsBrowser EventsFramework EventsComponent EventsCustom EventsEnabling and Disabling ItemsSetting Value of Page Items.Refresh a regionDescribe, import and use Plug-insImplement Plug-ins in your applicationViewing Plug-in RepositoryImporting and installing a Plug-inViewing a plug-in DefinitionCalendar in APEXCreating CalendarsEditing Calendar Attributes in Property editorTrees in APEXCreating and modifying Tress in APEXEnabling dragging and dropping of DataMigrating Application Development Between EnvironmentsExport entire application and its supporting objectsImporting application into target EnvironmentMigrating database objects – tables, triggers etc.Migrating data from one application to otherRecreating database objects in target Environment.Identifying the supporting objects for your applicationUpcoming Content
Who this course is for
Students, beginners and professional developers who are curious to learn Oracle APEX.
Homepage