Understanding the basics of SQL queries and creating procedures as well as functions in Oracle databases with particular emphasis on analytical functions.
- 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.
- 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
- WITH construction
- Built-in functions and procedures.
- Date and time functions
- Analytical functions
- Grouping functions
- Creating own functions and procedures
- Anonymous blocks
- Code optimization
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.