Introduction relational databases
Introduction SQL
Database design
Data model, ER model
Installation of professional working environment, XAMPP, or similar;
PHP MyAdmin admin interface MySQL or MariaDB configuration,
Database connection, manage user rights;
Create, delete, modify databases and tables Add records via PHP MyAdmin interface;
Digression MySQL data types;
Simple SQL queries with conditions;
Online documentation;
Data types in PHP;
Primary keys, foreign keys and indexes
Integrity
Database and table definitions, data types
Creating and managing tables
Editing data (insert, edit, delete)
Data queries (SELECT, WHERE)
Data queries from multiple tables (JOIN)
Subqueries
Cursor
Working with views
Create, edit and delete routines and triggers
Transactions
User/rights management and access protection
SQL syntax of common databases