Starting by creating a workspace, you will construct a basic application, learn techniques to go beyond the basics, and conclude with the knowledge on how to apply this to your own development environment.
Oracle APEX Techniques is a course that doesn't just teach you how to build a simple application, it will provide you with the skills necessary to expand your applications beyond the basics.
A workspace is required to commence development in APEX; learn how to create one. Create a workspace in your APEX environment.
Creating your first application can seem scary. See how easy it is with the development wizards. Create your first application using a wizard.
Some development tools require a lot of work to create something small. APEX is a RAD tool that allows you to quickly create pages. Create a feature-rich interactive report with an accompanying form.
We need to let the user find the data quickly. Let's add a search field to the report page. Create an item as the search criteria for your report.
To first timers, the APEX development environment can be daunting. Discover common tasks that will help you find your way. Learn your way around the APEX environment.
Protect your theme from APEX patches by making a copy of an existing theme in your workspace. Learn how to define your own workspace theme.
One size doesn't fit all. Customise templates to suit your needs. Create your own customised region template.
Websites without pictures are bland. Learn ways to include image content. Enhance your page layout by including images.
The libraries that are provided don't have all the styles. Find out how to add your own CSS. Enhance the look of your page by including your own CSS.
There is more than one position on the screen to deliver content. Learn how to use these locations wisely. Become familiar with page templates to control region positions on your page.
Don't build boring applications that look the same. Step outside the square and add visual effects to your application using jQuery. Enhance your application's look by using jQuery to define clever UI components.
Loading CSV files into a table is a common request. APEX provides an easy, wizard-driven solution. Use APEX's own extensions to upload delimited content.
Purely textual content can be boring. Liven up your application by embedding multimedia. Find out how to embed multimedia content within your pages.
Select lists with a larger number of rows can look untidy. Group similar rows using this free item plug-in. Use a plug-in from the community to enhance select lists in your application.
To provide a more interactive experience, sometimes you need to update the data without submitting a page. Use a dynamic action that saves the input on the click of a button. Update the database without submitting the page.
Developers often want to emulate the Forms functionality. Learn how to retrieve information based on user input without submitting the page. Define a dynamic action that runs an Ajax request to populate other fields.
Some search screens could be made very user friendly by changing results displayed after each key press. Use a dynamic action to trigger this refresh event. Configure a report to show records based on the criteria as it's entered.
It may be unfeasible to display many reports on one page with download links. Find out how to create a hidden report with a download link. Learn how to piece together an APEX URL that launches the CSV download on the click of a button.
Classic reports are the workhorse of the APEX environment, but are limited. Interactive reports offer many more options out of the box. Discover the feature-rich components that interactive reports (IR) provide.
A flat view of records sometimes isn't enough. Interactive reports allow the user to customize how the output is shown at runtime. See how to customize the view of an interactive report.
Traditional row/column view of classic reports can be boring. See how you can dress an IR to show information more creatively at design time. Configure your IR so it doesn't even look like a standard report.
For APEX to interface with BI Publisher, there needs to be development components. Oracle provides this and more with BI Publisher Desktop & APEX queries and layouts. Set up report query and report layout required for BI Publisher.
Data submitted via tabular forms generate PL/SQL arrays. Learn how to process these with PL/SQL. Discover how to process array data from a tabular form.
In tabular forms, checkboxes behave differently to other item types. Learn how to preprocess this array in PL/SQL. Learn how to use checkboxes effectively in tabular forms.
Encourage your users to read context-sensitive help by enhancing the help content. Enhance your application by customizing the Help page.
Metrics are important to help measure the success of the application. Learn how to count how often links are clicked. Measure the level of interest within your application by counting clicks.
Workspace management using the browser can be laborious. Create scripts using APIs to help automate the process. Manage your workspace and applications with scripts using supplied APIs.
If you have multiple applications that need to look the same, repeating all the work can be an issue. Use subscriptions to push changes to multiple applications. Save rework amongst applications by using APEX subscriptions.
Got a bug in your application? Learn how to use debugging options effectively. See how to use the in-line debugging options in APEX.
Using the browser to manage APEX isn't always an option. See how SQL Developer makes command-line requests with some basic mouse clicks. Use SQL Developer to remotely manage your applications.
Learn the correct way to define columns for your reports and help prevent users from using inserted data to run malicious code. Learn how to write SQL that is not susceptible to SQL injection attacks by defining a report with a searchable field.
What if you want to configure the log in process to use your existing tables? Learn how to define custom authentication to do this. Define a custom authentication theme and use it to authenticate log ins to your application.
Certain pages in an application may only be accessible to privileged users. Discover how to effectively secure pages using authorization schemes. Create an authorization scheme and secure access to a page based on that theme.
It is easy for the savvy user to modify the URL to access information they shouldn't see. Secure from URL tampering by using session state protection. Stop users from maliciously or accidentally modifying secured items in your application.
Users can enter special data in your normal forms to run browser scripts. See how to display this data so it's shown as it was entered, not run as a script. Learn the correct way to define columns for your reports to prevent malicious code (entered as data) from being executed.
Poorly written queries are susceptible to SQL injection, potentially exposing secure data. See the correct way to write your queries using bind variables. Learn how to write queries that may not be modified by the end user.
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.