Your host during morning is:
Welcome speech. «TAJOUG Transformation»
speaker: TajOUG Team
Achieve Leaner, Faster Applications with modern SQL
speaker: Connor McDonald
Most developers often avoid direct interaction with SQL, because an ORM can handle that task for them. But SQL has grown enormously from its origins of just simple data access. Modern SQL now has extensions for XML, JSON and advanced data processing. But by delving deeper into these modern SQL facilities, developers can get performance benefits and write a lot less middle-tier code. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by modernizing your knowledge of the SQL language.
Microservices and Databases, a Smart combination
speaker: Piet de Visser
The presentation will show how Data and Databases can be used efficiently in a Microservices-environment. Based on simple use-cases we will show how data-stores and databases can be access and used by microservices, and how avoid the bottlenecks and problems that Microservices seem to have with data and databases.
After the presentation, the attendee will be better able to choose and decide on when and how to use Data efficiently with microservices.
007 Myths about SQL Performance
speaker: Dani Schnider
Many developers don’t pay attention to database performance when implementing new applications. The functionality of the application is important, but the efficiency of the SQL queries is often ignored. The DBA (or the query optimizer) does this job later. If necessary, we can still create some indexes, add hints or adjust some database parameters. And in the Cloud, the Oracle database does everything automatically and autonomously, anyway.
Really? Unfortunately the reality looks different. Many performance problems are caused by a poor software design, unsuitable data models or inefficient SQL statements. Correcting such issues at the end of a project or when the system is already in operation is often very costly and cannot be fixed with just a few configuration parameters.
With SQL live demos (all based on James Bond characters and movies), multiple choice questions and some funny stories that happened to me in my job as an Oracle consultant, I will explain why the impact of performance is important in every phase of a software project. You can check yourself what you know about SQL performance tuning and which myths you still believe in.
Create reusable SQL expressions with SQL macros
speaker: Chris Saxon
A common criticism of SQL is it lacks composability – the ability to define small units you can combine into larger functions. Oracle Database addresses this with the introduction of SQL macros. These return SQL expressions, enabling you to define reusable components.
Using SQL macros you can define SQL templates which you can pass tables, columns, and other values to at runtime. This enables you to build a library of functions to solve common problems, such as finding consecutive rows or the top-N rows per group.
Join this session to learn what SQL macros are, how to define them, and see examples of these in action.
This presentation is for developers and DBAs who want to write better SQL.
Your host during afternoon is:
Comparing Oracle Database Performance in the Cloud
speaker: Julian Dontcheff
The presentation covers 2 main topic: #1 why to use Oracle Autonomous Database in the Cloud and #2 how Oracle Autonomous Database performance compares to other major databases in the Cloud
Fighting Bad PL/SQL & SQL
speaker: Philipp Salvisberg
Improving code is like losing weight. First, you need to know what is good and what is bad. To express your goals and accomplishments, you need metrics and appropriate measurement tools. Then you achieve results as a series of small steps in the right direction. In PL/SQL and SQL, code complexity can be expressed in lines of code, number of statements, as McCabe’s cyclomatic complexity, Halstead volume, or maintainability index. Reducing complexity is one way to improve code quality.
However, in this talk I will focus on PL/SQL & SQL coding guidelines. And I will go through the list of my top ten guidelines. These guidelines must be followed. There is no wiggle room. If you violate any of these guidelines, it means your code has a bug. I’ll show you how to find these bugs in your code using the free db* CODECOP extension for SQL Developer.
After this session, you’ll know how to check your code in SQL Developer and eliminate bad code.
Automate Oracle Using DevOps Tools
speaker: Osama Mustafa
In this session learn how to use Oracle Enterprise Manager Cloud Control 13c, Oracle Application Express 18c, Oracle Exadata Cloud at Customer, and Ansible to automate day-to-day DevOps task. Hear how Energy Transfer was able to streamline DevOps operations to meet growing demand for DBA operational tasks. Learn about Oracle Enterprise Manager Cloud Control monitoring, Oracle Application Express Rest API calls for automation, Oracle Exadata Cloud at Customer and Oracle Cloud Infrastructure command line interface, and Ansible Tower. See how to integrate these tools to create an end-to-end automation solution.
Guardians of the Data – Protecting Oracle Backups from Ransomware and Malicious Intent
speaker: Ron Ekins
As database professionals we are the custodians of our organisations data and the event of any data related issue are usually one of the first Data Heroes on the scene.
As Guardians of the Data we need to constantly review and reduce our exposure to malware and other threats, by adopting a multi-level approach to data protection we can give ourselves the best possible protection.
In this presentation I will discuss the need for a multi-layered approach and share some of the steps we can take to protect our backups from ransomware attacks and malicious intent.
I will share code and examples of the steps need to avoid becoming headline news across the globe.