Overview

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. Course content isOracle APEX Overview and ArchitectureDescribe Oracle Application Express (APEX)Explain the key features of Oracle Application ExpressDescribe Oracle Application Express architectureOracle APEX Workspaces and Applications Create 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 WorkshopDescribe SQL Workshop and list its componentsWhat is SQL Workshop?SQL 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.Browse through database objects using the Object BrowserCreate and modify database objectsCreate a lookup tableGenerate 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 DesignerExplain application page componentsCreate an application page and view its definitionManage pages in page designerDescribe page designer UI elementsAdd page componentsDeveloping ReportsList 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 developerColumn 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 ApexInteractive Reports Advance TopicsURL Types in Oracle APEXRedirect to other pages in APEXAPEX_UTIL.PREPARE_URL UtilityCall Saved Reports & Apply Filters RuntimeCreating and Using Data FormsDescribe 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 ItemsIdentifying 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 ApplicationShared Components & Global NavigationsDescribe 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.Themes and Theme StylesDescribe 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, JavaScript, icons and images to static filesCreating MapsCreate map using latitude & longitudeCreate map using GeometryGet latitude & longitude DynamicallySecurity Implementation How to secure an APEX application?How to implement Authentication in APEX?Custom Authentication SchemeHow to Change Current Authentication Scheme?Create Global or Application Level Page ItemsShow Signed-in Username in Navigation BarDatabase Accounts Authentication SchemeNo Authentication SchemeOpen Door Credentials Authentication SchemeApplication Express Accounts Authentication SchemeSocial Sign-in OAUTH2 Google AuthenticatorProviding Security through AuthorizationCreate and attach an authorization scheme to your entire application, page, region & Other componentsCreating 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 & plug-insDescribe Dynamic ActionsCreate and use Dynamic ActionsUnderstanding Dynamic action EventsCategories of EventsBrowser EventsFramework EventsComponent EventsCustom EventsEnable & Disable, Hide and Show Page ItemsEnable & Disable using javascriptValidation Errors, Add & Remove CSSHighlight Page Items on FocusExecute Server Side Code By Dynamic ActionSetting Value of Page Items.Set Page Item Value Using PL/SQL FunctionFilter Data and Refresh RegionDescribe, import and use Plug-insImplement Plug-ins in your applicationViewing Plug-in RepositoryImporting and installing a Plug-inViewing a plug-in DefinitionCalendar ComponentCreating CalendarsEditing Calendar Attributes in Property editorTree ComponentCreating and modifying Tress in APEXEnabling dragging and dropping of DataMigrating Applications, DB Objects & Plugins Between Environments[DEV,QA,UAT,PROD]Export 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 applicationMigrate Plugins from Dev Environment to Prod EnvironmentOracle APEX 23.2 - New FeaturesCombo box Page ItemImage Upload Page ItemGenerate QR Code & Bar CodeApplication Working CopiesIntegrated DiffSimple MergeWorkflowCustom Map BackgroundsCreate and Consume WebservicesRestful Service to Get Employees DataReport with Pagination using WebserviceFilter Webservice Data, Passing URL ParametersWebservice to Update Employee DataWebservice to Delete Employee DataWebservice to get Documents & ImagesSecure Webservices OAuth 2Load Stress Regression Testing using JMeterWorkflows, Tasks & AutomationTask Definition & TypesUnderstand task types: Action & ApprovalKey attributes: Priority, Participants, Deadline, Potential Owner, Business Administrator, Parameters, ActionsTask Instance CreationCreate Action and Approval Task InstancesRetrieve primary key valuesDesign Task Details PageBuild page to initiate task instancesUnified Task ListsMy TasksAdmin TasksInitiated by MeTask Operations & Workflow IntegrationMap task operations to events and statesDesign Leave Management with Multi-Level ApprovalWorkflow FundamentalsIntroduction to WorkflowWorkflow Parameters, Variables, and Participants (Owner, Business Admin)Workflow Activities: Start, End, Send Email, Human Task, Switch, Wait, Push NotificationWorkflow Versions: Active vs Inactive

Skills

Reviews