Oracle and SQL Databases

Why take this course

Do you work with data but want to better understand how SQL queries work and how to create your own procedures? This training will help you master SQL in the Oracle environment from the ground up, explore analytical and grouping functions, understand the importance of indexes, and learn how to write efficient database code.

What you’ll learn

• Write SQL queries in the Oracle environment
• Understand database structures and data types
• Use different types of indexes to optimize queries
• Apply analytical and grouping functions
• Create tables, views, and materialized views
• Develop custom functions and procedures in PL/SQL
• Work with anonymous blocks
• Optimize SQL code and use the WITH clause
• Leverage statistics and histograms to improve query performance
• Automate and streamline data processing tasks

Certification & Exam

Upon completing the course, you will receive a personalized certificate confirming your skills in working with Oracle databases and SQL – including creating queries, indexing data, using analytical functions, and developing procedures. There is no final exam – active participation in the sessions is enough.

Who is this course for

• Professionals working with Oracle databases
• Data analysts creating queries and reports
• Members of project teams working with large datasets
• Specialists looking to learn query optimization and PL/SQL procedures
• Individuals who want to expand their skills in data processing and automation

Topics covered

• Basics of databases
• Schemas, Oracle database objects
• Creating SQL Queries
• Creating your own objects – tables, views, materialized views
• Indexes, index selection
• Index types: usefulness, when to create, what types of index, advantages and disadvantages
• Join
• Subqueries
• WITH construction
• Built-in functions and procedures.
• Date and time functions
• Analytical functions
• Grouping functions
• Creating own functions and procedures
• Anonymous blocks
• Code optimization