3 DAYS
Training Duration
370 EUR
Net Price
4.80/5
Average Rating
The "Oracle SQL Workshop - Intermediate" training is an intensive educational program that aims to develop participants' skills in the field of advanced use of SQL in the Oracle environment. It is addressed to people who already have a solid SQL foundation and would like to broaden their knowledge with more advanced techniques and tools necessary for effective work with databases.
During the training, participants will gain in-depth knowledge of advanced SQL queries, which will allow them to more complex and precise data extraction from various tables. They will learn how to use the JOIN clause to join data from multiple tables, how to use subqueries for more complex results, and how to analyze and group data using aggregation functions.
An important element of the training is also learn how to write a code in PL/SQL language. Participants will learn to create their own procedures, functions and triggers, which will allow them to automate certain activities and adapt the behavior of the database to individual needs.
In addition, the training focuses on query optimization and database performance. Participants will learn how to analyze query execution plans and optimize their performance through the use of indexes and appropriate indexing strategies.
Participants will also learn advanced techniques for managing users and permissions in the Oracle database. They will be able to create and manage roles and control access to data, ensuring the security and confidentiality of information.
"Oracle SQL Workshop - Intermediate" is conducted by experienced trainers who provide an interactive form of learning. In addition to lectures, participants have the opportunity to practice exercises and solve realistic problems, which will allow them to effectively assimilate the material.
After completing the training, participants will receive a certificate of completion confirming the acquired knowledge and skills in the field of Oracle SQL on an intermediate level. This is a valuable achievement that can help participants in their professional careers, especially in areas related to databases and data analysis.
After completing the training, participants will have comprehensive knowledge and skills in advanced programming in Oracle SQL. They will be ready to work independently with more complex databases, solve difficult problems and create advanced database applications. The training opens the way to career development in the field of databases and SQL programming.
- Create queries based on multiple tables
- different types of joins
- internal joins
- outer joins
- joins in the WHERE clause
- cartesian join
- self-joins
- SQL Set Operators
- types of operators
- using several operators in one query
- Subqueries
- subqueries in the FROM clause
- subqueries in the WHERE clause
- subqueries in the SELECT clause
- correlated subqueries
- Data aggregation
- aggregate functions
- data grouping
- data filtering after aggregation
- Summaries in aggregation
- ROLLUP
- CUBE
- GROUPING SETS
- Instructions from the DML group
- modifying data
- inserting records
- deleting records
- manipulating data based on another table
- Hold Transactions
- Transaction management
- commit
- rollback
- savepoint
- Instructions from the DDL group
- database objects
- creating tables
- modification of tables
- delete tables
- managing other database objects
- MERGE instruction
- DECODE operator
- CASE operator
- EXISTS and NOT EXISTS operators
- Flashback technology for objects
- Flashback Versions Query
- As Of Timestamp
- As Of SCN
Completing the Oracle SQL workshop at the intermediate level brings numerous benefits, such as gaining advanced knowledge and database programming skills, enabling you to effectively work with more complex SQL queries. Participants learn how to use subqueries, aggregate functions, JOIN clause and optimize queries, which translates into more efficient database operations. Programming in PL/SQL allows you to create your own procedures, functions and triggers, automating processes and adapting the operation of the database to individual needs. Acquiring advanced user and permission management skills increases data security and confidentiality. The workshop, conducted by experienced trainers, provides practical exercises that enable effective assimilation of knowledge. After the training, participants will be ready to independently program advanced database applications, which contributes to their professional development and increasing their attractiveness on the IT job market.
This workshop is designed for people who already have a solid foundational knowledge and experience with SQL and databases, but want to develop their skills in this area. It is dedicated to programmers, data analysts, database administrators and other IT professionals who want to deepen their knowledge of advanced techniques and tools used in working with Oracle databases. The workshop focuses on practical aspects, enabling participants to gain specific skills needed to effectively work with advanced SQL queries, create procedures, optimize queries and manage data and users in the Oracle Database.
For this training, each participant receives access to an individual virtual machine in the cloud. It has installed and configured everything needed to carry out the training. The virtual machine will be available throughout the training period.
Online training takes place live with the trainer. Participants join the training using the ZOOM platform. Participants receive information about the required necessary software and organizational information 7 days before the start date of the training.
When a minimum number of people register for a given date, the date is marked as guaranteed.
Even if part of such a group resigns or moves to another date, the guaranteed date once fixed remains the same. We as the organizer bear the possible risk.
Dawid Nguyen
CO-FOUNDER | MANAGING PARTNERManaging Partner in ASPIRIA. Responsible for commercial strategy, development of new sales opportunities and building business relationships.
Przemyslaw Kaczynski
CO-Founder | CEOCEO of ASPIRIA Company. Responsible for implementing organization's development strategy, controlling and supervising day-to-day operations.