Viscosity Presentations

- Virtual education accessible from the comfort of your home

 

Let Viscosity provide you information to help not only you, but your organization, through our deep dive sessions.  Be inspired by knowledge sharing and meet our incredible staff that will help propel you professionally.

Request more info

Database Presentations

 

Featured topics:

Upgrading to Oracle 18c/19c/20c, Data Migration, Sharding, RAC, ChatOps High Availability

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Preparing for Oracle Database 20c

This presentation will focus on preparing for the Oracle 20c database and new features such as AutoML. This presentation will also look at a few 19c/18c new features that should be in use now. We’ll look at how Machine Learning and Autonomous Database will change the role of the future DBA.

Charles Kim

Charles Kim

President and Co-Founder

Oracle ACE Director

Pluggable Databases: Risen From the Dead 

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

Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

The Oracle 19c Best New Features and a few 20c tips

This presentation will look at which 19c new features that should be investigated for use. This presentation will also have a few 20c new features such as AutoML. This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation – & others). Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples, where possible, to show the basic functionality of the new features. Some features are too new to show example, but only explain. We will also look at the autonomous database and Oracle’s focus on the future of security.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

The DBA’s Next Best Job

What’s the next role for the DBA as the autonomous database and Oracle enhancements free up time? This session will cover the DBA role (managing more databases with autonomous database) & the integration of AI and Machine Learning. Technology is advancing at an exponential rate. This session will show what this means to your company and your future job. See major advances being driven, but also those that will be driven by the autonomous future Oracle is driving ahead.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Easy Developer World: Oracle Autonomous Data Warehouse/Autonomous Transaction Processing

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

Charles Kim

Charles Kim

President and Co-Founder

Oracle ACE Director

Top 5 Considerations for Migrating Databases to Oracle Cloud 

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

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

Charles Kim

Charles Kim

President and Co-Founder

Oracle ACE Director

Squeeze the Last Ounce Out Of Your Linux Server

Red Hat Enterprise Linux and Oracle Linux continues to gain market share as a reliable 7/24 mission-critical enterprise server platform. As a DBA in today’s economy, you must possess both the system and database expertise.

Learn all the best practices for Red Hat/Oracle Linux 6 and 7 required to implement Oracle Databases in bare metal servers and in virtualized infrastructures. Leveraging real-life experiences and techniques, learn from the author of the Linux Recipes for DBAs book by APress on how-to:

1. Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments
2. Setup and leverage a local Yum Repository
3. Setup kernel and network parameters, shell limits, and file limits
4. Setup Huge Pages / Disable Transparent Huge Pages
5. Setup Jumbo Frames
6. Configuring device mapper
7. Oracle ASM Filter Driver, ASMLIB, ACFS configuration
8. Setup correct partition alignment

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

Achieving Extreme Scalability, Availability, Tenancy, and Sovereignty with Sharding

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

Charles Kim

Charles Kim

President and Co-Founder

Oracle ACE Director

DBA 3.0: The Next Evolution

The database administration role as we knew it is dead. DBAs who have been around for decades have become irrelevant in this data driven economy. Developers want autonomous management and executive leaders want to cut costs anyway they can. Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever changing dynamic technology driven world. Learn what future skills you need to possess and how you can stay on top of the demand.

Discussions will include how technical enhancements to autonomous databases, cloud innovations and what you must learn to survive, how AI and machine learning can impact the database scene and understanding which technologies you need to learn to adapt.

Development Presentations

 

Featured topics:

APEX, Autonomous Transaction Processing, Oracle Cloud-Free Tier, Containers for Database Pros

Alan Quigley

Alan Quigley

Software Architect

Oracle APEX 20.1 New Features
APEX 20.1 continues the evolution of Oracle’s low-code platform.  This release pays particular attention to developer-side features, such as single-click deployment, automatic application backups, export as ZIP and a fresh theme – Redwood – applied to all parts of the tool.  But end-users will also benefit, particularly with a suite of tweaks to APEX reports and a new menu dubbed “mega menu”.  This session will discuss & demonstrate all of the new features that make up APEX 20.1 and how they apply to both developers as well as end users.
Michael Patton

Michael Patton

Software Developer

Core APEX: A Beginner’s Overview 

New to APEX? Maybe you’ve heard of it, but have not had the chance to see what it can do? Then this session was designed for you. We’ll start off by describing just what APEX is, and then jump into a run down of the core features of the product. Ample time will be spent demonstrating the tool so that participants can get a sense as to just how easy it is to build powerful, scalable, secure, beautiful applications.

Come see how you can get started with the best no-cost feature of the Oracle Database in no time at all!

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

Oracle ChatOps: How to Build a RESTful Service to Interact with Oracle Databases

