CTS

Individual training solutions

+48 12 655 17 36  

Oracle

OR 2 Training the SQL and Oracle - advanced functions

Training name: OR 2 Training the SQL and Oracle - advanced functions

Duration (in days): 3 days

Description

The course contains knoledge about advances Oracle functions, creating advances reports with build-in functions.

Objectives

With purpose of the OR2 training - the SQL and Oracle - advanced functions, teaching using advanceds the possibility is the SQL, construction of advanced reports, the application and exploiting the function Oracle.

Audience

SQL using the tongue for the work in the base Oracle.

PreRequisites

Place the acquaintance SQL

Topics

1.Queries
2.Three-values logic
3.CASE statement
4.Joining many tables
5.Set operators
6.Subqueries
7.Hierarchical queries
8.GROUP BY statement with ROLLUP or CUBE
9.TRUNCATE and MERGE statements
10.Multi-insert statements
11.External tables
12.Review of SQL functions
13.Scalar functions
14.Data conversion and formating functions
15.Managing time-zones
16.Regular expressions
17.Managing transactions
18.Transactions isolation levels
19.Queries in distributed databases
20.System catalog views
21.Retrospective operations
22.FLASHBACK TABLE and FLASHBACK QUERY

In case customers from Poland prices can be negotiated

VAT not incl. It concerns only customers from Poland

%}