Loading…
View analytic

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Wednesday, March 21
 

7:30am

Breakfast
Wednesday March 21, 2018 7:30am - 8:30am
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

Oracle Database 18c and the Autonomous Database
​​​​We are entering a new era in database with the introduction of the first-ever Autonomous Database Cloud. Oracle Database is also switching to a new annual release model to support this new era, with Oracle Database 18c being the first release in this new model. But what does this mean to you and how will it change how you interact with the Oracle Database? This session provides a clear understanding of how our unique Autonomous Database Cloud works and illustrates how it will impact both DBAs and developers. It also provides a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team.

Speakers
avatar for Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation
Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog at https://sqlmaria.com and a contributing author to the Oracle Optimizer... Read More →



Wednesday March 21, 2018 8:30am - 9:30am
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

The Red Button: APEX Desktop Applications
Can't I just have an icon on my desktop to run the APEX application? Can the APEX application access my desktop resources? Questions like these have been asked; let's explore some possibilities. This presentation will show you how to run your APEX application as a native desktop application using Node.js and Electron.

Speakers
avatar for Jeff Eberhard

Jeff Eberhard

Insum Solutions
Jeff Eberhard has more than 10 years of Oracle experience. Jeff is currently employed by Insum Solutions providing Oracle Application Express services to multiple clients. He is passionate about how Oracle Application Express can be used to build database-driven web applications... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
1110, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Achieving World-Class Financial Transformation
The modern finance organization is dealing with more data than ever before, from both internal and external sources. Organizations require more complex analysis—faster than ever before—at a lower cost. This session will cover key focus areas to achieve lean finance, with better data quality, and superior competitive intelligence, with a particular focus on Enterprise Performance Management solutions (EPM). Benefits include:
• Streamlining to achieve the lean finance function
• Using technology to improve data quality and speed
• Getting better reporting and analysis for your business insight

Speakers
avatar for Seth Landau

Seth Landau

Vice President - Consulting Services, MindStream Analytics
Seth Landau is vice president, consulting services, at MindStream Analytics with 20+ years of finance, EPM, and operations management experience. Seth speaks at conferences nationwide on industry best practices and Oracle's EPM offerings.



Wednesday March 21, 2018 9:45am - 10:45am
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Leveraging Partitioned External Tables: Primer and Practical Examples
Oracle Database 12is the first release to offer the capability to access a file in HDFS or HIVE format as an external table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language. Through presentations and online demonstrations, this session will:
• Review the growing need to access big data in different file formats stored in NoSQL databases and data lakes.
• Illustrate how to leverage Oracle Big Data SQL to access and process data in other formats.
• Provide practical boundaries for leveraging these techniques to access data in various external formats

Agenda:
1. Big Data and IoT: Beyond Simplistic Rows and Columns
2. A Sharper Knife You Already Own: The Case for SQL vs. NoSQL
3. New EXTERNAL Table Drivers: ORACLE_HDFS and ORACLE_HIVE
4. Leveraging Partitioning and Parallelism with EXTERNAL Tables
5. Practical Examples of Leveraging Big Data Access Drivers
6. Now, a Warning: Limitations of Big Data SQL and Its New Drivers

Speakers
avatar for Jim Czuprynski

Jim Czuprynski

Oracle ACE Director, ViON Corporation
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after pub... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Oracle Database 12.2 Application Containers
The single most important new feature in Database 12.2 is the new application containers that come with the multitenant option. The container database architecture and multitenancy were introduced into the Oracle database in version 12.1 and the capabilities have been vastly expanded in release 12.2, combining brilliant new technology with a solid business case.
This session by ACE Director Alumnus Daniel Morgan will present both the concept and the reality with a demonstration, live in SQL*Plus, of the entire process, and all of the code, required to implement a container database with application containers.

Speakers
avatar for Daniel Morgan

Daniel Morgan

Oracle ACE Alumni, Meta7
Oracle ACE Director Daniel Morgan has more than 25 years' experience working with Oracle products. Dan wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is curr... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
3180, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Enterprise-Grade PL/SQL Development
PL/SQL can be done right, but too often is not, which leaves a bad taste in the mouths of developers, testers, and managers who have to deal with poorly built PL/SQL source code. We will seek to prevent this, and show how powerful, fast, and robust development in PL/SQL can be by diving into the following best practices:
• Standards, templates, IDEs, and formatters
• Open-source frameworks and libraries
• Version control
• Agile tools and practices for design and deployment
 • Instrumentation
 • Documentation
 • Keeping it simple

Speakers
avatar for Bill Coulam

Bill Coulam

Church of Jesus Christ of Latter-day Saints
Bill has been designing and building large volume, custom Oracle systems since 1995 and writing and speaking at Oracle user groups since 2001. He was honored to be nominated by Oracle ACE Directors for the 2015 Oracle Database Developer Choice Award in PL/SQL.  Bill currently se... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Tricks and Techniques with Oracle User Defined Types
This presentation shows you how to define and use Oracle User Defined Types (UDTs). Learn how to write and use object types and subtypes without the overhead of methods, how to use them as parameters and return types in PL/SQL functions and procedures, and how to leverage them inside Oracle’s substitutable columns. Learn to write joins to substitutable columns and nested tables, and export object type contents to ordinary query result sets.

Speakers
MM

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho
Michael McLaughlin, Oracle ACE, is a professor at BYU-Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Can I Get That as a PDF or Excel File? How SQL Developer's Reports Can Help
Oftentimes we utilize a BI tool to help individuals dynamically look at the data. But there are sometimes cases when individuals want a hard copy, or play with the data themselves and they don’t need or want a whole dashboard. This presentation will look at Oracle SQL Developer’s reports as an option to take before building a dashboard. What features are available, and how has it been used to help meet departmental needs?

Speakers
avatar for Susan Schaefer

Susan Schaefer

University of Utah
Susan Schaefer is a data warehouse analyst with the University of Utah. She has been at the U for four years. She acts as a liaison for her department, audget and analysis, and the university's BI team. She spends most of her days in SQL Developer, checking, organizing, and analy... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Swimming Through the FDM to FDMEE Upgrade
Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) is the successor to Oracle Financial Data Quality Management (FDM). As version 11.1.2.4 of FDM is no longer available to license, organizations will need to transition to FDMEE. There are many similarities and also many differences between the two products that need to be accounted for when "swimming" through the upgrade process. This presentation will cover:
• Similarities and differences between FDM and FDMEE
• FDM to FDMEE migration utility—what it does and does not do
• Tips and considerations for upgrades

Speakers
AH

Andrew Hales

Vertical Edge
Andrew is a senior consultant with Vertical Edge possessing over 10 years of diversified IT, financial systems, and accounting experience. Andrew has been working with Oracle Hyperion products for over seven years. He has extensive experience with Hyperion Financial Management, F... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

10:45am

Break With Sponsors - 7th Floor
Wednesday March 21, 2018 10:45am - 11:15am
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Secure RESTful Services
Web services are everywhere these days. You may find yourself needing to both produce and consume them, depending on the requirement. The data transmitted from web services is just as sensitive as data within your own database, so you need to ensure that it’s being transmitted in the most secure fashion possible. This session will cover how to create and also secure a RESTful web service via ORDS using OAuth 2.0. It will also cover how to consume a web service that requires OAuth 2.0 based authentication via PL/SQL APIs.

Speakers
SS

Scott Spendolini

Oracle ACE Director, Sumner Technologies
Scott Spendolini is a principal at Sumner Technologies, a world-class Oracle services, education, and solutions firm. Throughout his professional career, he has assisted a number of clients from various verticals with their Oracle APEX development and training needs. Scott is a l... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Leveraging Advanced SQL for Analytics
Most analysts, data scientists, and aspiring data scientists know basic SQL for pulling data from databases that they then put into Python, R, and other tools. What if you could save a step and run the analytics right in the database? With the Oracle Database you can do most of the same functions that you could do with a data miner, R, statistics, etc. all with SQL. In this session, we’ll walk through advanced SQL functions such as statistics functions, analytic & windowing SQL, pattern matching, and prediction.

