SQL for testers [EN]

Why take this course

Do you want to perform tests better based on data from databases? Do you want to learn tools for optimizing SQL queries, procedures, and functions? This training will give you the knowledge you need to create optimal SQL queries and automate actions. Thanks to this workshop, you will be able to optimize queries, procedures, and functions, and also use them to test code.

What you'll learn

• Concepts related to SQL databases and the principles of the optimizer.
• How to use built-in packages and procedures, and also create your own functions and procedures.
• Gain knowledge that will allow you to create optimal SQL queries and automate actions.
• The meaning and use of triggers, and you will find out how to handle events and time-consuming queries

Certification & Exam

Upon completion of the training, you will receive a certificate of participation, confirming your skills in SQL for testers. There is no final exam—all you need is active participation in the classes.

Who is this course for

This course is intended for all people involved in the process of creating software for Oracle, MS-SQL, PostgreSQL databases – to choose from, including members of project teams. It is also aimed at programmers who want to deepen their knowledge in the field of SQL code testing.

Topics covered

• 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