Course : Getting Started with MySQL

Practical course - 3d - 21h00 - Ref. MSQ
Price : 2040 CHF E.T.

Getting Started with MySQL






INTER
IN-HOUSE
CUSTOM

In person or remote class
Available in English on request

Ref. MSQ
  3d - 21h00
2040 CHF E.T.







Course schedule

1
Introduction and getting started

  • Versions, overview of features and tools.
  • Resources and documentation.
  • Installation procedure.
  • Post-installation settings and first tests.
  • The mysql command line client tool.
  • The MySQL Query Browser graphical tool.

2
Relational model, designing and creating a database

  • Design elements of a database schema
  • Integrity constraints.
  • MySQL data types (digital, chains, dates, specific types, etc.).
  • Integrated MySQL functions.
  • Types of tables (MyISAM, MEMORY, MERGE, InnoDB, etc.).
  • Creating databases and tables.
  • The INFORMATION_SCHEMA database.
  • Character sets, internationalization.
Hands-on work
Designing and creating a database with MylSAM tables.

3
Using SQL with MySQL

  • Single selections, comparisons, sorts.
  • Multitable selections, different types of joins.
  • Embedded queries, prepared queries.
  • Changes and view management.
Hands-on work
Single selections, Multiple selections, internal and external joins, embedded requests. Data changes and deletions.

4
InnoDB transactional tables

  • Notion of a transaction, isolation levels.
  • Physical structure of tables.
  • Transaction programming (START TRANSACTION, COMMIT, ROLLBACK).
Hands-on work
Implementing transactions

5
Procedural SQL

  • Stored procedures and functions.
  • Defining procedures Triggers.
  • Managing errors.
Hands-on work
Writing stored procedures. Retrieving results using cursors. Creating and using triggers.

6
Connections, access rights, security

  • Privilege levels and verifying rights.
  • Managing users and their privileges.
  • Making stored procedures and views secure.
Hands-on work
Managing privileges and passwords.

7
Introduction to administration

  • Exporting data.
  • Back-ups, the mysqldump command.
  • Overview of MySQL installation.
Hands-on work
Exporting data.


Customer reviews
4 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
CLÉMENT S.
25/03/26
4 / 5

Le formateur s’est bien adapté aux attentes et niveau de chacun et donnait envie de suivre la formation.
CELINE P.
25/03/26
5 / 5

Le contenu a été adapté selon les besoins des stagiaires, ce qui est très appréciable
MOHAMED A.
25/03/26
5 / 5

le contenu est complet et l’animateur est a l’écoute.



Publication date : 08/21/2024


Dates and locations

Last places available
Guaranteed date, in person or remotely
Guaranteed session
From 3 to 5 June 2026
FR
Remote class
Registration
From 3 to 5 June 2026
EN
Remote class
Registration
From 29 to 31 July 2026
FR
Remote class
Registration
From 29 to 31 July 2026
EN
Remote class
Registration
From 5 to 7 October 2026
FR
Remote class
Registration
From 5 to 7 October 2026
EN
Remote class
Registration
From 2 to 4 December 2026
FR
Remote class
Registration

REMOTE CLASS
2026 : 3 June, 3 June, 29 July, 29 July, 5 Oct., 5 Oct., 2 Dec.