Oracle and SQL Databases

Course objectives

Understanding the basics of SQL queries and creating procedures as well as functions in Oracle databases with particular emphasis on analytical functions.

Benefits

• Workshop participants will learn about:
  • concepts regarding Oracle databases,
  • types and types of data,
  • rules for creating SQL queries,
  • indexes – types, meaning and use,
  • analytical functions and grouping
  • use of built-in functions,
  • creating own functions and procedures.
• Participants will acquire detailed knowledge allowing for:
  • creating optimal SQL queries,
  • the importance and use of statistics, histograms,
  • automation of operations,
  • event handling and time-consuming query handling.

Training scope

• Basics of databases
• Schemas, Oracle database objects
• Creating SQL Queries
• Creating your own objects – tables, views, materialized views
• Indexes, index selection
• Index types: usefulness, when to create, what types of index, advantages and disadvantages
• Join
• Subqueries
• WITH construction
• Built-in functions and procedures.
• Date and time functions
• Analytical functions
• Grouping functions
• Creating own functions and procedures
• Anonymous blocks
• Code optimization

Audience

All individuals involved in the process of creating analyzes using Oracle databases, members of project teams. Analytics wanting to gain knowledge about creating SQL queries and PL/SQL procedures, striving to deepen their expertise towards creating optimal SQL code.