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.