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.

Prijs
vanaf € 1.999
Niveau
Niet opgegeven
Soort
Training
Thema
Automatisering en ICT, Opleiden en onderwijs

Meer informatie en aanmelden bij SpiralTrain BV

Beschrijving

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.

Startmomenten

Start Einde Plaats Prijs
13 januari 2027 15 januari 2027 Houten € 1.999
13 januari 2027 15 januari 2027 Amsterdam € 1.999
13 januari 2027 15 januari 2027 Rotterdam € 1.999
13 januari 2027 15 januari 2027 Eindhoven € 1.999
13 januari 2027 15 januari 2027 Zwolle € 1.999
13 januari 2027 15 januari 2027 Online € 1.999
10 maart 2027 12 maart 2027 Houten € 1.999
10 maart 2027 12 maart 2027 Amsterdam € 1.999
10 maart 2027 12 maart 2027 Rotterdam € 1.999
10 maart 2027 12 maart 2027 Eindhoven € 1.999
10 maart 2027 12 maart 2027 Zwolle € 1.999
10 maart 2027 12 maart 2027 Online € 1.999
12 mei 2027 14 mei 2027 Houten € 1.999
12 mei 2027 14 mei 2027 Amsterdam € 1.999
12 mei 2027 14 mei 2027 Rotterdam € 1.999
12 mei 2027 14 mei 2027 Eindhoven € 1.999
12 mei 2027 14 mei 2027 Zwolle € 1.999
12 mei 2027 14 mei 2027 Online € 1.999
14 juli 2027 16 juli 2027 Houten € 1.999
14 juli 2027 16 juli 2027 Amsterdam € 1.999
14 juli 2027 16 juli 2027 Rotterdam € 1.999
14 juli 2027 16 juli 2027 Eindhoven € 1.999
14 juli 2027 16 juli 2027 Zwolle € 1.999
14 juli 2027 16 juli 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