Administration interfaces and SQL Basics (MDB)
The course begins with an introduction to various administration interfaces that make working with databases easier. Participants will get an overview of popular tools such as phpMyAdmin and MySQL Workbench. Both tools offer user-friendly interfaces for the administration of MySQL databases. In addition, other useful tools such as HeidiSQL and DBeaver are introduced, which also offer helpful functions for the administration and debugging of databases.
The second part of the course focuses on the basics of the SQL language. Participants will learn how to create and manage databases and tables. Basic SQL commands are taught, including querying, filtering, inserting, updating and deleting data. These basic skills are critical to working effectively with relational databases and performing complex data queries.