You are here
MySQL and MariaDB developer training
You are already a database application developer or on the way there. Now you would like to learn more about, what MySQL and MariaDB features are available which you can use later to build even better applications, to develop more efficiently applications and shorten your time to market.
Requirements
You are already familiar with the SQL language and have already some experience with MySQL or any other relational SQL database system.
Audience
- Future MySQL application developer
- MySQL and MariaDB database administrators
Contents
- Connecting and MySQL-Tools
JOIN
,UNION
,SUBQUERY
- Transactions
- Locking
- Deadlocks
- Import and export of data
- Views, Materialized Views, Virtual Columns
- MySQL Functions
- Spatial Functions
- Fulltext search
- Prepared Statements
- Variables
- Stored Routines
- Stored Functions
- Triggers
- Events
- Compound Statements and Cursor
- Dynamic SQL
- Exceptions and error handling
- Debugging and Logging
- Profiling
- User Defined Functions
- Schema Tuning
- Query Tuning
- Software Profiling
Duration
3 days
Booking trainings
Trainings for Germany can be booked on-line here and trainings in Switzerland here.