Quest Forum Digital Event 2020

MySQL has made many security improvements and brought many security features that have taken MySQL Database Security to a new level. In this presentation, we will explore MySQL database security and the features that can be used to make your MySQL databases secure and house your most sensitive data with confidence.

Quest Forum Digital Event 2020

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:
-Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments
-Setup and leverage a local Yum Repository
-Setup kernel and network parameters, shell limits, and file limits
-Setup Huge Pages / Disable Transparent Huge Pages
-Setup Jumbo Frames
-Configuring device mapper
-Oracle ASM Filter Driver, ASMLIB, ACFS configuration
-Setup correct partition alignment
-Create databases and ASM diskgroups in silent mode
-Automate installation of patchsets and patches
-Automate ORACLE_HOME cloning
-Create ASM instances in silent mode
-Setup rsync to synchronize file system from source and target servers
-Direct NFS
-Much more

Quest Forum Digital Event 2020

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer.  This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Quest Forum Digital Event 2020

An exciting new feature of Oracle Database 18c and 19c is "Centrally Managed Users" (CMU). This, for the first time, allows for simple and complete database singe sign-on (SSO) and user management integration with Microsoft Active Directory (AD). No additional licenses required!

Previously, Oracle Enterprise User Security (EUS) and Oracle Unified Directory (OUD) were needed as an intermediate component bridging the Oracle Database to Active Directory. And while EUS/OUD is still present and does offer some additional features and benefits, it's no longer required for database-AD user integration and management.

This presentation details the advantages of using CMU over the previous technologies, covers the installation/set-up process, and gives practical examples and use cases for organizations to leverage and benefit from the simplified integration of database user management (authentication and authorization) with AD.

Quest Forum Digital Event 2020

Every database developer knows that PL/SQL functions can be used in SQL queries. However, not many are aware of the measurable cost of SQL-to-PL/SQL context switches. Even fewer can definitively answer how many times their functions will be called (depending upon the complexity of queries or portion of the query where the function is located). This presentation sheds some light on this gray area. The answer is actually very simple: the number of calls is driven by the cardinality of involved tables plus the final execution plan of your query (after all query-transformation steps). Unfortunately, GUESSING what exactly the Cost-Based Optimizer will do to your query is very difficult. This presentation will show you how to KNOW rather than guess and how to use this knowledge to optimize the performance of your database.

Quest Forum Digital Event 2020

How does database security change when you move to the Cloud?  Security does change and how to handle database security needs to change when running databases in the Cloud.  However, you still own your data and are still responsible for making sure that data is secure.  This session will first discuss the security differences for Oracle Databases between IaaS, PaaS, DBaaS, and on-premise. Advantages like enhanced database security features and disadvantages such limited infrastructure visibility are reviewed as they are present in all Cloud deployments.  Seven key components of an effective Cloud database security program are presented including how to effectively manage privileged, protect sensitive data, and monitor database activity.

Quest Forum Digital Event 2020

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.

Quest Forum Digital Event 2020

Join a team of database and systems management experts from Oracle as they discuss the last new features and roadmap for Oracle Enterprise Manager, including options to deploy EM on Oracle Cloud and to manage the new Autonomous Database.  You’ll learn about the latest technology, best practices, and the future of Oracle’s flagship management offering.

Quest Forum Digital Event 2020

Cloud is transforming the enterprise and the career path of the DBA. See how. As cloud gains momentum and migrations of applications and databases become more common, the question is often asked: "Does Cloud mean the end of the DBA?" Cloud is likely not the end of the DBA, but instead an agent in unprecedented change. This webcast will cover how Cloud is bringing about that evolution and what today's DBAs must know to be successful in a Cloud-enabled future.

The future is here, let's take advantage of it today!

Quest Forum Digital Event 2020

MySQL is the largest open-source database in the world. It's a product that resides under the wings of Oracle Corporation and still it survives with it's big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We'll discuss features and we'll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we'll go through the basic concepts of the database and we will set up a replica.