Loading…
View analytic

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

Getting Started [clear filter]
Wednesday, March 21
 

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

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

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

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
 
Thursday, March 22
 

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

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

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