ChatOps is an automation model connecting users and tools to processes through messaging applications. It leverages the simplicity and familiarity of chat to empower users to interact directly with applications and databases, retrieving information and performing work in real-time. Done right, ChatOps is a safe, agile way to minimize or eliminate tedious, repetitive operational tasks and reduce workloads. Virtually anything can be automated or called via ChatOps through simple commands—from self service password resets, to initiating reporting cycles, to running ad hoc refreshes of development environments—all without granting end users access to a database or application.

Erik Espinoza

Erik Espinoza

Senior Software Architect

APEX Everywhere, data anywhere : New APEX 18c REST Enabled SQL Support 

A backing service is any service the app consumes over the network as part of its normal operation. Examples include data stores, messaging/queueing systems, SMTP services for outbound email, web services, etc. In this session we will review and guide you through the steps of building a solution around the support of REST Enabled SQL sources in the new release of APEX, bringing together data across multiple external sources in a declarative way, the APEX way!

Erik Espinoza

Erik Espinoza

Senior Software Architect

Go Big! Building APEX Applications with Multiple Developers

Many APEX applications are built by one or two developers. But as APEX’s popularity and capabilities increase, it’s being used more and more for larger projects. Unfortunately, APEX’s lack of traditional version control functionality is a turn-off.

Fear not—it’s not only possible to have a large number of developers building a single application, but it’s also efficient. This session will discuss techniques used to solve this problem for a customer. The solution incorporates automated individual development environments via Docker and utilizes the APEXExport utility to pull everything together.

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE

Advanced Docker Recipes: Building Complex Oracle Environments

Oracle provides a number of “vanilla” recipes in the Docker repository but these don’t cover the needs of modern enterprises. This presentation discusses methods for creating images to support Data Guard, OEM, APEX, Sharding, rapid container deployments, Gold images, and transportable datasets. Participants will learn how to develop and customize Dockerfiles and orchestrations and apply them to their needs.

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

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 expirement 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 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.
Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

An Introduction to Docker for Database Administrators 

When I first started using Docker as a platform for delivering databases to development teams, I had no idea what I was doing. The terminology was foreign. Docker’s stateless and immutable nature seemed contradictory for use with a database. The usefulness of databases within Docker containers appeared narrow.

Since then I’ve learned that running databases on Docker elegantly addresses a multitude of situations faced by databases professionals. Docker is my go to solution when I need a database environment for testing or experimentation. It’s surprisingly easy and fast once you’re used to it, and the learning curve need not to be steep.

In this talk, I share the things I wish I’d known about Docker when I first started using it, provide examples of common problems encountered by databases professionals  that are solved by Docker, and walk the audience through the steps for creating and using their first database in a Docker container.

This presentation is intended for database users, who may be new or unfamiliar with Docker who want to increase their understanding of the technology. The material is applicable to SQL and noSQL databases.

Participants will learn:

  • Docker terminology.
  • The structures of containers and how they run and interact with a host.
  • Practical examples of databases on Docker as a superior approach to traditional methods.
  • Steps for installing and creating a database on Docker.
  •  Configuring host and remote applications to interact with a database.
  • Achieving data persistence with containers.
Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

Docker Customizations for Database Administrators

You’ve built some databases in Docker and see the benefits. It’s fast and easy, doesn’t eat up resources, deploying development and test environments is smoother than ever. But you want more! You’re ready to take the next step and move beyond Oracle’s vanilla Docker offerings. 

In this session we’ll address techniques for customizing containers and images. Container customizations can include attaching specific datasets (reference data and gold images) and building network connectivity to allow databases to interact with host applications (SQL* Developer) or other containers (applications and other databases). The most interesting and exciting possibilities for modifying Docker lie in the Dockerfile. If you’re new to Docker, the Dockerfile may look intimidating but it’s the definition for building images. Dockerfiles are the secret sauce for everything from adding tools like vi, strace or losf to a container image to bundling an Oracle Database and APEX installation into a single, preconfigured and ready to run image.

Participants will learn how to build custom images and extend containers to suit a variety of needs.

  • Learn how to embed and separate data from containers.
  • Understand techniques for creating reusable reference images and modular, interchangeable datasets.
  • Discover how to extend and modify container networks to run multi-container, interactive environments. 
  • Learn how to read a Dockerfile and recognize the roles layers and stages play in building images.
  • Discover methods for adding to and customizing operating systems within containers.
  • Review examples for installing and configuring additional software into images.
  • Explore the use of staged builds to minimize image size.
Alan Quigley

Alan Quigley

Software Architect

APEX for the DBA

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

Alan Quigley

Alan Quigley

Software Architect

Processes, Computations, and Validations – Oh My! 

New to APEX and confused what the difference between a process, computation & validation is? You’re not alone! While they may all seem similar, each component has its own specific set of uses – whether its to compute a value, process that value or just ensure that you even have a value in the first place!

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

