UTOUG Training Days 2018: Full Schedule

7:30am MDT

Breakfast

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

8:30am MDT

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

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... Read More →

Oracle Database 18c and Autonomous Database pdf

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

9:45am MDT

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

Jeff Eberhard

Sr. APEX Consultant, Insum

Jeff Eberhard has more then 15years 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 →

UTOUG TD 2018 EBERHARD The Red Button APEX Desktop Applications pptx

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

APEX

9:45am MDT

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

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.

Achieving World Class Finance Transformation using EPM UTOUG pdf

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

9:45am MDT

Leveraging Partitioned External Tables: Primer and Practical Examples

Oracle Database 12c is 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

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America

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 public... Read More →

2018 EXTB pptx

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

DBA

9:45am MDT

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

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 currently... Read More →

OracleDatabase12.2utoug18 app cont pdf

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

DBA

9:45am MDT

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

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 serves... Read More →

Enterprise Grade PLSQL pptx

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

Development

9:45am MDT

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

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... Read More →

ObjectTypes 2018 pptx

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

Development

9:45am MDT

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

Susan Schaefer

Data Governance Analyst, University of Utah

Susan Schaefer is a data governance analyst with the University of Utah. She has been at the U for five years. She spends most of her days in SQL Developer, checking, organizing, and analyzing university data.

SQL Developer Reports March 2018 pptx

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

Getting Started

9:45am MDT

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

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, FDM/FDMEE... Read More →

FDMEE Upgrade pptx

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

Hyperion

10:45am MDT

Break With Sponsors - 7th Floor

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

11:15am MDT

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

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 longtime... Read More →

Secure RESTful Services pdf

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

APEX

11:15am MDT

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

Michelle Hardwick

Director, Data Science & Analytics, Salt Lake Community College

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.

Advanced SQL for Analytics pptx

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

11:15am MDT

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

Sean Scott

Managing Principal Consultant, Viscosity North America

Sean Scott is a Managing Principal Consultant with Viscosity North America, working at the intersection of database and systems reliability, database management, and DevOps. He's a subject matter expert on Oracle database high availability, scalability, upgrades, and migrations. Leveraging... Read More →

UTOUG Slack key

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

DBA

11:15am MDT

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

Maria Colgan

Master Product Manager, Oracle Corporation

What to expect from Oracle Database 18c pdf

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

DBA

11:15am MDT

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

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... Read More →

utoug dstober average dates 201803 pptx

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

Development

11:15am MDT

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 12c that help to ensure your PL/SQL does what you expect it to do

Speakers

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 laundering... Read More →

PL%2FSQL Secure Coding In The Cloud V2 pptx

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

Development

11:15am MDT

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

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 architecting... Read More →

Different Types of Tables and Views zip

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

Getting Started

11:15am MDT

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

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.

UTOUG Future of EPM Webinar pdf

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

Hyperion

12:15pm MDT

Lunch

1:15pm MDT

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

Scott Spendolini

Oracle ACE Director, Sumner Technologies

Hacking Oracle APEX pdf

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

APEX

1:15pm MDT

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

Michael Nelson

Collaborate Conference Committe DBA, 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 and... Read More →

2018 Nelson UTOUG Advanced diagnostic repository pdf

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

DBA

1:15pm MDT

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

Maria Colgan

Master Product Manager, Oracle Corporation

Best Practices for Manging statistics pdf

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

DBA

1:15pm MDT

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

Tim Gorman

Oracle ACE Director | Senior Technical Manager, Delphix, USA

Mr Gorman is a senior technical manager at Delphix, who enable data virtualization with data masking to increase the agility of software development, testing, and operations. Tim has co-authored six books on Oracle technology and has performed a technical review on eight other books... Read More →

TGorman UTOUG SecurelyClone 20180321 pptx

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

Development

1:15pm MDT

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

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.

utah tips pptx

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

Development

1:15pm MDT

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

Andrew Hales

Vertical Edge

Hybrid Environments pptx

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

Hyperion

1:15pm MDT

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

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 that... Read More →

UTOUG Light pptx

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

Professional Development

2:15pm MDT

Break With Sponsors - 7th Floor

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

2:45pm MDT

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

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 and/or... Read More →

King APEX51InteractiveGridPlusNewFeaturesUTOUGW pdf

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

APEX

2:45pm MDT

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

Michelle Hardwick

Director, Data Science & Analytics, Salt Lake Community College

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 MDT
0180, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112

2:45pm MDT

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

Sean Stacey

Oracle Outbound Database Product Manager, Oracle America, Inc

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... Read More →

Autonomous DB pdf

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

DBA

2:45pm MDT

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

Maria Colgan

Master Product Manager, Oracle Corporation

Release Model Patching 18c pdf

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

DBA

2:45pm MDT

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

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho

External Tables 2018 ppt

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

Development

2:45pm MDT

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

Alex Ladd

MindStream Analytics

UTOUG Moving to the Cloud pdf

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

Getting Started

2:45pm MDT

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

Karen Cannell

President/Consultant, TH Technology

Karen Cannell is president of TH Technology, a consulting firm providing Oracle technology services, lately focused on Application Express and web technology upgrades. A mechanical engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced... Read More →

Kcannell BeABetter March2018 pdf

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

Professional Development

3:30pm MDT

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

Karen Cannell

President/Consultant, TH Technology

KCannell LoadData Revisited March2018 pdf

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

APEX

