D79653OROracleOR-D796531.0<ul> <li>Create Pages and Regions in an Application</li><li>Log in to an Oracle Application Express Workspace</li><li>Create Page and Application Items and Buttons</li><li>Create Page Processes and Validations</li><li>Implement Security</li><li>Manage Application Navigation</li><li>Extend an Application</li><li>Create Themes and Templates</li><li>Create Shared Components such as Tabs, Lists, and Breadcrumbs</li><li>Add Dynamic Actions</li><li>Import and Use Plug-Ins</li><li>Create and Use Calendars and Trees</li><li>Utilize Application Express Printing methods</li><li>Manage Application feedback</li><li>Create Reports and Forms in an application</li><li>Create and Run Database Applications using desktop and mobile interfaces</li></ul><h5>Required Prerequisites:</h5><ul> <li>Basic knowledge of SQL, PL/SQL, and HTML</li></ul><h5>Suggested Prerequisites:</h5><ul> <li>Oracle Database: SQL Workshop I</li><li>Oracle Database: SQL and PL/SQL Fundamentals</li></ul><ul> <li>Project Manager</li><li>Database Administrators</li><li>Web Administrator</li><li>System Analysts</li><li>Application Developers</li><li>Business Intelligence Developer</li><li>Forms Developer</li></ul><h5>Course Overview</h5><ul> <li>Course Goals</li><li>Course Outline</li><li>Order Management Database Application (OMDA)</li><li>Introducing Course Persona: Jack</li><li>Course Environment: Products Installed</li><li>Course Environment: Workspace Details</li><li>Accessing the Labs Directory</li></ul><h5>Introducing Oracle Application Express</h5><ul> <li>Application Express Overview</li><li>Application Express Terms and Concepts</li><li>Using Application Express</li></ul><h5>Creating a Desktop and Mobile Database Application</h5><ul> <li>Application Builder Overview</li><li>Introducing Database Applications</li><li>Creating Database Applications</li><li>Creating Mobile Application</li></ul><h5>Working with Reports for Desktop Application</h5><ul> <li>Introducing Reports</li><li>Using Classic Reports</li><li>Using Interactive Reports</li><li>Creating and Customizing an Interactive Report</li></ul><h5>Working with Reports for Mobile Application</h5><ul> <li>Creating Reports for a Mobile Application</li><li>Creating Column Toggle Report</li><li>Creating a Reflow Report</li></ul><h5>Creating Forms</h5><ul> <li>Using Forms</li><li>Creating Forms</li><li>Modifying Forms</li><li>Creating a Form in a Mobile Application</li></ul><h5>Working with Pages and Regions</h5><ul> <li>Introducing Page Definition</li><li>Working with Page Regions</li><li>Working with Pages</li></ul><h5>Adding Items and Buttons</h5><ul> <li>Introducing Items</li><li>Using Items</li><li>Creating List of Value (LOV) Type of Items</li><li>Using Buttons</li></ul><h5>Understanding Session State</h5><ul> <li>Understanding Session State in Oracle Application Express</li><li>Using Session State in Oracle Application Express</li></ul><h5>Including Page Processing</h5><ul> <li>Introducing Page Processing</li><li>Including Computations</li><li>Including Processes</li><li>Including Validations</li><li>Including Branches</li></ul><h5>Validating and Debugging Your Application</h5><ul> <li>Using the Advisor</li><li>Managing Your Attribute Dictionary</li><li>Debugging Your Application</li></ul><h5>Adding Shared Components That Aid Navigation</h5><ul> <li>Introducing Shared Components</li><li>Creating Tabs</li><li>Creating Lists</li><li>Creating Breadcrumbs</li><li>Creating a Navigational Bar</li></ul><h5>Working with Themes, Templates and Files</h5><ul> <li>Using Themes</li><li>Using Templates</li><li>Using Files</li></ul><h5>Implementing Security</h5><ul> <li>Securing an Application</li><li>Using Authentication Schemes</li><li>Using Authorization Schemes</li><li>Using Session State Protection</li></ul><h5>Managing Application Navigation</h5><ul> <li>Building a Hierarchical List with Images</li><li>Building a Site Map</li><li>Enforcing Authorization on Your Site Map</li><li>Linking Interactive Reports using a Declarative Filter</li></ul><h5>Extending Your Application</h5><ul> <li>Creating Data Load Wizard Pages</li><li>Creating an Upload and Download Page</li><li>Adding BLOB Data to an Existing Application</li><li>Sending Email from an Application</li></ul><h5>Creating and Editing Charts</h5><ul> <li>Creating and Using Charts</li><li>Enhanced Charting Examples</li></ul><h5>Adding Calendars and Trees</h5><ul> <li>Using Calendars</li><li>Using Trees</li></ul><h5>Using Dynamic Actions and Plug-Ins</h5><ul> <li>Using Dynamic Actions</li><li>Using Plug-Ins</li></ul><h5>Utilizing Application Express Printing</h5><ul> <li>Printing a Standard Report with Derived Output</li><li>Creating a PDF Report with Multiple Queries</li></ul><h5>Managing Application Feedback</h5><ul> <li>What is Team Development?</li><li>Managing Feedback</li></ul>- Create Pages and Regions in an Application - Log in to an Oracle Application Express Workspace - Create Page and Application Items and Buttons - Create Page Processes and Validations - Implement Security - Manage Application Navigation - Extend an Application - Create Themes and Templates - Create Shared Components such as Tabs, Lists, and Breadcrumbs - Add Dynamic Actions - Import and Use Plug-Ins - Create and Use Calendars and Trees - Utilize Application Express Printing methods - Manage Application feedback - Create Reports and Forms in an application - Create and Run Database Applications using desktop and mobile interfacesRequired Prerequisites: - Basic knowledge of SQL, PL/SQL, and HTML Suggested Prerequisites: - Oracle Database: SQL Workshop I - Oracle Database: SQL and PL/SQL Fundamentals- Project Manager - Database Administrators - Web Administrator - System Analysts - Application Developers - Business Intelligence Developer - Forms DeveloperCourse Overview - Course Goals - Course Outline - Order Management Database Application (OMDA) - Introducing Course Persona: Jack - Course Environment: Products Installed - Course Environment: Workspace Details - Accessing the Labs Directory Introducing Oracle Application Express - Application Express Overview - Application Express Terms and Concepts - Using Application Express Creating a Desktop and Mobile Database Application - Application Builder Overview - Introducing Database Applications - Creating Database Applications - Creating Mobile Application Working with Reports for Desktop Application - Introducing Reports - Using Classic Reports - Using Interactive Reports - Creating and Customizing an Interactive Report Working with Reports for Mobile Application - Creating Reports for a Mobile Application - Creating Column Toggle Report - Creating a Reflow Report Creating Forms - Using Forms - Creating Forms - Modifying Forms - Creating a Form in a Mobile Application Working with Pages and Regions - Introducing Page Definition - Working with Page Regions - Working with Pages Adding Items and Buttons - Introducing Items - Using Items - Creating List of Value (LOV) Type of Items - Using Buttons Understanding Session State - Understanding Session State in Oracle Application Express - Using Session State in Oracle Application Express Including Page Processing - Introducing Page Processing - Including Computations - Including Processes - Including Validations - Including Branches Validating and Debugging Your Application - Using the Advisor - Managing Your Attribute Dictionary - Debugging Your Application Adding Shared Components That Aid Navigation - Introducing Shared Components - Creating Tabs - Creating Lists - Creating Breadcrumbs - Creating a Navigational Bar Working with Themes, Templates and Files - Using Themes - Using Templates - Using Files Implementing Security - Securing an Application - Using Authentication Schemes - Using Authorization Schemes - Using Session State Protection Managing Application Navigation - Building a Hierarchical List with Images - Building a Site Map - Enforcing Authorization on Your Site Map - Linking Interactive Reports using a Declarative Filter Extending Your Application - Creating Data Load Wizard Pages - Creating an Upload and Download Page - Adding BLOB Data to an Existing Application - Sending Email from an Application Creating and Editing Charts - Creating and Using Charts - Enhanced Charting Examples Adding Calendars and Trees - Using Calendars - Using Trees Using Dynamic Actions and Plug-Ins - Using Dynamic Actions - Using Plug-Ins Utilizing Application Express Printing - Printing a Standard Report with Derived Output - Creating a PDF Report with Multiple Queries Managing Application Feedback - What is Team Development? - Managing Feedback5 Tage3555.00