meetup

Have you been unable to answer a SQL interview question? Or unsure how to turn business requirements – e.g. “Find the two highest-paid employees in each department” – into SQL queries? This session will show you how to turn these questions into SQL. Chris will take your “business requirements” based on the sample HR schema in this live, interactive SQL coding challenge. He’ll then write SQL to answer them in real-time. Join the fun and learn the process of writing SQL.

Functions in SQL are a useful and popular feature that is often used. However, little attention is often paid to performance aspects. A function call or an expression in a WHERE condition is a challenge for the query optimizer that often leads to unsuitable execution plans and bad response times. For PL/SQL functions called from SQL, the situation is even more complex. If used incorrectly, they can lead to massive performance degradation. In this presentation, I will show different possibilities to support the optimizer in function calls to generate better execution plans. Furthermore, I will explain how PL/SQL functions can

Trust-but-verify is a key security control for many compliance regulations. In this session, you will learn how you can use Unified Auditing in Oracle Database to implement this approach in a smart and practical way while minimizing performance and storage impact on the database. Try hands-on configuring simple unified audit policies with LiveLabs workshop practice in this session. Join this session and become subject matter experts for implementing this key security control in your organizations.