Initiation to Containers for Database Pros (or: How I Learned to Stop Worrying and Love Docker)

Containers have been embraced by the developer community, but acceptance and adoption by DBAs is more tepid. That’s understandable but why would anyone want a database that’s stateless and immutable?! I started using Docker under duress and had no idea what I was doing. Since then, I’ve learned that

Docker elegantly addresses many situations faced by DBAs, including:
Rapidly provisioning test and development environments
Interacting with Oracle Cloud Infrastructure databases (including ATP and ADW)
Preparing environments for performance testing
Building Gold images
Exploring new technologies and features
Discovering and confirming bugs
Preparing for certification exams

This session is a crash course in Docker covering the terminology, concepts, skills, and practical examples needed to begin using containers to support databases.

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE 

Behind the Magic – Container Internals for the Curious DBA 

What is a container? It’s not a VM but it’s what exactly? How does it work? Is it safe to use? What is it really doing on my system? Why is it so fast and light compared to a VM?

Containers may seem like magic but their functionality is built on fundamental compoents of Unix/Linux operating systems. In fact, it’s not difficult to create your own container with just a few simple commands! This session takes a deeper look into the “magic” behind containers by exploring and demonstrating the commands and techniques that protect and isolate host from container, and limit or allow interaction and resource consumption by containers. Docker (and similar products) provide a friendly interface for running these commands to build and manage containers. Pulling back the curtains builds the understanding DBAs need to make decisions for using containers. It also helps combat the misinformation, misunderstanding, and even controversy that’s grown around container technology.

This session presents:

  • Demonstrations of the fundamental OS commands and facilities used to control container creation, isolation, and exposure.
  • How containers really work at the operating system and how they differ from virtual machines.
  • Considerations for container security and stability as applied to database technology.
  • Discussion of myths and misunderstanding about running databases in containers.

What is a container? It’s not a VM but it’s what exactly? How does it work? Is it safe to use? What is it really doing on my system? Why is it so fast and light compared to a VM?

Containers may seem like magic but their functionality is built on fundamental compoents of Unix/Linux operating systems. In fact, it’s not difficult to create your own container with just a few simple commands! This session takes a deeper look into the “magic” behind containers by exploring and demonstrating the commands and techniques that protect and isolate host from container, and limit or allow interaction and resource consumption by containers. Docker (and similar products) provide a friendly interface for running these commands to build and manage containers. Pulling back the curtains builds the understanding DBAs need to make decisions for using containers. It also helps conbat the misinformation, misunderstanding, and even controversy that’s grown around container technology.

This session presents:

  • Demonstrations of the fundamental OS commands and facilities used to control container creation, isolation, and exposure.
  • How containers really work at the operating system and how they differ from virtual machines.
  • Considerations for container security and stability as applied to databse technology.
  • Discussion of myths and misunderstanding about running databases in containers.

What is a container? It’s not a VM but it’s what exactly? How does it work? Is it safe to use? What is it really doing on my system? Why is it so fast and light compared to a VM?

Containers may seem like magic but their functionality is built on fundamental compoents of Unix/Linux operating systems. In fact, it’s not difficult to create your own container with just a few simple commands! This session takes a deeper look into the “magic” behind containers by exploring and demonstrating the commands and techniques that protect and isolate host from container, and limit or allow interaction and resource consumption by containers. Docker (and similar products) provide a friendly interface for running these commands to build and manage containers. Pulling back the curtains builds the understanding DBAs need to make decisions for using containers. It also helps conbat the misinformation, misunderstanding, and even controversy that’s grown around container technology.

This session presents:

  • Demonstrations of the fundamental OS commands and facilities used to control container creation, isolation, and exposure.
  • How containers really work at the operating system and how they differ from virtual machines.
  • Considerations for container security and stability as applied to databse technology.
  • Discussion of myths and misunderstanding about running databases in containers.

Emerging Technology Presentations

 

Featured topics:

Artificial Intelligence & Machine Learning, Oracle Autonomous Database, Robotics

Jerry Ward

Jerry Ward

Head of Applications, COO

The Digital Farm: Streaming Sensor Data via IOT to the Oracle EPM Cloud for Predictive Modeling

You have a database and you want to talk to it? In this session we’ll show you how to create a conversational chatbot on any data, database, or webservice. We explore the intents, utternces, and database access needed by the machine learning algorithms within chatbots. We will demonstrate the Oracle Digital Assistant chatbot implementation, comparing and contrasting it with Amazon Lex. We will also demonstrate the various channels that conversations can take place: from group chat like slack, to text messaging over SMS, and voice conversations like Alexa.

Jerry Ward

Jerry Ward

Head of Applications, COO

Your Data in 3D?  Create Data Visualization Apps with Virtual Reality

