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