Training objectives
During the training, the participant will acquire knowledge of the operation of advanced mechanisms available in the Oracle environment responsible for searching and analyzing data. The participant will master skills in extensions of multidimensional aggregations, cases of the complex use of analytical functions, division of complex queries, regular expressions, data rearrangement and data modeling. The knowledge and skills imparted during the training on the new options and solutions included in Oracle Server 12c, including pattern matching, determining the scope of data presented, as well as new options for joining tables, are particularly important. There is also valuable information on increasing command performance, including the use of materialized views.
Skills
As a result of the training, the participant will:
Audience profile
The course is intended for participants who perform analytical operations or create reports in the Oracle environment. The training is aimed to everyone who needs to perform complex data analysis in databases and make business decisions based on it.
Requirements
Participants are required to have successfully completed the course "SQL Language for Data Analysts in Oracle Environment" or to know the material covered in this course.
Duration:
Detailed training program
Introducing the objectives and scope of the training
Multidimensional clustering
Rollup and Cube
Advanced result analysis
Complex filtering of results
Analytical functions:
The With clause (Subquery Factoring)
New extensions in joining tables
Data rearrangement - Pivot
Querying a specific number of rows
Data modeling (Model clause)
Regular expressions
Functions of regular expressions
Pattern Matching
Views
Query performance
Recapping the material on key operations in SQL
Independent exercise across different areas
Additional questions from participants
A summary of the training
Test
Survey
After the training, it is recommended to attend: