| Building Single Page Applications in APEX | Matt Nolan | In this session we will walk through what single applications are, how they behave, and what the benefits are over traditional page submit web applications that are built using APEX. It includes a number of live demo's comparing the interaction difference between a standard APEX application and a single page application design. Plus a number of high level design concepts and demo on how to integrate a SPA framework using the APEX plugin interface. | |
| APEX and the REST of the World | Carsten Czarski | Since APEX 18, external REST Services became a first-class data source for APEX applications. Web Source Modules allow to create create reports, Charts, Calendars or other components directly on top of the REST service - all low-level work, like making the HTTP request or parsing JSON will be done by APEX. This session walks through the architecture and demonstrates how Web Source Modules work with a public REST API from the internet. | |
| Learning JavaScript Concepts from Real-World Solutions | Dan McGhan | Think you need to write hundreds of lines of JavaScript code to achieve something useful in an APEX application? Think again! It often takes just a few lines of JavaScript to get the job done. Of course, to write any lines of JavaScript, you’ll need to understand some basic concepts. In this session, attendees will see several real JavaScript-based solutions that only require a few lines of code to implement. In each case, the concepts behind the code and the approach to solving the problem will be explained. | |
| APEX Security Checklist | Scott Spendolini | This session maps OWASP's top ten security vulnerabilities to Oracle APEX and what you as a developer should be aware of. For each relevant vulnerability, both potential issues and solutions are discussed. | |
| Advanced CSS/JS Techniques to Tweak You Application UI | Maxime Tremblay | In this session we will have a look CSS and JS techniques as well as tips and tricks that can be used in your APEX applications to tweak the UI. You will see that with only a few lines of JavaScript and CSS we can do great things. | |
| Browser DevTools: The other tool for APEX Development | Jorge Rimblas | APEX development is not just about Oracle PL/SQL and SQL. In fact, it requires other disciplines to provide an enhanced user experience. With some knowledge of HTML, CSS, and JavaScript, your APEX applications can begin to shine. However, you need a helper to better work with these technologies. If you're running SQL, you may use SQL Developer, but what do you use for HTML, JavaScript, and CSS? Enter DevTools. In this session, we'll cover the built-in DevTools available in all modern browsers.
Learn the ins and outs of these tools and how they improve your everyday work with APEX. They are easy to use. No installation required and a just keystroke away. | |
| Top 10 tips to optimize APEX for mobile | Vincent Morneau | In this session, Vincent shares 10 of his favorites tips to improve the mobile experience of an APEX application:
1. Responsive breakpoints
2. Design for mobile
3. Make it installable
4. Push notifications
5. Off canvas scrolling
6. MPA SPA hybrid
7. Navigation history
8. Lazy loading
9. Think AJAX
10. Explore!
And two bonus tips!
Demo application used in the session is available to download here: https://apex.oracle.com/pls/apex/vmor... | |
| Social Login while Social Distancing | Martin D'Souza | Discover how to quickly and easily let users login to your APEX application using their preferred social login (ex Facebook). | |
| Great features of SQL | Connor McDonald | n a sense, Application Express is almost "too good" a platform, because it can handle so many of the database interaction tasks for developers. As a consequence, developers often avoid exploting the more advanced SQL features, because Application Express can handle that task for them. But SQL has grown enormously from its origins of just simple data access. By delving deeper into these modern SQL facilities, developers can get performance benefits and write a lot less code. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by modernizing your knowledge of the SQL language. | |
| The Transformation of Oracle APEX | Shakeeb Rahman | | |
| Database Design for APEX Devs in 45min | Heli Helskyaho | Database designing is a skill everybody should acquire. There is no serious application without a database and if that database is not designed well the application will not run well. In this session we will do a live demo on database designing. We will start with talk about requirement analysis, conceptual design, logical design and physical design. In the end we will generate the DDLs to create the database and the objects in it. And all this will be done using Oracle SQL Developer Data Modeler: a cost-free database designing tool from Oracle that will not only support designing Oracle databases but also other relational databases. | |
| Database Links vs. REST Enabled SQL in APEX | Andreea Munteanu | How to access data remotely? Check the key differences between Database Links vs. REST Enabled SQL and the way they work inside an APEX application. The presentation will provide some useful tips around their usage over the Cloud environment as well.
| |
| Using the PL/SQL Debugger | Philipp Salvisberg | Every developer knows the problem. An application doesn't do what it should and the existing logging output doesn't help. Usually, the presumed defective program area is iteratively extended by further logging calls to locate the error. If this is of no use, a colleague is called in. Maybe he has an idea. In such cases I recommend using the PL/SQL debugger. The debugger not only helps to find the error faster but is also an excellent tool to display the context of a concrete use case and to better understand the program.
In this presentation I explain among other things
- the prerequisites for using the PL/SQL Debugger,
- the difference between DBMS_DEBUG and DBMS_DEBUG_JDWP,
- how both debugger variants can be used in SQL Developer,
- and how debugging works directly from an application without adapting the source code. | |
| Wizard of ORDS | Roel Hartman | ORDS, the Oracle Rest Data Services, has evolved from just a supporting component of Oracle Application Express to the de facto standard tool for delivering RESTful API services for the Oracle database. In this session we will show how easy it is to get data in and out of your database in a secure way - so easy, it’s almost magic! | |
| Know your Browser Dev Tools! | Daniel Hochleitner | You’re a database person doing mostly PL/SQL stuff? You’ve been doing Oracle Application Express (Oracle APEX) for several years but always struggle with web or browser things? Or you’re a front-end person who always wanted to understand the connection between APEX front end and back end? This session is for you! Some examples:
• What browser dev tools are
• Client-side APEX debugging (JavaScript, dynamic actions)
• Inspecting AJAX calls delivering data from the back end
• Performance analysis of client-side code
• Checking accessibility of pages, regions, components
• Testing JavaScript before including it in APEX development
• Changing existing or adding new CSS for styling your app | |
| The Ultimate Guide to APEX Plug-ins | Stefan Dobre | | |
| Keynote / APEX 20.1 | Joel Kallman / Marc Sewtz | Senior Director Joel Kallman provides an update on the state of APEX, both inside Oracle and around the global APEX community. Senior Software Development Manager Marc Sewtz showcases some of the highlights of APEX 20.1. Oracle APEX has a bright future indeed! | |
| A dozen things to do with Oracle APEX | Scott Wesley | As APEX matures, so does my usage of the product, especially with features that have been around for a long time.
This session explores the usage of 3 of my favourite features you've no doubt heard about before, but in a few ways you may not have thought to use them. | |
| Bring the Light into Your Always FREE Autonomous Cloud | Dimitri Gielis | At Oracle Open World 2019, the always FREE Autonomous Cloud was announced. Shortly after that, I did a popular series of blog posts (https://dgielis.blogspot.com/2019/09/...). This presentation will build further upon on this series. While the blog posts explain how to set things up, in this presentation I want to give tips and tricks for using the cloud, such as how to move your apps to and from the cloud, how to use advanced compression and how to measure performance and up-time. After this presentation, the attendees have all the info they need to be successful in running their applications in the Always FREE Autonomous Cloud. | |
| Design Principles for Creating “Grrreat” APEX Applications | Simon Hunt | A discussion of some of the design principles and techniques that can be used to take your APEX applications to the next level. | |
| APEX Debugging 101 | Peter Raganitsch | An overview of debugging and logging possibilities in Oracle APEX applications. Bugs are inevitable, here you can see which tools are at your disposal to understand what's happening and why it is happening. | |
| APEX architectures | Niels de Bruijn | Different requirements lead to different APEX architectures. Let us go through some of these architectures including some cloud options. Next to that, Single Sign-On should be part of each APEX architecture and this webinar will go through three well-documented implementation options: OAuth2, Kerberos and SAML2. | |
| You’ve Got Mail: Tips, Tricks, and Tools for Mail in Application Express | Timothy St. Hilaire | Review of APEX mail api, templates, and email design considerations showing how you can leverage them in your own projects. Additional discussion of hosting considerations, spam, and software development life cycle. | |
| APEX developer's tools of the trade. Applications and tools to aid in application development. | Tyson Jouglet | This session explores some helpful features and tools for APEX developers. Some topics are APEX specific while others are general tips to help all development tasks.
Topics Include:
What should developers look for in a browser?
Picking the right editor for you.
Managing REST services with Insomnia.
Finding a developer friendly font.
APEX builder features that you might have overlooked.
| |