oracle 200x118 wht
8396  Reviews star_rate star_rate star_rate star_rate star_half

Oracle Application Express: Workshop II

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You'll examine topics that including learning...

Read More
By Request
$3,600 USD
Duration 3 days
Course Code D106776GC10
Available Formats Classroom

Overview

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You'll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service. By taking this course, you'll develop the ability to ensure that the APEX application is accessible. You'll be able to determine which theme to use based on the type of application you want to build (desktop, mobile or responsive) as well as how to customize the templates.

  • Extend Your applications using collections, dynamic application and plug-ins.
  • Create and use RESTful Web Services.
  • Make your application accessible.
  • Customize themes and templates.
  • Establish a master application and corporate theme that many applications can use.
  • Migrate an existing application to a new theme.
  • Incorporate a jQueryUI ThemeRoller theme into your mobile application.
  • Secure, deploy and maintain your applications.
  • Optimize your application performance.

Skills Gained

  • Create and use RESTful Web Services
  • Customize themes and templates
  • Create a master application and custom theme
  • Migrate an existing application to a responsive theme
  • Incorporate interactivity in your application
  • Build tabs based on a static list
  • Secure your application
  • Deploy and maintain your applications
  • Optimize your application performance
  • Extend Your applications using collections, dynamic applications, and plug-ins

Prerequisites

Required:

  • Basic knowledge of SQL, PL/SQL, and HTML
  • Oracle Application Express Workshop I Ed 2

Course Details

Course Overview

  • Course Objectives
  • Lesson Schedule
  • Course Environment: Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory
  • Introducing Course Persona

Introducing Course Persona

  • Quick Review of What You Already Know
  • Securing Database Applications
  • What is a Packaged Application?
  • Components of Team Development
  • Workspace Administration
  • Other Components
  • Packaged Application Used in this course
  • Additional Resources

Using Collections

  • What is a Collection?
  • Create a collection on an interactive report

Extending Your Application: Dynamic Actions

  • Adding Dynamic Actions

Extending Your Application: Plug-ins

  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In

Incorporating Interactivity in Your Application

  • Tooltip
  • Scrolling Region
  • Add buttons with conditions in the report page to display report based on the conditions
  • Add a procedure in AJAX to refresh a page region periodically
  • Configuring Oracle Application Express to send email

Generating and Using Table APIs

  • What is a Table API?
  • Generate a Table API
  • Modify the Table API
  • Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API

Creating and Using RESTful Web Services

  • What is a RESTful Web Service?
  • Components of a RESTful Web Service
  • An Example: RESTful Web Service
  • Creating a new RESTful Web Service
  • Consuming a RESTful Web Service in an APEX Application

Using Themes and Templates

  • Application Types: Desktop, Mobile, Responsive - Explain what they are and what criteria determines which application to createTheme Overview: Which ones are for which type of Application
  • Review the layout of a Page template
  • Include using CSS to customize the template
  • Using Substitution Strings in Templates
  • Utilize new page attributes - files/inline styles
  • Create and modify a theme
  • Establishing a Master Application and a Corporate Theme

Developing a New Theme for Your Application Using ThemeRoller

  • What is ThemeRoller?
  • Create a theme using the ThemeRoller

Securing Your Application

  • What Is a Directory?
  • Oracle Internet Directory
  • Technical Architecture: Overview
  • Authenticating Users by Using LDAP
  • SQL Injection
  • Cross-Site Scripting
  • Browser Security
  • Application Level Security

Deploying and Maintaining Your Application

  • Application Components
  • Things to consider
  • Backups

Optimizing Your APEX Application

  • Application Performance Considerations
  • Managing Services
  • Monitoring Activity
  • Database Configuration Considerations
  • Monitoring Application Performance

Globalization and Translation

  • Understanding Application Translation and Globalization Support
  • Specifying the Primary Language for an ApplicationLoading a New Language
  • Translating an Application
  • Translating the Data the Application Uses
  • Localization
  • Switching Languages
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

I thought the course was informative and the tools to go over the material were very nice.

Easy to use and exactly what I was looking for. Value for money was exceptional.

This was a good program to get prepared for the solutions architect associate exam.

ExitCertified was a great. They gave me all the materials and information I needed ahead of time to prepare for the course.

They were very good. They made sure everyone was able to get into the training and got all of the material needed for class.