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

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

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.

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 Associate

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.

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.

Development Presentations

 

Featured topics:

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

Sean Scott

Sean Scott

Principal Consultant

Oracle ACE Associate

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.

Scott Spendolini

Scott Spendolini

VP of APEX+ Practice

Oracle ACE Director

Oracle APEX 20.1 New Features

 

This session will cover and demonstrate the key new features in Oracle APEX 20.1.

Note: APEX 20.1 is not released; thus the feature list is unknown. I will update this abstract as it gets closer to the release date and a complete feature list is available.

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 Associate

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 Associate

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 Associate

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 enviornment for testing or expiremntation. It’s suprisingly 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 databses professionals  that are solved by Docker, and walk the audience through the steps for creating and using their first databse 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 databses.

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.
  • Acheiving data persistence with containers.
Sean Scott

Sean Scott

Principal Consultant

Oracle ACE Associate

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 envionments 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 databses to interact with host applications (SQL* Developer) or other containers (applications and other databases). The most ineresting and exciting possibilites 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 databae 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 Associate

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 Associate

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:

Artifical Intelligence & Machine Learning, Oracle Autonomous Database, Robotics

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 algorithims 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.

Viscosity Speakers

Our Collaborate20 Speakers

Charles Kim
Charles Kim

CEO & Co-Founder

Oracle ACE Director & VMware vExpert

Interested in personal demos or have specific questions?
Rich Niemiec
Rich Niemiec

Chief Innovation Officer

Oracle ACE Director

Alan Quigley
Alan Quigley

Software Architect

Scott Spendolini
Scott Spendolini

VP of APEX+ Practice

Sean Scott
Sean Scott

Principal Consultant

Oracle ACE Associate