SQL Masterclass with Rob van Wijk

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Do More With SQL, Analytic Functions & SQL Model Clause
This session begins with explaining why and when letting the SQL engine doing more work for you is beneficial. Next up are two of the most powerful new constructs, analytic functions and the SQL model clause. Using a lot of examples with as many recognizable problems as possible, and no regurgitating of the documentation, these constructs will be thoroughly explained. Special attention will be payed to the explain plans and performance aspects of these constructs.

Grouping, Recursive Subquery Factoring and Frequently Occurring Problems
This session will be about grouping, aggregating and the group by extensions, subquery factoring and …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Do More With SQL, Analytic Functions & SQL Model Clause
This session begins with explaining why and when letting the SQL engine doing more work for you is beneficial. Next up are two of the most powerful new constructs, analytic functions and the SQL model clause. Using a lot of examples with as many recognizable problems as possible, and no regurgitating of the documentation, these constructs will be thoroughly explained. Special attention will be payed to the explain plans and performance aspects of these constructs.

Grouping, Recursive Subquery Factoring and Frequently Occurring Problems
This session will be about grouping, aggregating and the group by extensions, subquery factoring and recursive subquery factoring. Again explained by using a lot of examples, with as many recognizable problems as possible. We’ll start with very simple examples and gradually build up the complexity. Again we’ll pay special attention to the performance aspects of these constructs. The seminar ends with showing some of the most occurring SQL challenges, like row generation, splitting comma separated strings, pivoting and string aggregation and how these can be best implemented depending on your Oracle version.

Why should you attend this seminar?

  • To learn about the most interesting newer features of the SQL language
  • To develop more effective and efficient programs by being able to recognize when and where pure SQL solutions are preferred
  • To know why doing more with SQL matters

PLEASE NOTE:
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Audience
Course Topics
Course Objectives
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.