Queries with Oracle SQL

SpiralTrain BV

In the course Queries with Oracle SQL from SpiralTrain participants learn the syntax and use of the query language SQL in the context of an Oracle database.

Price
from €1,999
Level
Not specified
Kind
Training
Subject
Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

SQL Intro After an introduction to relational databases and Oracle, the Oracle installation, environment and tooling, the basic aspects and backgrounds of SQL are discussed. Oracle, like other DBMS systems, has added extra features of its own to standard SQL and these are also discussed in the course. Data Definition and Data Manipulation In the first place the course covers how SQL statements can be created and executed in Oracle. Subsequently the various components of SQL are treated step by step, such as Data Definition Language with CREATE TABLE and Data Manipulation Language with INSERT and UPDATE. SQL Select Queries Next attention is paid to writing SELECT queries. The grouping of data by means of GROUP and HAVING clauses is also on the program of the course. SQL Functions The various functions in SQL are discussed. Among other things, the mathematical, conversion and aggregation functions for calculating sum and average are treated. Attention is also paid to features specific to Oracle. Joins Next the course covers how to combine data from different tables by means of joins. The various types of joins like inner and outer joins are discussed.

Start dates

Start End Place Price
13 January 2027 15 January 2027 Houten €1,999
13 January 2027 15 January 2027 Amsterdam €1,999
13 January 2027 15 January 2027 Rotterdam €1,999
13 January 2027 15 January 2027 Eindhoven €1,999
13 January 2027 15 January 2027 Zwolle €1,999
13 January 2027 15 January 2027 Online €1,999
10 March 2027 12 March 2027 Houten €1,999
10 March 2027 12 March 2027 Amsterdam €1,999
10 March 2027 12 March 2027 Rotterdam €1,999
10 March 2027 12 March 2027 Eindhoven €1,999
10 March 2027 12 March 2027 Zwolle €1,999
10 March 2027 12 March 2027 Online €1,999
12 May 2027 14 May 2027 Houten €1,999
12 May 2027 14 May 2027 Amsterdam €1,999
12 May 2027 14 May 2027 Rotterdam €1,999
12 May 2027 14 May 2027 Eindhoven €1,999
12 May 2027 14 May 2027 Zwolle €1,999
12 May 2027 14 May 2027 Online €1,999
14 July 2027 16 July 2027 Houten €1,999
14 July 2027 16 July 2027 Amsterdam €1,999
14 July 2027 16 July 2027 Rotterdam €1,999
14 July 2027 16 July 2027 Eindhoven €1,999
14 July 2027 16 July 2027 Zwolle €1,999
14 July 2027 16 July 2027 Online €1,999
8 September 2027 10 September 2027 Houten €1,999
8 September 2027 10 September 2027 Amsterdam €1,999
8 September 2027 10 September 2027 Rotterdam €1,999
8 September 2027 10 September 2027 Eindhoven €1,999
8 September 2027 10 September 2027 Zwolle €1,999
8 September 2027 10 September 2027 Online €1,999
10 November 2027 12 November 2027 Houten €1,999
10 November 2027 12 November 2027 Amsterdam €1,999
10 November 2027 12 November 2027 Rotterdam €1,999
10 November 2027 12 November 2027 Eindhoven €1,999
10 November 2027 12 November 2027 Zwolle €1,999
10 November 2027 12 November 2027 Online €1,999