Sii Poland

SII UKRAINE

SII SWEDEN

  • Trainings
  • Career
Join us Contact us
Back

Sii Poland

SII UKRAINE

SII SWEDEN

Back

SQL and PL/SQL optimization

Language Polish, English

  • Level Advanced
  • The number of participants 8-15 people
  • Duration 2 days

Why take this course

Are your SQL queries running too slowly? Want to understand how the Oracle optimizer works and how to write code that makes the best use of available resources? This training will teach you how to analyze query performance, interpret execution plans, and use indexes, statistics, and hints effectively to create optimized SQL code.

What you’ll learn

  • Understand how the Oracle query optimizer works
  • Use available statistics and histograms when analyzing queries
  • Choose and apply the right types of indexes
  • Write optimized SQL queries, functions, and procedures
  • Generate and interpret query execution plans
  • Apply hints to influence query execution paths
  • Analyze tuning history and make optimization decisions
  • Automate processes and handle long-running queries
  • Improve the performance of database applications

Certification & Exam

Upon completing the course, you will receive a personalized certificate confirming your skills in SQL query optimization in the Oracle environment – including working with execution plans, indexes, statistics, and hints. There is no final exam – active participation in the sessions is enough.

Who is this course for

  • Developers writing SQL queries and procedures in Oracle
  • Project team members working with large datasets
  • Professionals responsible for application and database performance
  • Specialists who want to understand the optimizer and SQL tuning
  • Those looking to strengthen their skills in testing and improving SQL code performance

Topics covered

  • 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
Interested in training?
Contact us to get more information

Contact our expert

Your file

Uploaded file:
  • file_icon Created with Sketch.

Acceptable files: doc, docx, pdf. (max 5MB)
Please submit your file in DOC, DOCX or PDF format
The upload size is limited to 5 MB
File is empty
File was not uploaded

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Anna

Public trainings coordinator

Your message was sent successfully

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

Sorry, something went wrong and your message was not delivered

Refresh the page and try again. Contact us, if problem occurs again

We’re sorry, but the selected file appears to be damaged and we can't process it.

Please try uploading a different copy or a new version of the file. Contact us, if problem occurs 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 Agile Business Consortium Limited. All AgilePM® Courses are offered by Sii, an Affiliate of Eraneos Iberia S.L.U., 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 Organization Eraneos Iberia S.L.U. SIAM™ is a registered trademark of EXIN Holding B.V. All prices presented on the website are net prices. 23% VAT should be added.

Get in touch Find training

Änderungen im Gange

Wir aktualisieren unsere deutsche Website. Wenn Sie die Sprache wechseln, wird Ihnen die vorherige Version angezeigt.

Einige Inhalte sind nicht in deutscher Sprache verfügbar.
Sie werden auf die deutsche Homepage weitergeleitet.

Möchten Sie fortsetzen?