3:30pm MDT

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

Alex Ladd

MindStream Analytics

UTOUG A Mobile Strategy for Oracle EPM pdf

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

3:30pm MDT

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

Daniel Morgan

Oracle ACE Alumni, Meta7

OracleSecurityforDBAsDevelopers pdf

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

DBA

3:30pm MDT

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

Craig Shallahamer

President/Founder/DBA, OraPub, Inc.

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 professionals... Read More →

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

DBA

3:30pm MDT

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

Daniel Stober

Intermountain Healthcare

utoug dstober plsql arrays 201803 pptx

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

Development

3:30pm MDT

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

John King

Oracle ACE Director, King Training Resources

King BlockchainWhatIsBlockchainUTOUGW pdf

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

Getting Started

3:30pm MDT

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

Seth Landau

Vice President - Consulting Services, MindStream Analytics

Your Steps to Zen Account Reconciliation UTOUG pdf

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

Hyperion

7:30am MDT

Breakfast

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

8:30am MDT

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

Scott Spendolini

Oracle ACE Director, Sumner Technologies

APEX 18.1 New Features pdf

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

APEX

8:30am MDT

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

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.

1227 upgrade pptx

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

Applications

8:30am MDT

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

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 MDT
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

8:30am MDT

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

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 have voted... Read More →

UTOUG Oracle Privilege History pptx

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

DBA

8:30am MDT

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

John King

Oracle ACE Director, King Training Resources

King CreateRestfulServicesORDSUTOUGW pdf

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

Development

8:30am MDT

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

Blaine Carter

Developer Advocate for Open Source, Oracle America, Inc

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 open... Read More →

IoT to the Database pdf

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

Development

8:30am MDT

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

Sean Scott

Managing Principal Consultant, Viscosity North America

OracleDocker key

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

Getting Started

9:45am MDT

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

Karen Cannell

President/Consultant, TH Technology

2017 Cannell GridEssentials Mar2018 pdf

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

APEX

9:45am MDT

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

Alex Ladd

MindStream Analytics

UTOUG Adding Predictive Analytics to your Forecast FINAL pdf

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

9:45am MDT

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

Sean Stacey

Oracle Outbound Database Product Manager, Oracle America, Inc

Sean Stacey Docker pdf

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

DBA

9:45am MDT

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

Jorge Barba

Accenture, LLP

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 MDT
3170, 3rd Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

DBA

9:45am MDT

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

Craig Shallahamer

President/Founder/DBA, OraPub, Inc.

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

DBA

9:45am MDT

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

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho

PythonOracleUTOUG 2018 ppt

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

Development

9:45am MDT

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

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... Read More →

UTOUG MiaUrman It'sAllAboutTheBots pdf

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

Development

10:45am MDT

Break With Sponsors - 7th Floor

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

11:15am MDT

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

Alex Gorbatovsky

AuraPlayer

UTOUG MiaUrman Microservices pdf

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

Applications

11:15am MDT

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

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.

UTOUG18 Mobile BI Liette pptx

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

11:15am MDT

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

Robert Lockard

Oracle ACE Director, Oraclewizard

HolisticDatabaseSecurityWithCustomerQuestions pptx

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

DBA

11:15am MDT

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

Daniel Liu

Oracle Corporation

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

DBA

11:15am MDT

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

John King

Oracle ACE Director, King Training Resources

King Oracle Database 18c12c NewFeaturesForDevelopersUTOUGW pdf

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

Development

11:15am MDT

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

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 meet... Read More →

UTOUG Presentation 22 March 2018 pptx

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

Getting Started

11:15am MDT

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

Michael Nelson

Collaborate Conference Committe DBA, Northrop Grumman

utoug learn act share2 pdf

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

Professional Development

12:15pm MDT

Lunch

12:15pm MDT

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 MDT
WIT Lunch, 5160 A/B, 5th Floor 1655 E Campus Center Drive

1:30pm MDT

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

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 using... Read More →

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

1:30pm MDT

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

Susan Schaefer

Data Governance Analyst, University of Utah

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

1:30pm MDT

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

Tim Gorman

Oracle ACE Director | Senior Technical Manager, Delphix, USA

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

1:30pm MDT

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

Jeff Smith

Senior Principal Product Manager, Oracle Corporation

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

3:00pm MDT

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

Karen Cannell

President/Consultant, TH Technology

2017 Cannell GridTabularForm Mar2018 pdf

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

APEX

3:00pm MDT

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

Tim Gorman

Oracle ACE Director | Senior Technical Manager, Delphix, USA

TGorman UTOUG AccEBS 20180322 pptx

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

Applications

3:00pm MDT

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

James Czuprynski

Senior Enterprise Data Architect, Viscosity North America

2018 DBIM pptx

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

DBA

3:00pm MDT

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

Daniel Liu

Oracle Corporation

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

DBA

3:00pm MDT

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

Blaine Carter

Developer Advocate for Open Source, Oracle America, Inc

BeaconTracking pdf

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

Development

3:00pm MDT

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

Jeff Smith

Senior Principal Product Manager, Oracle Corporation

utah rest pptx

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

Development

3:00pm MDT

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

Daniel Morgan

Oracle ACE Alumni, Meta7

utoug18 sde pdf

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

Development

3:00pm MDT

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

Michael McLaughlin

Oracle ACE, Brigham Young University-Idaho

DatabaseTriggers 2018 pptx

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

Getting Started