Location:
Łódź
Date:
24.09.2020 - 25.09.2020
Language:
PL
Net price:
PLN 1 550
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.

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.

The number of participants: 8-15 people

Duration: 2 days

Available language: PL/ EN

Available course material: PL / EN

Course form
Presentation, workshop, exercises, discussion.

Download materials

Download

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

Processing...

Download materials

Download

Other dates and locations

Databases

Oracle SQL - Basics for data analysts

Location:
Gdańsk
Language:
PL
Date:
19.11.2020 - 20.11.2020
Net price:
PLN 1 550
Databases

Oracle SQL - Basics for data analysts

Location:
Warszawa
Language:
PL
Date:
19.11.2020 - 20.11.2020
Net price:
PLN 1 550
Databases

Oracle SQL - Basics for data analysts

Location:
Łódź
Language:
PL
Date:
26.11.2020 - 27.11.2020
Net price:
PLN 1 550
Databases

Oracle SQL - Basics for data analysts

Location:
On-line
Language:
EN
Date:
03.12.2020 - 04.12.2020
Net price:
PLN 1 550
Databases

Oracle SQL - Basics for data analysts

Location:
Poznań
Language:
PL
Date:
14.12.2020 - 15.12.2020
Net price:
PLN 1 550

Contact our expert with questions

about any of our trainings

Agnieszka Rzeczkowska

Training Practice Manager

CONTACT OUR EXPERT

Agnieszka Rzeczkowska

or drag and drop your file here

Allowed extensions: DOC, DOCX, PDF (max 5MB)

Thank you for filling out the form

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message couldn’t be delivered

Please refresh the page and try again

Processing...

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of DynamicSystem Development Method Ltd.
All AgilePM® Courses are offered by Sii, an Affiliate of Quint Wellington Redwood, an Accredited Training Organization of The APM Group Ltd.
Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training OrganizationQuint Wellington Redwood.
All prices presented on the website are net prices. 23% VAT should be added.

SUBMIT