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.
- Prijs
- vanaf € 1.999
- Niveau
- Niet opgegeven
- Soort
- Training
- Thema
- Automatisering en ICT, Opleiden en onderwijs
Meer informatie en aanmelden bij SpiralTrain BV
Beschrijving
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.
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 |