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 |