Course Oracle - Advanced Data Analysis Methods in SQL
The course is focused on methods of access to database data, getting familiar with functions for their evaluation, comparison and analysis.
Minimum input knowledge
SQL language basics
Course dates Oracle - Advanced Data Analysis Methods in SQL
Daily courses (2 days): 09:00 - 15:00
Course price: 350.00 / 430.50 EUR
without VAT / incl. VAT
Training syllabus Oracle - Advanced Data Analysis Methods in SQL
Nested Queries
- single-row nested queries in WHERE and HAVING clauses nested queries in the FROM clause (inline views) multi-row nested queries (ALL, ANY, IN, EXIST operator) use of multi-column subqueries correlated subqueries
Advanced Aggregate Queries
- queries with the ROLLUP clause use of the CUBE clause
Analytic Functions
- use of analytic functions functions for determining order (ranking functions) RANK and DENSE_RANK cumulative distribution (CUME_DIST) NTILE function WIDTH_BUCKET function determining values corresponding to a specified percentile (PERCENTILE_CONT,
PERCENTILE_DISC
- cumulative and moving aggregate functions (window functions) cumulative sum moving average LAG and LEAD FIRST_VALUE and LAST_VALUE FIRST and LAST expressions from CASE hierarchical queries
Output knowledge
Course participants will learn to work with advanced methods in PL/SQL in an Oracle database when analyzing data.
Recommended courses after completing Oracle - Advanced Data Analysis Methods in SQL
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Oracle - Advanced Data Analysis Methods in SQL
Average rating