Loading…

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

Development [clear filter]
Wednesday, March 21
 

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



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

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



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

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



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

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



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

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
avatar for Tim Gorman

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 →



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

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

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



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

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



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

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



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

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
avatar for Blaine Carter

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 →



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

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



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

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



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

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



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

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
avatar for Blaine Carter

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 →



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

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
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 MDT
1180, 1st Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112

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



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