Learnit Training
Course MySQL Basic
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Managing a relational database is easier than you think! Give your career a boost and learn how to create your own reports with MySQL.

Yes, I want to know more

Course MySQL Basic

Do you work on a PHP environment with a relational database? Do you want to edit the data in it or even change the entire structure? Do you find it annoying to always be dependent on others for making the right queries for your reporting? The MySQL course gives you insight into the structure and functioning of a relational database. This helps you understand how you can access the data in it. You will learn how to create powerful MySQL queries that allow you to quickly and efficiently retrieve data from the most complex datasets and edit them as necessary.

MySQL is the most widely used program in the world for managing relational databases. It is open source and therefore accessible to everyone. Because MySQL is very focused on speed and convenience, it is particularly suitable for creating dynamic websites and simple Web applications..

Now everything is about information In the business world. Organizations are gathering more and more data, but they often hardly know what they can do with it. After following the course MySQL you will know. You can manage the database and/or create valuable reports, statistics or dashboards. That gives you a huge advantage in the labour market.


During the training, the following topics are covered:

  • Introduction to designing relational databases.
    These are the basics: tables, columns and fields, primary and foreign keys, normalization etc...
  • Introduction to MySQL
    About the genesis and the most important features of MySQL
  • Installing MySQL
    How can you MySQLdownloaden, install and link to your database?
  • Database setup
    How do you convert a functional data model into a MySQL database?
  • Storing or editing data in your database
    About applying Vaneenvoudige INSERT, UPDATE and DELETE statements
  • Making Simple Selections
    About applying single SELECT queries
  • Creating a UNION Query
    How can you reduce the result Vanmeerdere SELECT statements to a single result set?
  • Stored routines and triggers
    A storedroutine is a simple piece of code that you can store in your database to have simple functions run automatically. You'll learn when you can bet storedroutines, how to make them, and how to deal with triggers.
  • Optimization
    How can you make your queries faster, more efficient and krachtigermaken?


You understand how a relational database is assembled. You can create and provision a MySQL database independently. You know the most important statements and how to use them. You understand the principles of query optimization and can apply it. You know what stored routines are and how you can implement them.


This training is ideally suited for administrators who are going to manage or monitor a MySQL database and for anyone who builds or programs a website in a PHP environment.

Prior knowledge

Some prior knowledge of the data modeling is desired, but not necessarily



The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.


Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 3 days 6 sessions of three hours
Price per day, excl. VAT € 375,- € 290,-
Total, incl. VAT € 1361,25 € 1052,70


After completing the training, a LEARNIT certificate will be issued as proof of participation.


We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

Amsterdam Wednesday 29 July 2020, 10:00-17:00

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.


The course MySQL basis has been assessed with an average of 8.3.

"In a short period of time, unfortunately I was unable to attend the second day, I learned very practical applications."

"I thought it was a very good training and I think I learned a lot from it. And I've also had some tips that you can really do something with."

"Fine, short and yet complete basics course."

"I'm very satisfied with the course. Got more than I expected and that's always good."

"Super instructive, step-by-step built and easy to understand for people who don't know about it yet."