In just a few years, mainstream VR headsets like the Oculus are transforming the way businesses interact with computing. Virtual and Augmented Reality are key leading the way. With new API’s announced from Facebook (Oculus) and other headset vendors, the platform is opening up to business applications. In this session, we show you how to migrate your current 2D business applications (web and mobile) to VR. Once there, we explore enhancements to 3D visualizations. Our sample application for data visualization is built with Oracle Application Express and uses the Oracle JET charting engine.

Jerry Ward

Jerry Ward

Head of Applications, COO

Visualize Traffic Data with FAA data, IoT Cloud, Pizza Box, Raspberry PI, & APEX

Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, the Oracle IoT Cloud,  a Cardboard Pizza Box, a Raspberry PI, and APEX.  Track weather and assets in the field without spending a ton of money?  We connect a raspberry PI to the FAA’s network and utilize a radio based interface to track business aircraft & visualize the data.  The Automatic Dependent Surveillance–Broadcast (ADS-B) is a precise satellite-based system that broadcasts real-time weather & uses GPS technology to determine any aircraft’s location, airspeed, other data, and relays that data to air traffic control, aircraft, and to us because we are listening! We log, store this data with Oracle IoT, then visualize it in DV Desktop and manage via APEX.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Machine Learning 101

Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man’s Mind to further replace man’s most basic tasks. This session will focus on ML 101 and building the future ahead.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Using AI & ML

This presentation will cover Oracle’s ability to leverage AI and ML from within Oracle Advanced Analytics. We’ll look at the latest technology and algorithms that Oracle provides as part of the product.

Rich Niemiec

Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Creating the future with Robotics, Machine Learning & Oracle

Use the latest technology on robotics, machine learning & Oracle chatbots to create the future with AI. We will explore how to leverage and integrate robotics & machine learning into your companies tech plan. We’ll show the state of robotics and how you can test and use this technology to create the future.

Jerry Ward

Jerry Ward

Head of Applications, COO

The Doctor will See You Your Blockchain: A Prescription for a more Efficient and Secure Pharmacy

In this session we discuss a use case for preventing fraud in healthcare. We demonstrate a mobile application using blockchain to securely deliver medical prescriptions from the health care provider to the pharmacy. Forever, doctors and healthcare professionals have been writing patient prescriptions for controlled medication on tiny sheets of paper in notoriously bad handwriting. The scripts are given to patients, faxed to pharmacies, and transmitted to insurance providers. In hospital environments, the scripts are transmitted between departments and third parties to in-house pharmacies.

The current system creates a lot of inefficiency; each health care entity needs to reconcile these scripts with one another. Audits are required. Prescription drug fraud in the form of forgery, computer manipulation, impersonation, and drug or quantity manipulation are a growing health problem. The stakes of prescribing the wrong prescription to a patient could be deadly.

There is another way to do this which could eliminate the need for constant reconciliation, where audit is built in, and controls are in place to detect and prevent fraud in real time. 

We will demonstrate a mobile and web application front end with a blockchain back end. Doctors prescribe drugs to patients via the web application. Patients visit the pharmacy and present their mobile script. Pharmacists scan the script with their mobile application. We will show how scripts cannot be modified, synthesized, or duplicated. Both the doctor and the pharmacist have their own instance of the blockchain, and this reduces the need for reconciliation.

The following technologies are presented: Oracle JET, Oracle Blockchain Cloud Service, IAAS, PAAS, HTML, JavaScript, Apache Cordova, and APEX.

You have a database and you want to talk to it? In this session we’ll show you how to create a conversational chatbot on any data, database, or webservice. We explore the intents, utternces, and database access needed by the machine learning algorithms within chatbots. We will demonstrate the Oracle Digital Assistant chatbot implementation, comparing and contrasting it with Amazon Lex. We will also demonstrate the various channels that conversations can take place: from group chat like slack, to text messaging over SMS, and voice conversations like Alexa.

Viscosity Speakers

Seen virtually and at a conference near you

Charles Kim
Charles Kim

CEO & Co-Founder

Oracle ACE Director & VMware vExpert

Interested in personal demos or have specific questions?
Jerry Ward
Jerry Ward

Head of Applications, COO

Gary Gordhamer
Gary Gordhamer

Managing Principal Consultant

Oracle ACE Associate

Kelsie Brunson
Kelsie Brunson

Director of Business Operations

Rich Niemiec
Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Erik Espinoza
Erik Espinoza

Senior Software Architect

Michael Patton
Michael Patton

Senior Software Architect

Rodolfo Rodriguez
Rodolfo Rodriguez

Software Architect

Sean Scott
Sean Scott

Principal Consultant

Oracle ACE 

We have regularly scheduled webinars every week!
Alan Quigley
Alan Quigley

Software Architect