Presented at INSYNC 21

Session ID: 101930

Every long-term IT project reaches a point when one or more fundamental concepts that define the whole system are no longer true. If the business is lucky, this may lead to a brand new development project. If not, the current system must be altered to support requirements for which it was never designed. This presentation discusses how to mitigate possible design-time risks using available technologies and concepts from a database perspective, such as repository-based solutions, code generators, abstract models, micro-SOA, etc. The presentation will also cover real-life examples of best practices for handling unexpected architectural shifts based on systems with 10+ years of life span.

Presented at INSYNC 21

Session ID: 101110

These days supporting business means always handling varied and shifting priorities. But, if you expect your Oracle databases to handle these changes and perform consistently at high levels, you need to have a maintenance process. The first part of that is an assessment: How are my databases performing, and are there any problems? It sounds simple, but for most modern complex database environments, a proper assessment requires a variety of tools and a lot of experience interpreting the results.

Presented at INSYNC 21

Session ID: 100470

Moving to the cloud is not easy. It requires effort and skills and, in most cases, downtime. How can you minimize all three requirements and move your database with minimal downtime running just one command from the command-line? We will discuss the benefits and challenges of different migration methods and where the Oracle Zero Downtime Migration tool can save time and effort. The discussion will be based on real migration cases and on-hands experience of moving a large database environment to the new home.

Presented at INSYNC 21

Session ID: 101560

Oracle Database 21c has been released and is the latest innovation release of the Oracle Database.  A number of new security features are included with this release and should be adopted when creating new databases or upgrading existing databases. Learn about the new security features and changes in security for this database release. Key new security features are blockchain table, gradual database password rollover, mandatory case-sensitive passwords, and Unified Auditing enhancements.

Presented at INSYNC 21

Session ID: 101990

This workshop starts with a napkin design of data structures we would like to use for a proof-of-concept. Using Quick SQL you will quickly define the data structures and utilize various table and column directives to better define the tables and also create some dummy data. You will then be creating an application based on the new tables. Lastly, you will be updating some of the generated components to improve the initial app.

Presented at INSYNC 21

Session ID: 101970

In this Hands-on Lab, join us to experience Oracle Machine Learning for Python (OML4Py) on Oracle Autonomous Database. OML4Py supports scalable, in-database data exploration and preparation using native Python syntax, invocation of in-database algorithms for model building and scoring, and embedded execution of user-defined Python functions from Python or REST APIs. OML4Py also includes the AutoML interface for automated algorithms, feature selection, and hyperparameter tuning. In this six-part lab, explore the range of Python-enabled functionality and see how Oracle technology can support your data science projects.

Presented at INSYNC 21

Session ID: 101980

Abstract: Oracle Data Safe now helps secure databases on-premises and in the Oracle cloud. Data Safe helps you identify unnecessary security risks, detect configuration drift, find and monitor your riskiest users, assess the type and amount of sensitive data within your database, and remove risk from non-production databases. In this workshop, you’ll practice the main features in Oracle Data Safe, including Activity Auditing, Security Assessment, User Assessment, Data Discovery, and Data Masking.

Presented at INSYNC 21

Session ID: 100100

Oracle Machine Learning comes free in every Autonomous Database. Oracle Machine Learning Notebooks provide easy to understand, reuse and repurpose ML methodologies that apply OML’s 30+ machine learning algorithms for in-database, parallelized implementations of classification, regression, clustering, anomaly detection, text mining, associations machine learning functions that can be used to tackle a wide variety of data-driven problems and to build “predictive” applications. This session will step through five (5) OML notebooks that can serve as the core of many data science projects:  classification, attribute importance, time-series forecasting, text mining and anomaly detection.

Presented at INSYNC 21

Session ID: 100310

This session will introduce Oracle RAC in the context of Developers attempting to use Oracle Database. The session will cover tips and tricks to ensure that developers can benefit from features like session failover, load balancing with minimal effort.

Presented at INSYNC 21

Session ID: 101290

Nobody complains that the database is too fast.  But speeding up queries is often seen as a 'dark art' and a mysterious process.  You add an index but then things go slower. This workshop explains how indexes and histograms really work, how to use them efficient, and how to really speed up your MySQL queries.