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

Web programming with PHP and MySQL

Seminar Web programming with PHP and MySQL PHP, abbreviated to Hypertext Preprocessor, is an open source scripting language that was specially developed for programming dynamic websites on the Internet. The main advantages of PHP are its ease of learning, its fault tolerance and its wide range of functions. Urs Scheufele: Seminar leader and lecturer Web programming with PHP and MySQLDate on request [...]

WordPress for web developers

Seminar WordPress for Developers Basics In this WordPress for Developers course, you will learn how to parameterize and set up WordPress from a developer's perspective. You will discover the most important developer frameworks such as ToolSet, Bootstrap, Elementor and the developer themes such as Astra, GeneratePress or Elementor-Theme, as well as their specific application possibilities. You will create theme files, edit the configuration files, create pages and learn the [...]