Course online - SQL the language of access to database Oracle

Quick Facts

Price
293 £
Duration
⏰ 2 days (16 training hours) of practical Terraform training
Training format
Live online course with interactive exercises and real-life business data.
Learning method
- Expert Technical Instruction: Master the theory with concise, expert-led mini-lectures.
- Real-World Application: Immediately practice your new skills with hands-on exercises based on actual workplace examples.
- Job-Ready Skills: This integrated format ensures you leave with practical skills you can use at work the very next day.
Certificate
Official training certificate issued upon course completion.
Registration
Check available dates and register via this form.

The training course SQL - the language of access to database Oracle will allow you to leverage the potential of the Oracle database. As a result of the training, you will learn how to create queries and construct relational databases, as well as understand the principles of data security that will help you take better care of your company's interests!

The course is intended for all who work with software based on Oracle relational database, want to know the mechanisms of its action and learn how to select interesting information from database.

Full program

Training objectives

This course aims to familiarize participants with the construction of relational databases, acquainted with the SQL language, knowledge of advanced search options, become familiar with the architecture of a client-server. Participants learn about the creation of structures for data storage and data insertion and management. In addition, training includes issues regarding the efficiency of operations and data security.

Skills

After completion of the course:

participant should understand on what basis does the Oracle database,
participant should be able to select information and edit the data in the database,
participant will know the basic rules for performance and security,
participant should know the organization and be able to manage data structures in the schemas.

Audience profile

The course is intended for all who work with software based on Oracle relational database, want to know the mechanisms of its action and learn how to select interesting information from database.

Requirements

The trainees have to know the Windows environment.

Duration

2 days, 16 training hours

Training delivery method

The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.

Theoretical and practical knowledge

Relational data model

User schemas
Fundamental data structures
Relationships between the structures

SQL queries – data selection
Graphical tools for data selection
Queries

Keywords
Statement
Aliases for columns and tables

Sorting
Functions in queries

Single-row functions
Group functions
Data types conversion

Retrieving data from multiple tables
Methods of joining tables
Types of joins

equi-join
non-equi-join
outer-join
self-join

Set operators

Union
Intersect
Minus

Subqueries

Noncorrelated
Correlated

Data Manipulation Language (DML)

Insert
Update
Delete
DML operations on the basis of query results

Transactions

Concept of transaction
Commit
Rollback
Savepoint

Data Definition Language (DDL)

Data types
Creation of tables
Creation of tables on the basis of queries
Manage of tables
Concept of keys
Integrity constraints

Concept of view
Sequence and their application
Data indexing

Application
Indexes created manually and automatically
Manage of indexes

Users and manage of schemas
Privileges and roles

Object and system privileges
Manage of privileges
Transfer privileges
Synonyms

Development path

Upcoming training dates & Price

Current training dates are available in the form!

SQL – the language of access to database Oracle

SQL – the language of access to database ORACLE

You will understand on what basis does the Oracle database!

Quick Facts

Full program

Similar trainings

📩 Any questions? Get in touch with us!