SQL basics and database development

Introduction to relational databases
Introduction to SQL
Database design
Data model, ER model
Installation of the professional working environment, XAMPP, etc;
PHP MyAdmin Admin interface MySQL or MariaDB configuration,
Database connection, manage user rights;
Creating, deleting and modifying databases and tables Adding data records via the PHP MyAdmin interface;
Excursus MySQL data types;
Simple SQL queries with conditions;
Online documentation;
Data types in PHP;
Primary keys, foreign keys and indices
Integrity
Database and table definitions, data types
Creating and managing tables
Editing data (inserting, editing, deleting)
Data queries (SELECT, WHERE)
Data queries from multiple tables (JOIN)
Subqueries
Cursors
Working with views
Creating, editing and deleting routines and triggers
Transactions
User/rights management and access protection
SQL syntax of common databases