Quest Forum Digital Event 2020

Most did not expect a new version after 11.2, but then the surprise - Oracle 18c XE was released - for FREE.  In this session, we will dive into what is Oracle Database Express Edition - the latest updates, including diving into the excellent features it brings to the table.  Areas that will be covered include installation, usage, new features, and how you can quickly get started with Oracle XE and Docker - a perfect match.

Quest Forum Digital Event 2020

JDE security has never been easier. Using Orchestrator automation functionality we can now expose automate JDE security assignment. Need a new user in JDE with specific security, we can show you how to do that. In this session we will show you and your power users how to set up new users, assign security, and even send out approval notifications.

Quest Forum Digital Event 2020

SQLcl offers many ways to simplify your DevOps life. Imagine writing automation scripts for your database in languages like JavaScript, Python, or Perl - to name just a few - without the hassle of driver libraries. Although SQLcl is almost 100% compatible with SQL*Plus, it adds a lot of new commands and features to the old lady: Native support for Liquibase and Hashicorps Vault, for example. The most potent new keyword is "script." Script embeds the execution of SQL-statements or SQL*Plus-commands  from your favorite scripting language. Extend SQLcl by writing functions, use your favorite language’s objects and control structures and parallelize multiple tasks. Within this entertaining session, the presenting expert waters your mouth and generates countless wants.

Quest Forum Digital Event 2020

Application Express (APEX) continues to grow in popularity for application development, both for new business use cases as well as migration from older development technologies (e.g. PowerBuilder). But many developers and DBAs alike aren’t necessarily aware that APEX is now available within Oracle Autonomous Transaction Processing, a powerful self-contained set of Cloud-based database services.

This session demonstrates a real-life business scenario – the creation of a financial services/retirement planning application – that combines best practices for APEX development efforts with ATP’s simplicity to provide a stable deployment for hybrid OLTP and reporting workloads.

Quest Forum Digital Event 2020

This presentation, will be a technical overview of JD Edwards EnterpriseOne Orchestrator. This session is primarily for technical resources, including CNC’s.

Some of the items covered:

• AIS and ORCHESTRATOR related setup

• Orchestrator security options and setup

• Orchestrator support and troubleshooting.

• Orchestrator scheduler setup and support

Quest Forum Digital Event 2020

In this session join Oracle Database Product Management to learn more about using JSON in the Oracle Database. Learn about some of the new innovative ways that the Oracle Database can be used to load, store, and manage JSON and take advantage of the enterprise class features that Oracle provides so well.

We will also take a look into the unique Oracle Database features to leverage memory-persistent technologies for fast ingestion and retrieval of attribute-value pair data.  Other topics that are covered include the SQL language enhancements for complete flexibility and ease of use when working with JSON.

The session will also be discussing some of the enhancements being released in Oracle Database 20c for addressing the use of JSON.

Quest Forum Digital Event 2020

Every database developer knows that PL/SQL functions can be used in SQL queries. However, not many are aware of the measurable cost of SQL-to-PL/SQL context switches. Even fewer can definitively answer how many times their functions will be called (depending upon the complexity of queries or portion of the query where the function is located). This presentation sheds some light on this gray area. The answer is actually very simple: the number of calls is driven by the cardinality of involved tables plus the final execution plan of your query (after all query-transformation steps). Unfortunately, GUESSING what exactly the Cost-Based Optimizer will do to your query is very difficult. This presentation will show you how to KNOW rather than guess and how to use this knowledge to optimize the performance of your database.

Quest Forum Digital Event 2020

Cloud is transforming the enterprise and the career path of the DBA. See how. As cloud gains momentum and migrations of applications and databases become more common, the question is often asked: "Does Cloud mean the end of the DBA?" Cloud is likely not the end of the DBA, but instead an agent in unprecedented change. This webcast will cover how Cloud is bringing about that evolution and what today's DBAs must know to be successful in a Cloud-enabled future.

The future is here, let's take advantage of it today!

Quest Forum Digital Event 2020

For some, the word DevOps means a Lot, there have been many books written about it.  Yet, so many do not know what it is, what it stands for.  Let's take a look at the following key areas: What is DevOps?  Why is it so Important? How to get started!

Quest Forum Digital Event 2020

Containers have been embraced by the developer community, but acceptance and adoption by DBAs is more... tepid. That's understandable--why would anyone want a database that's stateless and immutable?! I started using Docker under duress and had no idea what I was doing. Since then, I've learned that Docker elegantly addresses many situations faced by DBAs, including:
- Rapidly provisioning test and development environments
- Interacting with Oracle Cloud Infrastructure databases (including ATP and ADW)
- Preparing environments for performance testing
- Building Gold images
- Exploring new technologies and features
- Discovering and confirming bugs
- Preparing for certification exams

This session is a crash course in Docker covering the terminology, concepts, skills, and practical examples needed to begin using containers to support databases.