Queries with MySQL
SpiralTrain BV
In the course Queries with MySQL from SpiralTrain participants learn the syntax and use of the query language SQL in the context of a MySQL 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
MySQL Intro The course starts with an introduction of relational databases, the installation of MySQL and available tooling such as the MySQL Workbench. Also discussed are the different storage engines and the available connectors. SQL Standard Next the SQL Standard is discussed. Step by step the different parts of SQL such as Data Definition Language with CREATE TABLE, Data Manipulation Language with INSERT and UPDATE are treated. Data Definition Attention is then paid to the creation and manipulation of database tables with Primary Keys, Auto Increment, Indexes and Constraints on Columns. The relationship between tables with Foreign keys is also treated. And changing the table structure with ALTER TABLE and deleting tables with DROP is on the course program as well. Data Manipulation Next Data Manipulation with INSERT and UPDATE Queries is discussed. The course content also deals with passing parameters to queries by means of Prepared Statements. Select and Grouping Retrieving data with SELECT queries is a central part of the course program. The various clauses of SELECT such as FROM, WHERE, ORDER BY, BETWEEN, LIKE are covered.
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 |