Oracle SQL language for data analytics
Oracle Database Server
Duration
Start hour
Level
This course is designed to familiarize trainees with the creation of a variety of queries to the data stored in an Oracle database. The training covers choosing the creation of design data from multiple tables, use built-in single-row and group functions, the inclusion of data formatting and sorting. Participants learn to perform set operations and subqueries, as well as hierarchical queries and using multidimensional hierarchical grouping. Particular emphasis is placed on the use of different variants of analytic functions, extending the capabilities of the Select statement by multidimensional operations. Participants also learn how to carry out retrospective queries and advanced search using regular expressions.
After completing the course, participants should be familiar with the principles of organizing data in a relational Oracle database. The participant will have knowledge on how to create different queries to the database, including, inter alia: joining tables, sorting, use built-in functions, set operations, multidimensional grouping, in order to generate reports of varying complexity. Particularly relevant knowledge gained from the training will be issues regarding the application of a wide range of analytic functions allowing the possibility of multidimensional data analysis.
The course is intended for all those who carry out analytical operations, or create reports in Oracle environment. Training is addressed to all who need to analyze data and make business decisions, not necessarily for IT professionals.
The trainees have to know the Windows environment.
3 days, 24 training hours
The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.
Relational data model
SQL queries – data selection
Graphical tools for data selection
Queries
Sorting
Functions in queries
Retrieving data from multiple tables
Methods of joining tables
Types of joins
Set operators
Subqueries
Review of SQL functions
Support for time zones
Hierarchical queries
Multidimensional grouping
Analytic functions
Flashback
