UTOUG Training Days

Just what is this APEX thing? This session will provide an overview of what APEX is and what it can do. It will focus on the technical architecture, schemas and other database components that APEX makes use of, as well as a logical overview. DBAs will also see just how easy it is to create their own applications with APEX.

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle’s Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty. In this presentation, learn how Oracle’s sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

Learn how you can setup Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c. In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

The session explores the pluses and minuses of the new self-driving Oracle Autonomous Database Cloud. Learn what you need to know to migrate, manage, and assess this new database and see where it fits and where it doesn’t fit. The session also explores the things you must consider and do before you move this database and gives a peek into the future and how to merge into the fast lane.

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.

Security is more important than ever before – particularly for the application developer. APEX is no exception to this rule, as there are plenty of things that can be either misconfigured or set incorrectly, resulting in a less secure application.

This session will go through a checklist of what you as an APEX developer need to complete before promoting any APEX application to production.

With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported.

As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

It’s not widely known, but Victor Hugo was a big fan of SQL, as evidenced in an early draft of “A Tale of Two Cities” where he used partitioning:
“… PARTITION BY LIST (PERIOD)
(PARTITION times VALUES (‘BEST’, ‘WORST’),
PARTITION ages VALUES (‘WISDOM’, ‘FOOLISHNESS’),
PARTITION epochs VALUES (‘BELIEF’, ‘INCREDULITY’),
PARTITION seasons VALUES (‘LIGHT’, DARKNESS),
PARTITION time_of_year (‘HOPE’), (‘DESPAIR’));”

Fortunately for readers, he opted for a more accessible approach in the final version – but that doesn’t mean we can’t write data model masterpieces using partitioning! Enjoy a whimsical, literary approach to understanding partitioning, whether splitting characters and events among times of War and Peace, cataloging Fantastic Beasts (and Where to Find Them), or archiving off Histories. Explore different partitioning methods, how indexing fits into the equation, and how partitioning choices impact performance, accessibility, and long-term storage of data.

Artificial Intelligence (AI) and Machine Learning (ML) are a lot like preserving the Earth’s environment: Almost everyone is talking about what should be done to save it, but very few people have committed to actually doing something about it.

This session demonstrates a few real-life opportunities to discover unseen patterns and relationships within sample financial and election data by leveraging the AI and ML capabilities already built into Oracle Autonomous Database.

Autonomous Database Services have expanded well beyond their original scope of heavy analytical workloads (ADW) and hybrid transaction processing / reporting workloads (ATP) to include dedicated Cloud-based instances to eliminate contention between “noisy neighbors” in the same region and domain.

This session demonstrates how Oracle DBAs at any skill level can immediately leverage Autonomous resources as force multipliers to free them from most mundane administration tasks so they can concentrate on mastering the new skills required to become an Enterprise Data Architect – the emerging post-DBA role – and shift their focus towards building better enterprise systems in concert with their organization’s application developers, business analysts, and business units.

Join us in this educational session as we help you navigate and plan moving your databases to Oracle Cloud, along with useful tips before considering database as a service, infrastructure as a service or platform as a service options for your critical applications.

In this session, we will discuss Oracle’s Cloud strategy, migration paths to your journey to the cloud, and discuss hidden gems in Oracle Cloud to simplify adoption. Lastly, we will breakdown many of the Oracle OpenWorld 2019 new announcements that will impact your cloud journey such as:
• The autonomous database
• DBA 3.0
• BYOL licenses
• Universal Credits
• MSP Program