SQL – the language of access to Oracle Training Course Remote/Online

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.

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.

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.

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.

The trainees have to know the Windows environment.

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.

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

Please choose another course from: comarch.com/training or check training:

Oracle SQL language for Data Analysts

Krzysztof Czajkowski

He has several years of teaching and training experience, the main area of training specialization is the application and administration of the Oracle database. He also teaches PostreSQL, MySQL and SQL syntax in MS SQL Server databases.

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!

Full programm

Similar trainings

Our trainers

Consultant: