Oracle SQL – Basics for data analysts

Course objectives

Understanding the basics of SQL queries and creating procedures and functions in Oracle databases, with particular focus on analytic functions.

Benefits

• Workshop participants will learn:
  • terms related to Oracle databases
  • types of data
  • rules for creating SQL queries
  • indexes – types, meaning and use
  • analytic functions and grouping
  • use of built-in functions
  • creating own functions and procedures
• Participants will gain detailed knowledge helping:
  • create optimal SQL queries
  • use built-in packages and functions
  • automate activities
  • handle events and time-consuming queries

Training scope

• Basics of databases
• Schemas, Oracle database objects
• Creating SQL queries
• Joints (join)
• Subqueries
• WITH construction
• Built-in functions and procedures
• Date and time functions
• Hierarchical questions
• Multidimensional grouping
  • Rollup
  • Cube
• Analytic functions
  • partitions
  • windows
  • ranking features
  • window functions
  • reporting functions
  • LAG / LEAD functions
  • FIRST / LAST functions
  • inverse percentile functions
  • functions of the hypothetical ranking
  • WIDTH_BUCKET function
  • statistical functions

Audience

All persons involved in the process of creating analyzes using Oracle databases, members of project teams.

Analysts who want to gain knowledge about creating SQL queries and PL / SQL procedures and wanting to deepen their knowledge towards creating optimal SQL code.