Speakers
avatar for Michelle Kolbe

Michelle Kolbe

Oracle ACE, Red Pill Analytics
Michelle Kolbe is the current UTOUG president. She has presented at many Oracle Corporation and other tech events, including Oracle OpenWorld, Collaborate, and the Oracle OTN Latin America Tour.



Wednesday March 21, 2018 11:15am - 12:15pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

One Ring to Rule Them All: Consolidating Messaging into Slack
Discover how Bodybuilding.com simplified the lives for its on-call teams, lessened the burden on senior staff, shortened issue resolution times, and discovered a new way to share diagnostic information using Slack, a cloud-based team messaging and collaboration tool. Slack opens up new ways to manage, monitor, and control database environments.
We'll discuss future plans, including Slack-driven automation and natural language queries that will distribute or eliminate many low-level tasks and tactical work, freeing DBAs to focus on more important efforts.
Learning Objectives:
• Learn how we used Slack to unify messaging and notifications into a single interface, providing greater control over how, what, when, and why we're informed of events.
• Discover how Bodybuilding.com leveraged Slack to solve common complaints by on-call teams—alert fatigue, false alarms, being tied to a laptop or VPN, compartmentalization, and low or limited visibility of issues.
• See how to use the Slack API to interact with a database to allow remote management, automation, and natural language query and control by end users.

Speakers
SS

Sean Scott

Bodybuilding.com
Sean is a database administrator with over 20 years' experience managing Oracle. For 15 years he ran a consulting firm specializing in database technologies, backup and recovery, performance tuning, and database design. He's developed high-performance solutions to meet the extrem... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

What's New in Oracle Database 18c
The cloud changes everything, and Oracle Database recently switched to a new annual release model, with Oracle Database 18c as the first release in this new model. This session is a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team.

Speakers
avatar for Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation
Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog at https://sqlmaria.com and a contributing author to the Oracle Optimizer... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Dating Games
Of the three major datatypes, the DATE is the one with potential to cause the most headaches. You can add them, subtract them, even average them. What?! Average them? Yep—I'll show you how. Oh, and not just strictly dates, I'll dive into problems with times, too. So, even if you think you know all there is to know about dates, married or single, swipe right for Dating Games.

Speakers
DS

Daniel Stober

Intermountain Healthcare
Dan Stober has been working in Oracle databases since 2001 and is an Oracle Certified SQL Expert. He is a regular presenter at local user group conferences, and has made four prior appearances at IOUG Collaborate and two invitations to Oracle OpenWorld. Frequent attendees at local events know Dan as the presenter who throws candy bars to attendees for participation in his sessions! He is a past trustee on the board of the Utah Oracle Users Group and has taught Oracle Workflow and Oracle PLSQL. Dan's published works include his article on Analytic SQL, which appeared in the Winter 2012 issue... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

PL/SQL Secure Coding Practices
This session is an expansion of the Holistic Database Security presentation that will help you secure your high-performance code from SQL injection attacks. We'll define the SQL injection attack vector and various ways to write code that is immune to SQL injection and improve the performance of your code.
This presentation will cover:
• Common errors in PL/SQL that lead to SQL injection attacks
• Code architecture that separates data from code and also helps trace bottlenecks
• Oracle PL/SQL 12c features that limit access paths to data, thereby implementing part of the trusted path
• Other PL/SQL features from before 12that help to ensure your PL/SQL does what you expect it to do

Speakers
avatar for Robert Lockard

Robert Lockard

Oracle ACE Director, Oraclewizard
Robert P. Lockard is a professional Oracle DBA, designer, developer, and project manager. For the past twenty years he has worked as an independent consultant, providing quality services to his customers at a reasonable price. He's worked in financial intelligence tracking money... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
3180, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Different Types of Tables and Their Uses
This discussion will look at tables, views, materialized views, global temporary tables, and more, and delve into the different uses of these objects. We'll discuss the pros and cons of the objects and when to best use them. We will also look at the different column types and how to use them.

Speakers
SH

Scott Heffron

Choose The Right SQL
Server Scott Heffron has been developing database applications and processes for 20+ years. His initial project was a GIS project that shared data between Oracle, Sybase, and SQL Server. He has created handheld and web-based database applications. He has spent the last years arch... Read More →



Wednesday March 21, 2018 11:15am - 12:15pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

The Future of EPM—Understanding all the Choices: Cloud, On Premise, Other Technologies
There are many EPM software solution options available today, so which one is right for your organization? Some things to keep in mind when evaluating EPM solutions include integration capabilities, functionality, scalability, delivery mode, usability, accessibility, reliability, and support. Join us as we provide insight into the different options, how best to decide what functionality is important for your organization, and which tools are going to provide the best solution to meet your needs. Participants will learn best practices for evaluating EPM options, understand what functionality is important, and choose the best solution of your organization.

Speakers
AL

Alex Ladd

MindStream Analytics
Alex Ladd is CEO of MindStream Analytics with over 20 years of experience in Performance Management, BI, and analytics. Alex speaks at conferences nationwide on industry best practices, data transformation, and improving corporate decision making capabilities.



Wednesday March 21, 2018 11:15am - 12:15pm
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

12:15pm

Lunch
Sponsored by ViON

Wednesday March 21, 2018 12:15pm - 1:15pm
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

Hacking Oracle APEX
There have been many conference presentations, books, and webinars that discuss and demonstrate how to secure APEX applications. But most, if not all, of these never get into what an actual attack can look like and the damage it can end up causing. This session will demonstrate just that—actual Cross Site Scripting and SQL Injection attacks against APEX applications that do a whole lot more than print “hello, world." In addition to demonstrating the attacks, we will also cover what you can do to mitigate and prevent these types of attacks.

Speakers
SS

Scott Spendolini

Oracle ACE Director, Sumner Technologies
Scott Spendolini is a principal at Sumner Technologies, a world-class Oracle services, education, and solutions firm. Throughout his professional career, he has assisted a number of clients from various verticals with their Oracle APEX development and training needs. Scott is a l... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

How to Keep Your Database Running Using Oracle's Automatic Diagnostic Repository (ADR)
Learn how to be a proactive DBA and keep your databases running by using Oracle's new tool, Automatic Diagnostic Repository (ADR). This presentation will help database administrators provide their customers with a way to reduce the cost of ownership by reducing the time to troubleshoot anomalies. It will also help administrators gather information to see what is potentially causing problems, which will bring about higher availability. When you get back home, you will be able to use this tool to provide and improve the reliability and availability of your system.
This presentation will cover:
  • What is ADR and what does it do? 
  • What are some of the commands? 
  • How do I use it? Step-by-step example of troubleshooting a problem.
  • How this tool can package incidents and problems information for uploading to Oracle support.
  • Q&A

Speakers
avatar for Michael Nelson

Michael Nelson

Northrop Grumman
Michael is a BS-degreed computer science professional with an MBA and 20 years' experience as senior database administrator with Northrop Grumman. He is experienced in managing object relational database (Oracle) including installing configuring, maintaining, and troubleshooting... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

Oracle Optimizer—Best Practices for Managing Optimizer Statistics
During the optimization of a SQL statement, the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent the execution plan from becoming suboptimal. This presentation includes information on the features introduced in both Oracle Database 11g and 12c to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.

Speakers
avatar for Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation
Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog at https://sqlmaria.com and a contributing author to the Oracle Optimizer... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

Securely Clone to Non-Prod Environments
Agile development and DevOps force organizations to clone production faster and more efficiently to non-production to enable the rapid tempo of improvement expected by customers. Also, outsourcing, offshoring, and cloud migration mean cloning databases outside the corporate firewall. This adds up to massive security loopholes. GDPR, starting May 2018 in the EU, means massive fines in addition to bad publicity, damage to brand, and shareholder outrage. It won't be long before legislation similar to GDPR comes to the US, and it is wise to prepare. Come understand and learn how data masking resolves these problems, allowing confidential data to be confined to production only, where it belongs. Reduce the surface of risk, and concentrate security efforts where they are most necessary.

