Course objectives

Understanding optimization rules and SQL queries in Oracle databases. The use of available tools in the optimization of SQL queries, procedures, functions.

Benefits
  • Workshop participants will learn about:
    • concepts regarding Oracle databases,
    • operating principles of the optimizer and optimization rules,
    • using packages and embedded procedures
    • creating own functions and procedures in accordance with optimization principles,
    • creation and use of data stored in databases used in optimization,
    • the meaning of HINT
  • 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 statistics
  • Statistics and histograms – available information
  • Use of statistics by the optimizer – rules for switching off, optimizer operation control
  • Options available at the time of creating the tables – rules of use, benefits
  • The choice of index by the optimizer – forced actions, no reaction
  • Index types: usefulness, when to create, types of indexes, advantages and disadvantages
  • Generating an execution plan (various ways) and reading a plan table. Viewing various query plans / tuning history
  • Selected hints (HINT)
  • Code optimization
Audience

All individuals involved in the process of developing software for Oracle databases, members of project teams.

Programmers who have knowledge about creating SQL queries and procedures and want to deepen their expertise towards creating SQL tests.

The number of participants: 8-15 people

Duration: 2 days

Available language: PL / EN

Available course material: PL / EN

Course form
Presentation, lecture, workshop, discussion.

Download materials

Download

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

Processing...

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...

You might also like

Databases

Oracle and SQL Databases

Duration:
2 days
Databases

MySQL – introduction

Duration:
2 days
Databases

Informatica PowerCenter – Developer basics

Duration:
2 days
Databases

NoSQL – introduction

Duration:
2 days
Databases

Node.js and MongoDB – introduction

Duration:
3 days
DatabasesTesting solutions

SQL for testers

Duration:
3 days
Databases

Oracle SQL - Basics for data analysts

Duration:
2 days
Databases

MS‐SQL – programming

Duration:
2 days
Databases

MS-SQL – queries and indexes plans

Duration:
1 day
Databases

T-SQL – advanced programming

Duration:
1 day

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of Agile Business Consortium Limited.
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

Ta treść jest dostępna tylko w jednej wersji językowej.
Nastąpi przekierowanie do strony głównej.

Czy chcesz opuścić tę stronę?

Einige Inhalte sind nicht in deutscher Sprache verfügbar.
Sie werden dann auf die englische Sprachversion der Website weitergeleitet.

Möchten Sie fortsetzen?