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 |