| Oracle APEX Training Contents |
 |
 |
 |
| Oracle APEX Training | |
|
We are glad to announce our newly launched online Oracle Application Express Training (APEX). This course introduces the you to Oracle Application Express.It is designed to give you practical experience in using this tool for building user applications for the Web • Developing a Web Application • Creating Reports • Creating Forms • Managing Pages and Regions • Using and Managing Shared Components in an Application • Adding Page Processing Components • Managing Database Objects • Building Queries of Database Objects • Deploying an Application as a Packaged Application • Managing Users and Groups • Authorising and Authenticating Users • Administering APEX Workspaces • Loading and Unloading Data or Application Components • Deploying an Application Batch Commencing on: 24 March 2012 Training Duration: 5 Days Training Schedule : 24, 25, 31 March 01 & 07 April 2012
Course Contents: • Introduction to Oracle Application Express – APEX Concepts – APEX Main Components – Workspace and Create a Workspace – Log into APEX – Run an Application • Maintaining Database Objects Using SQL Workshop – Browse, create and modify database objects using Object browser – Execute SQL scripts using SQL Command and SQL Scripts – Build and save SQL queries using Query Builder – Import and export data using Utilities • Building Database Applications – Discuss the difference between a Database Application and a Websheet Application – Identify the components of a database application – Create a database application from a spreadsheet – Create a database application from scratch • Creating Reports – Identify the types of reports you can create – Create, manipulate and customize interactive reports – Create and modify classic and wizard reports • Hands-on Day 2: • Creating Forms – Identify the types of forms you can create – Create and modify various types of forms • Working with Pages and Regions – View and edit page definitions and attributes – Create and modify a region and subregion – Create a Page Zero – Add page groups and comments • Adding Items and Buttons – Identify different types of items – Create items and edit item attributes – Create and use List of Values – Create buttons and edit button attributes • Including Page Processing – Explain the difference between page rendering and page processing – Create computations in application pages – Create page processes – Create validations to verify user input – Create branches within a application • Understanding Session State and Debugging – Explain how APEX uses session state – View, reference and clear session state values – Review messages in debug mode • Hands-on Day 3: • Using Application and Page Utilities – Use the Advisor to verify your application – Manage defaults using the Attribute Dictionary • Adding Shared Components that Aid Navigation – Explain the use of shared components in an application – Create and edit tabs, navigation bar entries, lists and breadcrumbs • Displaying Dynamic Content – Create and use a dynamic action – Import and use a plugin – Create and modify a chart – Create a calendar – Create a tree • Working with Themes, Templates, and Files – Explain what themes and templates are – Create a new theme from the repository and switch to the theme to make current – Create and edit a template – Upload and use a Cascading Style Sheet and an image • Hands-on Day 4: • Administering Application Express Workspaces – Create a developer and a workspace administrator user – Request a schema or a storage – Monitor the developer activity log • Implementing Security – List the different ways to secure your application – Differentiate between authentication and authorization – Create an authentication scheme for your application – Create an authorization scheme using Access Control – Enable and configure Session State Protection • Deploying Your Application – Identify the supporting objects for your application – Export an application and its supporting objects – Import an application – Install the supporting objects • Managing and Maintaining the Application Development Process – Track Features, Milestones, Bugs and To Dos – Manage Feedback • Hands-on Day 5: (Mainly Demos and Advance Concepts session) • Building Tabular Forms – Manually Creating Tabular Forms – Validation in Tabular Forms – Working with Collections • Managing Application Development – Backing up Applications – Using the Build Option – Translating Applications (Globalization) – Leveraging the Apex Dictionary – Managing Apex from SQL Developer – Application Packaging – Monitoring Performance • Printing Reports – Manual Printing – Using BI Publisher
|