Speakers
avatar for Tim Gorman

Tim Gorman

Sr Technical Manager, Delphix
Tim is a longtime contributor to UTOUG and works in field services for Delphix, assisting customers with data virtualization and masking in order to make data available more securely with less friction. He is co-author of six books on Oracle, a member of the Oak Table network, an... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

SQL Developer Tips & Tricks
You could read the docs, watch the videos, and play around with the tool for a few hours. Or, you could sit back for an hour and watch the product manager show you ALL of "the cool stuff." The goal is to pick up even just a couple of new techniques that will make your job SO much easier as you build those new tables, write that perfect SQL statement, or even just copy a result set out to Excel (yes, we know that's what you do). This is designed to be an interactive and FUN presentation. Heckling is encouraged.

Speakers
avatar for Jeff Smith

Jeff Smith

Senior Principal Product Manager, Oracle Corporation
Jeff Smith is product manager for Oracle SQL Developer, SQL Developer Data Modeler, SQLcl, and REST Data Services. Jeff blogs at https://www.thatjeffsmith.com and tweets as @thatjeffsmith, and has worked with Oracle Database since 7.3.



Wednesday March 21, 2018 1:15pm - 2:15pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

EPM Cloud and On-Prem Hybrid Solutions
As the number of EPM products offered via the cloud increases the need for hybrid solutions, on-premise and cloud products are becoming more prevalent. Come learn the options for integrating Oracle EPM cloud products with your on-premise applications. Best practices and considerations for reporting and security before deciding on a hybrid solution will also be covered.

Speakers
AH

Andrew Hales

Vertical Edge
Andrew is a senior consultant with Vertical Edge possessing over 10 years of diversified IT, financial systems, and accounting experience. Andrew has been working with Oracle Hyperion products for over seven years. He has extensive experience with Hyperion Financial Management, F... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:15pm

Nonverbal Ninja Tricks to Get Your Way On a Project
Former FBI Special Agent Jack Schafer withdrew information from foreign spies and convinced foreign diplomats to turn against their country and work for the United States. He built a relationship of trust with these individuals by following the pattern all humans go through in developing trust and friendship. Certified body language trainer Jeff Baird will share some of these science-backed strategies to help you build trust, while maintaining respect and influence with those you work with.

Speakers
avatar for Jeffrey Baird

Jeffrey Baird

The Church of Jesus Christ of Latter-day Saints
Jeff has been in IT for nearly 20 years, half of that in business intelligence and data warehousing. He's currently a BI manager of 25 engineers at the LDS church. He's a corporate trainer and speaker on hard and soft skills. He's also a certified body language trainer (who knew... Read More →



Wednesday March 21, 2018 1:15pm - 2:15pm
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:15pm

Break With Sponsors - 7th Floor
Wednesday March 21, 2018 2:15pm - 2:45pm
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

Exploring APEX 5.1's Interactive Grid and Other New Features
APEX 5.1 became available in December 2016 after multiple early adopter trials and lots of testing. This session will explore some of APEX’s new features, including Interactive Grid, Charts integrated with Oracle JET, and more. Attendees will see, in cloud-based demonstrations, how Interactive Grid provides the best features of Interactive Reports and Tabular Forms and how easy it is to create a Master->Detail->Detail experience for your users. Universal theme and UX improvements are many. Come see how the per-user preferences and asynchronous dynamic actions work.

Speakers
avatar for John King

John King

Oracle ACE Director, King Training Resources
John Jay King is a Partner in King Training Resources, a US-based firm providing instructor-led training since 1988 for application and database developers. John develops and presents customized courses in a variety of topics including Oracle, Cloud, MAF, ADF, Web Services (REST... Read More →



Wednesday March 21, 2018 2:45pm - 3:15pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

Who Are These People? Analyzing Collaborate Attendee Data with Advanced Analytics
Join me for a case study in which I explain how I used Oracle Advanced Analytics tools to answer questions for the user group boards about the attendees of Collaborate and their experiences. I’ll show the process of first collecting the data and cleaning it to make it usable. Then I’ll show the data mining and machine learning algorithms I used within SQL Developer Data Miner. Lastly, I’ll show R functions that I used for further analysis. In the end, these insights will improve your experience with Collaborate!

Speakers
avatar for Michelle Kolbe

Michelle Kolbe

Oracle ACE, Red Pill Analytics
Michelle Kolbe is the current UTOUG president. She has presented at many Oracle Corporation and other tech events, including Oracle OpenWorld, Collaborate, and the Oracle OTN Latin America Tour.


Wednesday March 21, 2018 2:45pm - 3:15pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

Introducing the Oracle Autonomous Database
Have you heard about the Oracle Autonomous Database? What does this mean to you and how can you benefit from this database offering? In this session you will get the chance to find out from Oracle Database Product Management what the goals for the Oracle Autonomous Database are, along with what Oracle has developed to deliver these capabilities to our customers.

Speakers
avatar for Sean Stacey

Sean Stacey

Product Manager, Oracle Corporation
Sean Stacey is a director of product management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle D... Read More →



Wednesday March 21, 2018 2:45pm - 3:15pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

Understanding the Oracle Database Release Model and Patching
Starting with Oracle 18c, Oracle has moved to a new release numbering scheme, release model, and patching model for the Oracle database. What does it mean for customers? What is the best strategy? And how will the transition from the old to the new model work? This presentation will map the old release numbering to the new model, describe how quarterly patching will proceed going forward, and give you recommendations for how to adopt new releases. In addition, you will get pointers to all the important support notes and resources that you will want at your fingertips as an informed DBA dealing with upgrades and patching.

Speakers
avatar for Maria Colgan

Maria Colgan

Master Product Manager, Oracle Corporation
Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria's core responsibility is creating material and lectures on the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer. Maria is the primary author of the SQLMaria blog at https://sqlmaria.com and a contributing author to the Oracle Optimizer... Read More →



Wednesday March 21, 2018 2:45pm - 3:15pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

External Tables—Ground Zero to Expert
This presentation explores how to define and use external tables, including the parallel and preprocessor options. It reviews how to write external tables that use comma separated value and position-specific files. It will demonstrate how to troubleshoot the log files, verify operating system and Oracle database privileges, write Bash shell scripts that provide preprocessor instructions, and consume and optimize external table data in ETL processes.

Speakers
MM

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho
Michael McLaughlin, Oracle ACE, is a professor at BYU-Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g... Read More →



Wednesday March 21, 2018 2:45pm - 3:15pm
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

The Cloud is Ready—Are You Cloud Ready?
Everyone is talking about moving to the cloud—but is your company ready for a cloud solution? This session will discuss the different types of cloud options available as well as concerns such as best practices in training, data integration, backup and recovery, and security for your cloud-based systems. Participants will:
  • Learn different types of cloud solutions available
  • Discuss best practices in training users of cloud applications
  • Learn proper backup and recovery options for cloud solutions
  • Lean how to handle data integration between on-premise and cloud solutions
  • Understand more about security technology and best practices for cloud solutions

Speakers
AL

Alex Ladd

MindStream Analytics
Alex Ladd is CEO of MindStream Analytics with over 20 years of experience in Performance Management, BI, and analytics. Alex speaks at conferences nationwide on industry best practices, data transformation, and improving corporate decision making capabilities.



Wednesday March 21, 2018 2:45pm - 3:15pm
3180, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm

Be a Better [Blank]
This session is a break from the usual technical session. Instead, this talk is a discussion of non-technical attitudes, practices, and habits to adopt to make the technical aspects—constant learning, tighter schedules, fewer resources—on an Oracle IT career easier to handle.
A 2018 technical career means constantly learning to stay current, marketable, and useful. To do this in today’s fast-changing environment takes more than the standard 9-to-5 job—it takes a personal commitment to better one’s non-technical skills and habits. Suggestions include getting a mentor, being a mentor, seeking and doing homework (in the form of online or in-person classes, meetups, workshops and conferences), volunteering (giving back also helps us learn), changing habits, and staying balanced (including vacations).
Attendees will gain practical tips for personal growth to complement growth in technical skills, learn the benefits of mentoring and volunteering, hear concrete suggestions for honing non-technical work habits, take a break from the purely technical, and think about how to be better at what they do. Stop in and gain a few tips for getting back into a positive state of mind, working toward being a better [blank].

Speakers
avatar for Karen Cannell

Karen Cannell

Oracle ACE Associate, TH Technology
Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database appli... Read More →



Wednesday March 21, 2018 2:45pm - 3:15pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

How to Load Data, Let Me Count the Ways—Revisited
This session is an update of a 2012 session that outlined data load options for loading CSV and XLSX data into an Oracle database via an APEX application. A lot has changed in six years: loading requirements have changed (more XLSX, CLOBs and LOBs), environments have changed (more hybrid and cloud-based), and there are enhanced and new data load options to choose from.
This presentation will outline the steps to move files to a typical cloud environment for load. We will mention, but not detail, options for loading via JavaScript or node.js functions, and where such options may be appropriate. This presentation will focus on in-application data load options for routine, repeated, or one-of programmatic data loads. Attendees will learn about enhancements to common data load methods and interfaces they may not be aware of (PL/SQL-based XLSX loading interfaces).
Let’s revisit the ways to programmatically load data into an on-premise or cloud Oracle database. This presentation reviews a collection of data load options, including the APEX Data Load wizard, external tables, ORDS bulk data load, open source interfaces, plugins and APEX APIs helpful for custom coding. Demonstrations and examples are geared toward APEX applications, yet most of the techniques described can be used in any PL/SQL application. Attendees will gain sufficient knowledge to make an intelligent choice for their application data loading needs.

Speakers
avatar for Karen Cannell

Karen Cannell

Oracle ACE Associate, TH Technology
Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database appli... Read More →



Wednesday March 21, 2018 3:30pm - 4:30pm
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Incorporating Mobile into Your Reporting
Get your information on the go. Mobile solutions for analytics have never been more robust. It’s now easier than ever to incorporate a mobile strategy for your business. In this session, you will learn which mobile options are available for you and best practices how to deploy them securely within your organization. Learn about mobile options for your analytical data, how to implement a mobile reporting strategy, and best practices in mobile security and management.

Speakers
AL

Alex Ladd

MindStream Analytics
Alex Ladd is CEO of MindStream Analytics with over 20 years of experience in Performance Management, BI, and analytics. Alex speaks at conferences nationwide on industry best practices, data transformation, and improving corporate decision making capabilities.



Wednesday March 21, 2018 3:30pm - 4:30pm
3180, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Security for Oracle DBAs and Developers
Almost every major break in to an Oracle Database has been performed by persons with a valid user ID and password. These are attacks that cannot be prevented by a LDAP, a firewall, or licensing another product. The best Oracle Database security can be obtained by properly configuring the tools you have already licensed from Oracle, but which were not enabled, by default, during installation. This presentation by Oracle ACE Director Alumnus Daniel Morgan will focus on proper configuration of the tools Oracle has been distributing for more than a decade, including live demos in SQL*Plus.

Speakers
avatar for Daniel Morgan

Daniel Morgan

Oracle ACE Alumni, Meta7
Oracle ACE Director Daniel Morgan has more than 25 years' experience working with Oracle products. Dan wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is curr... Read More →



Wednesday March 21, 2018 3:30pm - 4:30pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Taking ASH Analysis to the Next Level—Plan Change and Parsing Detection/Analysis
Sometimes snapshot time-based (AWR) performance data does not provide the level of detail we need to diagnose performance issues. Usually Oracle Active Session History (ASH) data solves this limitation by providing session-level sample data. However, we can go further by creatively using ASH data to do things that are not possible using standard ASH and time-based analysis. This presentation will demonstrate how to use ASH data to pinpoint SQL plan changes. Also, it will show you how to detect parsing issues before they show up in the wait interface. The presentation includes demonstrations and where to get the free SQL, so you can take your ASH analysis to the next level!

Speakers
CS

Craig Shallahamer

Oracle ACE Director, OraPub
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professional... Read More →


Wednesday March 21, 2018 3:30pm - 4:30pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Array of Hope
Underused and misunderstood, PLSQL's array options are the antidote to aimless spaghetti code seen in so many PLSQL programs. In this session we'll cover the gamut, from BULK SQL operations to indexing by varchar, accomplishing what other languages would call "hash lookups" or "dictionaries." Included in the hour will be some use cases and a look at some of the errors and gotchas to be aware of. Easy and powerful.

Speakers
DS

Daniel Stober

Intermountain Healthcare
Dan Stober has been working in Oracle databases since 2001 and is an Oracle Certified SQL Expert. He is a regular presenter at local user group conferences, and has made four prior appearances at IOUG Collaborate and two invitations to Oracle OpenWorld. Frequent attendees at local events know Dan as the presenter who throws candy bars to attendees for participation in his sessions! He is a past trustee on the board of the Utah Oracle Users Group and has taught Oracle Workflow and Oracle PLSQL. Dan's published works include his article on Analytic SQL, which appeared in the Winter 2012 issue... Read More →



Wednesday March 21, 2018 3:30pm - 4:30pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Blockchain? What is Blockchain? Why Do I Care?
As our industry's digital transformation continues, it is becoming apparent that current methods for handling transactions, contracts, records, and other data is not keeping up. Blockchain technology may be the key to modernizing and protecting transactions. Blockchain provides an open, distributed ledger updateable only by consensus of involved parties. The ability to efficiently store transactions in a way that can be verified makes Blockchain attractive anywhere in industry that data and value are in motion. Blockchain is most commonly thought of as the mechanism enabling the Bitcoin and Ethereum digital currencies; but, its most useful place may well be in securing IoT input, medical records, contracts, transactions, and other data transmissions. Attendees to this session will learn the basics of Blockchain, how it is currently used, and where organizations are exploring its use in the future. We will discuss the security aspects (and issues) of Blockchain technology. Topics discussed will include: distributed data shared by all parties, peer-to-peer transmission eliminating need for centralized nodes, transparency, irreversibility of record changes, and use of computational logic to govern transactions between nodes. Come learn how Blockchain might be incorporated into your organization's existing and future system.

Speakers
avatar for John King

John King

Oracle ACE Director, King Training Resources
John Jay King is a Partner in King Training Resources, a US-based firm providing instructor-led training since 1988 for application and database developers. John develops and presents customized courses in a variety of topics including Oracle, Cloud, MAF, ADF, Web Services (REST... Read More →



Wednesday March 21, 2018 3:30pm - 4:30pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:30pm

Ten Steps to Zen with Oracle's Account Reconciliation Manager (ARM)
Medium to large organizations often need to perform thousands of account reconciliations during the quarterly and monthly close. Some of the key challenges include making sure all accounts are being reconciled, with many companies using a manual process or Excel to keep track of status. This can lead to errors including missing or lost reconciliations, incorrect balances on roll-forwards, and changing balances after certification. This presentation will introduce Ten Steps to Zen with Oracle's Account Reconciliation Manager (ARM) that can reduce these pains and make your close more efficient and faster.
Key features to be reviewed include:
• Auto reconciliation of accounts
• Configurable frequencies and approval levels
• Pre-built dashboards for monitoring status and performance

Speakers
avatar for Seth Landau

Seth Landau

Vice President - Consulting Services, MindStream Analytics
Seth Landau is vice president, consulting services, at MindStream Analytics with 20+ years of finance, EPM, and operations management experience. Seth speaks at conferences nationwide on industry best practices and Oracle's EPM offerings.



Wednesday March 21, 2018 3:30pm - 4:30pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112
 
Thursday, March 22
 

7:30am

Breakfast
Thursday March 22, 2018 7:30am - 8:30am
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

APEX 18.1 New Features
APEX 18.1 is the next step in the evolution of Oracle Application Express. Due out soon, APEX 18.1 introduces several new features that will continue to make it even easier to build dynamic, beautiful, secure applications based on the Oracle database.
This session will discuss and demonstrate the new features in APEX 18.1—including the new create application wizard, REST enabled SQL, web sources, REST workshop, and OAuth2 authentication as well as numerous enhancements.

Speakers
SS

Scott Spendolini

Oracle ACE Director, Sumner Technologies
Scott Spendolini is a principal at Sumner Technologies, a world-class Oracle services, education, and solutions firm. Throughout his professional career, he has assisted a number of clients from various verticals with their Oracle APEX development and training needs. Scott is a l... Read More →



Thursday March 22, 2018 8:30am - 9:30am
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

The E-Business Suite R12.2.7 Upgrade Workshop for Managers, DBAs, and Developers
Release 12.2 is the new standard for the E-business suite. I’ll describe the tried-and-true tips and techniques to decrease your downtime during the upgrade. We'll discuss the upgrade to 12.2.7, R12.2 Architecture concepts, including ADOP, the Online Patching Utility, the new utilities and new processes developers will have to follow in order apply customizations, and the Weblogic server. Managers should attend this session to minimize risk in deploying this new technology.

Speakers
avatar for Mike Swing

Mike Swing

Oracle ACE, TruTek
CTO of TruTek, R12.2 upgrade expert, consultant, and instructor for E-Business Suite upgrades, Oracle ACE and OCP DBA, with 22+ years of Oracle DBA experience.



Thursday March 22, 2018 8:30am - 9:30am
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

Oracle Autonomous Data Warehouse Cloud
Oracle Autonomous Data Warehouse Cloud (ADWC) is fully-managed, high-performance, and elastic. You will have all of the performance of the market-leading Oracle Database, in a fully-managed environment that is tuned and optimized for data warehouse workloads. This session you will learn about Oracle's newest cloud offering, the Oracle Autonomous Data Warehouse Cloud, and learn how the Oracle Autonomous Data Warehouse Cloud delivers industry-leading data warehouse technology with unmatched flexibility, enterprise scale and simplicity.

Speakers
DL

Daniel Liu

Oracle Corporation
Daniel Liu is a principal solution architect at Oracle Corporation and co-author of "Oracle Database 10g New Features" by Rampant TechPress. He has 20 years of experience working with both Fortune 500 companies and public sector entities to apply technology to help solve business... Read More →


Thursday March 22, 2018 8:30am - 9:30am
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

Oracle Privilege History
Have you ever dropped a table, user, or role by mistake and tried to restore privileges but couldn't remember what to grant or to whom? You queried the dba views only to find what is currently granted, not what was granted. Now, your only option is to guess which grants to make and then wait for people to complain, or processes to fail so you can figure out which grants were missed. Flashback is helpful, but won’t always solve the problem at hand. Creating a historical record of privileges will allow you to restore the correct suite of privileges to users or roles quickly and accurately without guessing. This presentation will provide steps to set up a process to track privileges historically.

Speakers
DR

Dallin Rogers

Intermountain Healthcare
I graduated from the University of Utah with a Master's Degree in Information Systems. I have been with Intermountain Healthcare for 7 years as a Data Architect on the EDW team. The last 3 years, I have been the EDW Database Operations Lead. | | Since my arrival, my coworkers... Read More →



Thursday March 22, 2018 8:30am - 9:30am
5180, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

Create RESTful Services Using ORDS (Oracle Rest Data Services)
Many organizations store the “crown jewels” in their Oracle databases and need to make that data available easily to mobile and cloud-based applications. Many have also followed the “thick database” model to keep business logic safely inside the database. The modern world of services and microservices is increasingly reliant upon HTTP-style or REST-style APIs. Oracle’s REST Data Services (ORDS) makes getting data from Oracle Database, Oracle Procedures, Oracle Database JSON document store, and Oracle NoSQL data sources easy. In this session attendees will learn how to use ORDS to make data available using industry-standard API calls. ORDS allows creation of RESTful APIs to access Oracle’s database tables, views, and stored PL/SQL that interact using JSON documents. Developers may use the ORDS-created APIs without needing to know (or see) SQL or PL/SQL. Attendees will learn how to use SQL Developer to first set up ORDS and then use SQL Developer to create RESTful services for database tables, queries, and procedures. Testing RESTful services created using ORDS is easily accomplished using a variety of openly available tools.

Speakers
avatar for John King

John King

Oracle ACE Director, King Training Resources
John Jay King is a Partner in King Training Resources, a US-based firm providing instructor-led training since 1988 for application and database developers. John develops and presents customized courses in a variety of topics including Oracle, Cloud, MAF, ADF, Web Services (REST... Read More →



Thursday March 22, 2018 8:30am - 9:30am
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

IoT to the Database: Soldering, ORDS, Oracle Jet, Python, and a Little PL/SQL
If you're like me, you use way too much power and you’re not quite sure where. Tracking your power usage is a great start, but analyzing the data is often easiest when it's in a database. Having to type it in by hand would be a pain; let's void a warranty instead!
Building on the "Watch me make a Watt-watcher" project (https://learn.adafruit.com/tweet-a-watt), I will start by giving an overview of the steps and components used to assemble the hardware. Next, we'll discuss what to do with the data. As the project says, we can save it to a file on our computer, upload it to a database, tweet it, or whatever you'd like. Of course, I want my data in a database. I'll simplify the data ingestion by taking advantage of a REST interface to a cloud database. I will walk through choosing a table for the data and enabling a RESTful service on it. Then I'll modify the project to post data to our new service. Once we get some data in the table, I'll display the data in a graph. You'll leave this session with the tools to track the data in your own projects and hopefully some new ideas. (But no electrical burns!)

Speakers
avatar for Blaine Carter

Blaine Carter

Developer Advocate for Open Source, Oracle Corporation
Blaine Carter is the Oracle developer advocate for open source. He applies his exploratory eye and tinkering inclinations to the intersection of open source and Oracle Database. He helps database developers improve their workflow using open source tools and promotes the use of op... Read More →



Thursday March 22, 2018 8:30am - 9:30am
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am

Absolute Beginning Docker for the Oracle Professional
All the cool kids are using Docker! Learn how to be a cool kid and leverage the power and convenience of containers. Even if you think you'll never adopt containers in practice, Docker still provides an opportunity for you to install and experiment with databases (and plenty of other technologies) on your laptop, without the complexity or burdens associated with virtual machines. It's possible to get a fully functional Oracle database running on a laptop in just a few minutes, with little effort or investment.
This presentation is intended for anyone curious about, or just starting out with, Docker. It provides a gentle introduction to containers and the terminology, what to download, and progresses through a demonstration of a simple Oracle database installation on Docker.
During this session, participants will:
• Learn about container technology and terminology
• Discover practical applications for Docker, both professionally and personally
• Experience the simplicity of an Oracle Database-on-Docker installation demonstrated from start to finish

Speakers
SS

Sean Scott

Bodybuilding.com
Sean is a database administrator with over 20 years' experience managing Oracle. For 15 years he ran a consulting firm specializing in database technologies, backup and recovery, performance tuning, and database design. He's developed high-performance solutions to meet the extrem... Read More →



Thursday March 22, 2018 8:30am - 9:30am
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Going to the Grid: Interactive Grid Essentials
Interested in Interactive Grid? Looking for practical guidance on when, why, and how to upgrade to or adopt the APEX Interactive Grid region type? This session examines the functionality, structure, and APIs (high level) of the new Interactive Grid region type as a replacement for Interactive Reports and tabular forms.
Should you upgrade and fix, or rebuild a customized region? We’ll compare Interactive Grid features with comparative (and/or lacking) features in Interactive Reports and tabular forms and demonstrate how to handle common requirements—checklists, cascading select lists, row-level validations, interactions between columns, navigation between fields, dynamic actions—to see what Interactive Grid does declaratively and where one may need to customize.
Attendees will learn the essentials for declarative features and common JavaScript-based customizations for Interactive Grids. Attendees will learn the essentials for declarative features and common JavaScript-based customizations for Interactive Grids.
This session is focused on mainstream APEX developers, or those new to APEX, who are looking to adopt Interactive Grids. The aim is to present JavaScript constructs and syntax for Interactive Grid JavaScript customizations, sufficient to help traditionally PL/SQL-based users transition their existing interactive report or tabular form customizations from PL/SQL to their JavaScript equivalents.

Speakers
avatar for Karen Cannell

Karen Cannell

Oracle ACE Associate, TH Technology
Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database appli... Read More →



Thursday March 22, 2018 9:45am - 10:45am
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Adding Predictive Modeling to Your Forecast Process
Everyone talks about adding predictive analytics to their forecasting process, but many don’t know where or how to start or what that means. How should it be incorporated into the current process? Which pieces of the process does it replace? The answer depends on your organization and its data, but there are strategies that can help all companies begin the journey of adding predictive analytics to their forecasting and they will be shown and discussed during this presentation.
Many finance organizations are searching for a way to better use technology to help them predict what will happen in the future and how they will perform. This presentation will offer them a glimpse at strategies to begin leveraging predictive analytics and drive a more efficient and accurate forecasting process. Participants will learn:
  •  What predictive analytics can accomplish 
  • Strategies for beginning the journey of adding predictive analytics 
  • Best practices for deploying predictive analytics in your organization.

Speakers
AL

Alex Ladd

MindStream Analytics
Alex Ladd is CEO of MindStream Analytics with over 20 years of experience in Performance Management, BI, and analytics. Alex speaks at conferences nationwide on industry best practices, data transformation, and improving corporate decision making capabilities.



Thursday March 22, 2018 9:45am - 10:45am
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Deploying an Oracle Database in a Docker Container
Containers as a deployment model for applications have gone mainstream. Why not get those same benefits from deploying your Oracle database in a Container? In this session, we will cover the different strategies for deploying an Oracle Database in a Container environment. The session will also include a demonstration of the deployment process.

Speakers
avatar for Sean Stacey

Sean Stacey

Product Manager, Oracle Corporation
Sean Stacey is a director of product management in Oracle's Server Technologies organization. Sean joined Oracle in 1997, and during his time with Oracle has focused much of his time supporting Oracle's partner community with programs primarily around the adoption of the Oracle D... Read More →



Thursday March 22, 2018 9:45am - 10:45am
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Oracle Database Sizing for the Cloud
Learn how to measure the CPU footprint of an Oracle Database to know what size, shape, and how many CPUs are necessary to host your Oracle Database in the cloud.
Attendees will learn how to:
  • Standardize ASH data
  • Use percentiles as a technique to calculate CPU requirement
  • Use the standard SPEC for CPU power conversion between source and target machines

Speakers
avatar for Jorge Barba

Jorge Barba

Accenture Enkitec Group
Jorge Barba is an information technology expert with over 20 years of Oracle experience. Jorge has a bachelor's degree in computer engineering from University of Mexico and a master of business administration from Rollins College in Florida. Jorge's experience includes supporting... Read More →


Sizing pdf

Thursday March 22, 2018 9:45am - 10:45am
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Understanding and Optimizing Oracle Memory Serialization Access (Latches and Mutexes)
Oracle memory serialization control is core to Oracle database operations. One of the most fascinating topics in Oracle internals and performance optimization is memory serialization. We will look at when serialization is used, how it works, how we can influence its operation, and how we can diagnose problems. But, it's a complex situation. To get the upper hand on serialization control, this presentation will explore the lock (a little), the latch (a lot), and the mutex (a whole lot). Topics include performance diagnosis, how Oracle implements latches and mutexes, and the related internal algorithms. Special attention is given to the library cache mutex operations. This is a very practical yet deep internals presentation, filled with amazing discoveries about how Oracle works.

Speakers
CS

Craig Shallahamer

Oracle ACE Director, OraPub
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professional... Read More →


Thursday March 22, 2018 9:45am - 10:45am
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

Automate Database Deployment with Python
The presentation shows you how to leverage Python and Bash shell scripting with test driven development practices. It reviews the basics of using cx_Oracle to connect to the Oracle database. It then shows you how to hide user credentials inside Python while leveraging Bash shell scripting to organize and deploy database components. It provides you with sample code that you can easily use as the basis for your code deployments.

Speakers
MM

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho
Michael McLaughlin, Oracle ACE, is a professor at BYU-Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g... Read More →



Thursday March 22, 2018 9:45am - 10:45am
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

9:45am

It's All About the Bots: How Chatbots Will Revive Your EBS Applications
Millennials today don't talk, they chat; they don't have addresses, they have locations; they don't have email, they message. It's a new world out there, and enterprises either keep innovating or find their fate alongside Blockbuster, Borders, and Sports Authority.
In this session, you will hear about the newest kid on the block—Oracle's Intelligent Bot Service—and how it can help change your app from another icon cluttering your phone to a transformative part of your business. These digital agents will be able to support not only today's business needs but what's coming next to server mobile strategies into the future. We will also show a live demo and customer case study. In this session, we will learn how to develop our very first BOT and the pieces we need to make our conversational applications work. Learn how intents, flows, entities, and conversational applications come together to bring desktop applications into the next generation.

Speakers
avatar for Alex Gorbatovsky

Alex Gorbatovsky

AuraPlayer
Alex Gorbatovsky is the lead software engineer at AuraPlayer, a company specializing in EBS /Oracle Forms solutions and modernization. Throughout his years of  developing automatic digital transformation tools, and leading various projects with large scale customers, he became intimately familiar with some of the main challenges that EBS/Forms clients are... Read More →



Thursday March 22, 2018 9:45am - 10:45am
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

10:45am

Break With Sponsors - 7th Floor
Thursday March 22, 2018 10:45am - 11:15am
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

How We Used Microservices to Modernize our Oracle Forms/EBS Systems
Today agility is imperative to market competitively. Unfortunately, most enterprises have not succeeded in implementing a microservices architecture because their business logic is “trapped” in their back-office Oracle Forms/EBS legacy systems. Separating out the way the screen looks from the function it performs is such a daunting task that if it can even be achieved, it can take years and millions of dollars. But it is this “decoupling” of the business logic from the user interface that will allow organizations to “future proof” these applications and achieve the agility they need.
In this session, we will learn how to use microservices architectures to move forward while leveraging our Oracle Forms investments. The session will review several live demos and customer case studies. We will review the Oracle Cloud development platforms and rapid mobile development tools.

Speakers
avatar for Alex Gorbatovsky

Alex Gorbatovsky

AuraPlayer
Alex Gorbatovsky is the lead software engineer at AuraPlayer, a company specializing in EBS /Oracle Forms solutions and modernization. Throughout his years of  developing automatic digital transformation tools, and leading various projects with large scale customers, he became intimately familiar with some of the main challenges that EBS/Forms clients are... Read More →



Thursday March 22, 2018 11:15am - 12:15pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

The Growing Mobile Workforce: How CFOs Can Leverage Data and Technology to Tackle New Business Pressures
Your expanding mobile workforce puts new risk and financial strain on your organization at a time when it's vital to find new sources of growth and maximize profitability. We’ll show you Oracle’s fastest growing mobile technologies in the market today that give customers what they’ve come to expect from their mobile devices. With instant, real-time access to critical business intelligence, you can stay productive on-the-go with your tablets and smartphones. This session will explore the options for your enterprise—recommended for both a business and technical user.
Participants will learn:
• How the expanding mobile workforce is impacting the Finance function
• Ways CFOs are leveraging technology to drive accuracy and agility
• Why using data builds a culture of fact-based decision making to drive efficiency and control costs

Speakers
avatar for John Liette

John Liette

Product Architect, MindStream Analytics
John Liette is a Business Intelligence product architect with MindStream Analytics with years of experience with OBIEE and cloud solutions. John speaks at conferences nationwide on industry best practices and Oracle's BI and EPM offerings.



Thursday March 22, 2018 11:15am - 12:15pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Holistic Database Security
Attack Vector: how does your information leak? This presentation will include an open and frank discussion of organized gangs (e.g. Anonymous).
Risk identification and mitigation: Identify the risks in your system and come up with mitigation strategies. Audit: Identify what to audit, based on your risks. Audit too much and you will get bogged down; too little and you may miss a breach of security.
Database encryption: Encrypting the database, the tablespace, the tables, or atomic data? What is the cost and how do you accomplish it?
Network encryption: What are the risks of man-in-the-middle attack? How to set up network encryption. Backup encryption: What are the risks of losing a backup tape? How to encrypt backups using RMAN.
Data redaction: Who gets to see sensitive data? Do you want to expose credit card numbers or other PII to users? Introduction on how to set up data redaction.
Data masking: Do you refresh the test or QA environment from production? Do you need your testers to have access to your production data?

Speakers
avatar for Robert Lockard

Robert Lockard

Oracle ACE Director, Oraclewizard
Robert P. Lockard is a professional Oracle DBA, designer, developer, and project manager. For the past twenty years he has worked as an independent consultant, providing quality services to his customers at a reasonable price. He's worked in financial intelligence tracking money... Read More →



Thursday March 22, 2018 11:15am - 12:15pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Oracle's Cloud Strategy
Now more than ever, organizations must have a strategy and plan for moving to the cloud. What should you put into public clouds? Should you create a private cloud? What are the trade-offs between these different choices? You want to maximize your options and the different approaches you might take to move to a cloud environment. Explore the different stages of the journey to cloud, and how to define your road map to a cloud environment. Examine the trade-offs of the different approaches, whether you need a private, public, or hybrid cloud. See how Oracle's complete offering gives you the broadest set of options for implementing in a cloud.

Speakers
DL

Daniel Liu

Oracle Corporation
Daniel Liu is a principal solution architect at Oracle Corporation and co-author of "Oracle Database 10g New Features" by Rampant TechPress. He has 20 years of experience working with both Fortune 500 companies and public sector entities to apply technology to help solve business... Read More →


Thursday March 22, 2018 11:15am - 12:15pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Oracle Database 18c New Features for Developers and DBAs
Attendees are introduced to new and improved features of Oracle database directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, 128-byte names, JSON enablement, APPROX_ functions, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements. An overview of Multitenant Features (“Pluggable” databases; CDB &PDB) and In-memory Database are included.

Speakers
avatar for John King

John King

Oracle ACE Director, King Training Resources
John Jay King is a Partner in King Training Resources, a US-based firm providing instructor-led training since 1988 for application and database developers. John develops and presents customized courses in a variety of topics including Oracle, Cloud, MAF, ADF, Web Services (REST... Read More →



Thursday March 22, 2018 11:15am - 12:15pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Beyond High Availability, Replication's Changing Role
The explosive growth in both structured and unstructured data in most organizations is creating new information management challenges. Database replication as an architectural strategy moved into mainstream years ago. No longer is replication a solution only for configuring high availability, offload reporting, and zero downtime migrations—real-time integration with other types of databases on-prem and in the cloud has increasingly become the norm. Oracle databases need to integrate with other databases like SQL Server, Postgres, MySQL, Kafka, and more. This presentation will first cover the fundamentals of replication and then specific implementation considerations for several use cases, including disaster recovery, load isolation, auditing, data warehousing, and zero downtime migration to different platforms.

Speakers
avatar for Susan Wong

Susan Wong

Quest Software
Susan has been a solutions architect supporting business continuity and Oracle performance management and tuning for decades. Susan has performed numerous consulting engagements implementing configurations for reporting, migration, high availability and more to ensure companies m... Read More →



Thursday March 22, 2018 11:15am - 12:15pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

11:15am

Learn, Act, and Share—How to Increase Your Skills and Become an Expert
It really doesn't matter what career you are pursuing. What matters is that you want to be good at what you do. Don't be average in your career, be an expert. If you want to make more money, have better employment, and have people and companies coming to you, be at the top in whatever field or career you choose. Experts are sought after, highly paid, and love the work they do. So how do you become an expert? If you have ever asked that question, then this presentation is for you.
1. Set goals, begin with the end in mind.
2. Be good at learning
3. Sharpen the saw, take time to sharpen your skills. If your skills are dull, you won't be successful. Take time to learn
4. Once you have learned a new skill or have gained some new knowledge, change your paradigm. A "paradigm shift" may be thought of as a change from one way of thinking to another. Change your perspective from that of a student to that of a teacher. If you really want to learn something well, then teach it. Now that is a paradigm shift.

Speakers
avatar for Michael Nelson

Michael Nelson

Northrop Grumman
Michael is a BS-degreed computer science professional with an MBA and 20 years' experience as senior database administrator with Northrop Grumman. He is experienced in managing object relational database (Oracle) including installing configuring, maintaining, and troubleshooting... Read More →



Thursday March 22, 2018 11:15am - 12:15pm
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

12:15pm

Lunch
Sponsored by ViON

Thursday March 22, 2018 12:15pm - 1:30pm
*Meal Room, 7th Floor - Child Hall 1655 East Campus Center Drive, Salt Lake City, Utah 84112

12:15pm

Women In Technology Lunch
Please join us for UTOUG's Women in Technology event on Thursday, March 22, 2018, in 5160A/B. Enjoy lunch while you have roundtable discussions with some of the most respected women in the industry.


Thursday March 22, 2018 12:15pm - 1:30pm
WIT Lunch, 5160 A/B, 5th Floor 1655 E Campus Center Drive

1:30pm

APEX Panel
Moderator:
Glen Plaizier, Great Western Insurance

Panelists:
Karen Cannell, TH Technology, Oracle ACE Associate
Jeff Eberhard, Insum Solutions
Scott Spendolini, Summer Technologies, Oracle ACE Director



Speakers
GP

Glen Plaizier

Great Western Insurance
Glen Plaizier was introduced to APEX in 2004, quickly became a fan, and has been creating web applications with APEX since then. He has managed a team that created and supported more than 60 APEX applications. Glen enjoys the ability to create quick wins and lasting solutions usi... Read More →


Thursday March 22, 2018 1:30pm - 2:45pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:30pm

BI/Data Panel
Moderator:
Susan Schaefer, University of Utah

Panelists:
John Liette, MindStream Analytics
Daniel Liu, Oracle Corporation
Michelle Kolbe, Red Pill Analytics, Oracle ACE
Jeff Carver,  The Church of Jesus Christ of Latter-day Saints

Speakers
avatar for Susan Schaefer

Susan Schaefer

University of Utah
Susan Schaefer is a data warehouse analyst with the University of Utah. She has been at the U for four years. She acts as a liaison for her department, audget and analysis, and the university's BI team. She spends most of her days in SQL Developer, checking, organizing, and analy... Read More →


Thursday March 22, 2018 1:30pm - 2:45pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:30pm

DBA Panel
Moderator:
Tim Gorman, Delphix, Oracle ACE Director

Panelists:
Maria Colgan, Oracle Corporation
Jim Czuprynski, ViON Corporation, Oracle ACE Director
Robert Lockard,  Oraclewizard, Oracle ACE Director
Daniel Morgan, Meta7, Oracle ACE Alumni




Speakers
avatar for Tim Gorman

Tim Gorman

Sr Technical Manager, Delphix
Tim is a longtime contributor to UTOUG and works in field services for Delphix, assisting customers with data virtualization and masking in order to make data available more securely with less friction. He is co-author of six books on Oracle, a member of the Oak Table network, an... Read More →


Thursday March 22, 2018 1:30pm - 2:45pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

1:30pm

Development Panel
Moderator:
Jeff Smith, Oracle Corporation

Panelists:
Bill Coulam, Church of Jesus Christ of Latter-day Saints
John King, King Training Resources, Oracle ACE Director
Scott Heffron



Speakers
avatar for Jeff Smith

Jeff Smith

Senior Principal Product Manager, Oracle Corporation
Jeff Smith is product manager for Oracle SQL Developer, SQL Developer Data Modeler, SQLcl, and REST Data Services. Jeff blogs at https://www.thatjeffsmith.com and tweets as @thatjeffsmith, and has worked with Oracle Database since 7.3.


Thursday March 22, 2018 1:30pm - 2:45pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Going to the Grid: Tabular Forms Edition
Looking for advice on upgrading your APEX tabular forms to editable interactive grids? This is your stop. This session examines the functionality, structure and JavaScript APIs of Interactive Grids with a heavy focus on editable features and essential upgrade tactics. The presentation will:
  • Compare editable interactive grid features with equivalent (and/or lacking) features in legacy and custom tabular forms. 
  • Review strategies for typical upgrade scenarios. 
  • Demonstrate how to implement common requirements—checklists, cascading select lists, interactions between columns, navigation between fields, dynamic actions—to see what can be achieved declaratively and where customizations via dynamic actions and/or the Interactive Grid APIs are required.
  • Recommend strategy for and demonstrate how to achieve simple, complex and multi-row validations, client and server-side.
  • Explain and show JavaScript methods to access/manipulate data and adjust the grid menus to meet typical tabular form (now Editable Grid) business requirements.
This session is essential for those who have existing tabular forms, plain or highly customized (with PL/SQL and/or JavaScript), and need advice on if, when, and how to replicate that tabular form functionality in an editable interactive grid.

Speakers
avatar for Karen Cannell

Karen Cannell

Oracle ACE Associate, TH Technology
Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise implemented legacy and commercial database appli... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
0170, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Accelerating SDLC for EBS Using Data Virtualization
Constraining development and testing is database size. It takes a lot of time, effort, storage, and network to make another copy of a production system. Your DBA and EBS admin may have some things automated, but somewhere there is a spreadsheet with manual steps, and following those steps takes days to get a new EBS environment ready for use. Come learn why data virtualization is the solution to a problem every EBS team knows. Learn how and why data gravity and data friction prevent you from integrating, developing, and testing. Learn how data virtualization overcomes gravity and friction, helping you get EBS fixes to your customers faster.

Speakers
avatar for Tim Gorman

Tim Gorman

Sr Technical Manager, Delphix
Tim is a longtime contributor to UTOUG and works in field services for Delphix, assisting customers with data virtualization and masking in order to make data available more securely with less friction. He is co-author of six books on Oracle, a member of the Oak Table network, an... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Saving Your Database from Alzheimer's: Analytic Performance Improvements From Oracle 12cR2 Database In-Memory (DBIM)
Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries. This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and nonresident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.

Speakers
avatar for Jim Czuprynski

Jim Czuprynski

Oracle ACE Director, ViON Corporation
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after pub... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Upgrade, Migrate, and Consolidate to Oracle Database 12c/18c
This session will provide an overview of how to upgrade, migrate, and consolidate Oracle database from earlier versions to Oracle database 12c/18c. The session will discuss the preparation steps, upgrade/migrate/consolidate strategies, fallback strategies, new features, performance management, patching, etc.

Speakers
DL

Daniel Liu

Oracle Corporation
Daniel Liu is a principal solution architect at Oracle Corporation and co-author of "Oracle Database 10g New Features" by Rampant TechPress. He has 20 years of experience working with both Fortune 500 companies and public sector entities to apply technology to help solve business... Read More →


Thursday March 22, 2018 3:00pm - 4:00pm
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Beacon Tracking on a Budget
Have you ever wanted to track the location of a physical object? Would you like to trigger an action, such as sending a notification or even locking a deadbolt, based on the proximity of that object? The problem is, how can you do this without spending a small fortune?
In this session, Blaine walks through a project that uses multiple inexpensive Raspberry Pi Zero Ws to track a small Bluetooth Low Energy beacon. After a short explanation of BLE beacons, he installs and configures the Pi. Next, he builds a small NodeJS application used to interact with the beacon and sets up alerts with triggering actions. Beacon tracking generates lots of data for analysis, which needs a home, i.e., a database. Using REST APIs, Blaine enables the NodeJS application to both GET configuration data and POST beacon data. With the data safely stored in a cloud database, Blaine finishes up with a demonstration of how to use spatial queries to determine the location of the beacon and display this information in an IDE. All code used in the session is available on GitHub under an open source license. Attendees will come away from this session with the tools to build their own beacon scanning system that won't break the bank.

Speakers
avatar for Blaine Carter

Blaine Carter

Developer Advocate for Open Source, Oracle Corporation
Blaine Carter is the Oracle developer advocate for open source. He applies his exploratory eye and tinkering inclinations to the intersection of open source and Oracle Database. He helps database developers improve their workflow using open source tools and promotes the use of op... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
0160, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

REST APIs for Your Oracle Database with ORDS
This session will begin with an overview on the concepts of REST and how Oracle REST Data Services makes RESTful Services available for Oracle Database. We will then preview an upcoming feature—REST APIs for the database itself.
Powered by Oracle REST Data Services, your Oracle Database can now be managed and monitored via a REST API. No code to write, just enable it. Secure, check. Documented with examples, expected inputs and outputs, check. Your favorite features covered, check (shutdown a db, get a list of sessions, create a user, make calls to Data Guard . . . ). The product manager will discuss strategy, features, how it works, and live demo the existing feature set.

Speakers
avatar for Jeff Smith

Jeff Smith

Senior Principal Product Manager, Oracle Corporation
Jeff Smith is product manager for Oracle SQL Developer, SQL Developer Data Modeler, SQLcl, and REST Data Services. Jeff blogs at https://www.thatjeffsmith.com and tweets as @thatjeffsmith, and has worked with Oracle Database since 7.3.



Thursday March 22, 2018 3:00pm - 4:00pm
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Software Defined Everything (SDE) for DBAs and Developers
The next generation of enterprise computing is on its way and it is not being driven by the cloud; it is being driven by the need for IT to catch up with processes and procedures pioneered by manufacturing in the 1970s and '80s. What drove the evolution from mainframe to client-server, then from client-server to n-tier with web, application, and database servers, is now driving us to Software Defined Everything.
Join Oracle ACE Director Alumnus Daniel Morgan for a walk through the way just-in-time procurement and lean manufacturing are transforming our profession; How response files have turned into Software Defined Everything and why this transformation is driving computing to the cloud. This session is essential for preparing for the way SDE is transforming our profession.

Speakers
avatar for Daniel Morgan

Daniel Morgan

Oracle ACE Alumni, Meta7
Oracle ACE Director Daniel Morgan has more than 25 years' experience working with Oracle products. Dan wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, is the Morgan behind the MorgansLibrary.org website, and is curr... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
5180, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

3:00pm

Soup to Nuts: Writing DML Triggers
The presentation covers how to write DML triggers for INSERT, UPDATE, MERGE, and DELETE statements. Attendees will learn:
  • The basics of writing triggers. 
  • How to write triggers that stop transactions to prevent statement execution. 
  • How to write triggers with autonomous procedures that record user activity. 
Use these techniques to discover users trying to perform unauthorized tasks, or monitor the frequency and types of changes to key data in your business applications.

Speakers
MM

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho
Michael McLaughlin, Oracle ACE, is a professor at BYU-Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g... Read More →



Thursday March 22, 2018 3:00pm - 4:00pm
1170, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112