Practical Oracle SQL Webinar by ACE Director Kim Berg Hansan

ACE Director Kim Berg Hansen is the author of the book "Practical Oracle SQL, Mastering the Full Power of Oracle Database".



Kim Berg Hansen is known to present complicated SQL features in a very accessible way to developers so that they can apply these features in their daily work.

In this webinar, Kim will present several SQL techniques, taken from his new book Practical Oracle SQL, and show you how you can apply them in real life scenarios.

Kim will cover the following topics:
  • Tree Calculations with Recursion (Recursive subquery factoring)
  • Functions Defined Within SQL (Functions in the WITH clause)
  • Answering Top-N Questions (Analytic ranking functions)
  • Rolling Sums to Forecast Reaching Minimums (Analytic window clause, recursive subquery factoring, model clause)
  • Merging Date Ranges (Row pattern matching MATCH_RECOGNIZE)

Comments

Post a Comment

Popular posts from this blog

My Coding Experience with an AI Assistant

Image
  AI is real and it is here. Its implications for knowledge workers will be enormous, including you. There is no escaping AI in our line of work. Therefore, while building the new version of   Gitora PL/SQL Editor , I’ve fully embraced it. The last few months have been the most interesting, rewarding and productive period of my professional life. I’ve practically stopped using Google search and StackOverflow, two websites I’d consider essential to my work just a few months ago. I’ve coded the Gitora PL/SQL debugger virtually without reading a single line of documentation about how to build debuggers in Java or the specifics of how to build a Java debugger for PL/SQL. I am not even sure if there is any documentation available about building a PL/SQL debugger on the Internet. I just talked about these topics with ChatGPT and analyzed, used the code snippets it produced. All CSS and almost all of the run-of-the-mill code I needed to write for the debugger and the Gitora AI A...
Read more

Monitoring Oracle Database with Zabbix

Attend our free webinar and learn how you can use Zabbix, the open source monitoring solution, to monitor your Oracle Database instances? The webinar is presented by Oracle ACE and Certified Master Ronald Rood. About the Webinar: Enterprise IT is moving to the Cloud. With tens, hundreds even thousands of servers in the Cloud, monitoring the uptime, performance and quality of the Cloud infrastructure becomes a challenge that traditional monitoring tools struggle to solve. Enter Zabbix. Zabbix is a low footprint, low impact, open source monitoring tool that provides various notification types and integrates easily with your ticketing system. During the webinar, we'll cover the following topics: Installation and configuration of Zabbix in the Cloud Monitoring Oracle databases using Zabbix How to use Zabbix templates to increase the quality and efficiency of your monitoring setup How to setup Zabbix for large and remote networks How to trigger events i...
Read more

Success Story: Version Control for PL/SQL

Image
It’s been a little over three months since we released Gitora 2.0 and the first success stories have started to emerge. Here is one of them: Rhenus Logistics, the leading logistics company from Germany uses Gitora to manage their Oracle Database. Problem Rhenus IT uses both Java and PL/SQL to serve their users and customers. They have a team of about 10 PL/SQL developers.  The team manages more than 20,000 database packages, views, functions, procedures, object types and triggers spread over 30+ database schemas. Rhenus IT wanted to move to a continuous delivery environment in which they can be more agile and deliver solutions to the business faster.  Managing the PL/SQL code was the hardest piece of the puzzle. Solution After experimenting with other solutions in the market, Rhenus decided to move forward with Gitora. Gitora enabled Rhenus Developers to: Use Git, the prominent open source version control system used by millions of d...
Read more