Course objectives

Getting to know database optimization and testing techniques. Using the available tools to optimize SQL queries, procedures, and functions.

Benefits
  • Participants get acquainted with:
    • SQL database terminology
    • optimizer basics and optimization rules
    • use of packages and nested procedures
    • user-defined function and procedure creation in accordance with optimization rules
    • creation and use of data stored in databases used in the optimization process
    • trigger use in code testing
  • Participants gain detailed knowledge, allowing them to:
    • write efficient SQL queries
    • define and use triggers
    • automate processes
    • manage events and complex queries
Training scope
  • Introduction to databases
  • Schemas, Oracle database objects
  • SQL query creation
  • User-defined object creation – tables, views, materialized views
  • Indexes, index selection
  • Index types: usefulness, when to create which index types, advantages and disadvantages
  • Joins
  • Subqueries
  • Hierarchical queries
  • WITH clause
  • Nested functions and procedures
  • Date and time function
  • Analytical functions
  • Aggregate functions
  • User-defined functions and procedures creation
  • Code optimization
  • Test case creation and the use of procedures and functions in automated tests
  • SQL assertions
Audience

People involved in the software development process using Oracle databases, members of project teams, software developers knowing how to create SQL queries and procedures who would like to learn more about the creation of SQL code tests.

The number of participants: 8-15 people

Duration: 3 days

Available language: PL / EN

Available course material: PL / EN

Course form
Presentation, lecture, exercises, discussion.

See the full Training offer

GET OUR OFFER

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 SQL - Basics for data analysts

Duration:
2 days
Become an IT SpecialistTesting solutions

Become a Tester

Duration:
6 days
Become an IT SpecialistTesting solutions

Become an Automation Tester

Duration:
6 days
Testing solutions

Locust (Python) - Performance Test Designing

Duration:
2 days
Testing solutions

Appium – test automation of mobile applications

Duration:
2 days
Programming languagesTesting solutions

Java Programming for Testers

Duration:
4 days
Testing solutions

Cypress (JavaScript) – automation of web application tests

Duration:
2 days
Testing solutions

SoapUI – automation of Web Service tests

Duration:
2 days
Testing solutions

Linux (Ubuntu Server) – basics for testers

Duration:
2 days
Programming languagesTesting solutions

GIT – practical approach to group work

Duration:
2 days
Testing solutions

Basics of automated testing - JAVA, Selenium, Page Object Pattern

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
Databases

SQL and PL/SQL optimization

Duration:
2 days
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

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