The “SQL Language for Data Analysts in Oracle Environment - advanced level” course is dedicated to advanced data analysts who want to take their data analysis skills to an even higher level. With the expertise of Comarch Training Center experts, you will learn techniques for extracting information and learn how to perform complex data analysis.
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.
As a result of the training, the participant will:
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.
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.
3 days, 24 training hours
The training is conducted in the form of consecutive training sessions divided into modules. The training module includes theoretical part explaining a given issue, collective and individual exercises solved by the participant, as well as a block of questions and answers.
Introducing the objectives and scope of the training
Rollup and Cube
Advanced result analysis
Complex filtering of results
The With clause (Subquery Factoring)
New extensions in joining tables
Data rearrangement - Pivot
Querying a specific number of rows
Data modeling (Model clause)
Recapping the material on key operations in SQL
Independent exercise across different areas
Additional questions from participants
A summary of the training
He has several years of teaching and training experience, the main area of training specialization is the application and administration of the Oracle database. He also teaches PostreSQL, MySQL and SQL syntax in MS SQL Server databases.
+48 12 687 78 11
+48 608 646 465