Qualogy’s Tech Series with Keith Laker: introduction to solving SQL problems with MATCH_RECOGNIZE

Introduction to solving SQL problems with MATCH_RECOGNIZE

Published on: Category: News

We are hosting a new series of live webinars: Qualogy’s Tech Series. Featuring weekly live webinars from a wide range of tech experts. The presentations can be followed via Zoom and start at 4:00 p.m. CET. On February 2, Keith Laker presents ‘Introduction to solving SQL problems with MATCH_RECOGNIZE’.

Abstract presentation

Oracle Database provides a completely new native SQL syntax that allows you to implement a core set of rules to define patterns in sequences (streams of rows). This presentation will provide a detailed review of the new keywords that make up the new MATCH_RECOGNIZE clause. It will layout a simple four step approach to writing pattern matching queries based around the main key words. A live demonstration will show how easy it is to write and amend MATCH_RECOGNIZE statements.

At the end of this session you should be able to:

  • Understand how to use the MATCH_RECOGNIZE clause
  • Have a good understanding of the main keywords
  • Understand how SQL pattern matching can solve common business and technical problems
  • Compare and contrast existing pre-12c SQL code with MATCH_RECOGNIZE statement

About Keith Laker

Keith is Product Manager for Autonomous Database and Analytic SQL with extensive experience of data warehouse and business intelligence having worked in a variety of roles, including: post sales consultancy, customer support and product management. Worked in a number of locations across Europe and US.

He works with Oracle for almost 20 years. In consulting, support, on-site Premium Support, and now product management. Currently he is part of ST Data Warehouse Product Management team, providing PM support to DW focused sales and Consulting services organization to help ensure the successful and effective delivery of DW solutions.

Connect with Keith via Twitter.

Team Communication
About the author Team Communication

Innovative projects for great customers, inspiring interviews with colleagues and the latest news. Team Communication brings the Qualogy story to life and shares it with (business) relations, IT professionals and job applicants.

More posts by Team Communication