CTS

Individual training solutions

+48 12 655 17 36  

Oracle

OR 1 Training the SQL and Oracle

Training name: OR 1 Training the SQL and Oracle

Duration (in days): 2 days

Description

The training is aimed at moving the principles of operation of the base closer Oracle, the organization and managing structures in schemes, of principles of efficiency and the safety of the database.

Objectives

The training program contains the basics of Oracle databases and fundamental knowledge about queries, performance, managing users and privileges.

Audience

For everyone made interested in functioning and the structure of relational databases and the tongue SQL

PreRequisites

Everyone who is interested in functioning and the structure of relational databases and the tongue SQL

Topics

1. Relational data model
2.Users schemas
3.The basics of data structure
4.Relations between data structures
5.User applications and quering databases
6.Writing queries
7.SQL Statements
8.Column and table aliases
9.Sorting data
10.Use of functions in queries
11.Retrieving data from many tables
12.Joining tables
13.Types of joins
14.Working with qiery results, set operators
15.Data Manipulation Language
16.Transactions
17.Data Definition Language
18.Views
19.Working with sequences
20.Indexing data
21.Managing users and schemas
22.Privileges and rights
23.Object and system privileges
24.Managing privileges
25.Granting rights
26Synonyms

In case customers from Poland prices can be negotiated

VAT not incl. It concerns only customers from Poland

%}