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

Het beheren van een relationele database is eenvoudiger dan je denkt! Geef je loopbaan een boost en leer hoe je met MySQL je eigen rapportages kunt maken.

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.

Topics

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?

Results

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.

Target

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

Note


Language

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.

Investment

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

Certificate

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


Online

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.

References

De cursus MySQL basis is beoordeeld met een gemiddelde van 8.3.

"Learnit is a professional organization. The information is conveyed with enthusiasm."

"For me, the great advantage was that the teaching material is very clear. This allows you to follow the training without the stress of what they mean. I have been very positively surprised. I have to say that I already had some knowledge of access."

"Nice, practical training."

"Learned a lot of tricks"

"Fine, short and yet complete basics course."