Next webinars
A series of 3 low price webinars for developers who want to
take the best out of MySQL!
Each of these webinars is 2 hours long and the cost of each is 50 GBP.
They will happen every 2nd Tuesday of the month.
Practical Query Optimisation for MySQL
[paid webinar]
14th July – 3pm London time
This webinar is a practical introduction to query optimisation. It will give you some simple rules to remember to write fast queries, as well as an easy method to understand your queries problems. This is done by teaching how indexes are implemented in MySQL, and giving you intuitive but powerful analogies with the real world.
At the end of this webinar you will have all it needs to optimise the majority of queries out there.
Schedule
- Understanding how indexes are implemented
- Primary key vs. secondary index
- Multi-columns indexes
- The
EXPLAINcommand - SQL operators and index usage
- Functions and indexes
- Logical operators and indexes
- Ordering and grouping: avoid materialisation
JOINtypes, tables order, joining by index- Final tips for performant applications
Duration: 2 hours, including a 5 minutes pause
When: 14th July
- 3pm London time
- 4pm CEST
- 10am New Yotk time
Price: 50 GBP
Developing Modern Transactional Applications with MySQL
[paid webinar]
11th August – 3pm London time
Schedule
- Understanding InnoDB
- Understanding transactions
- Commit, rollback and savepoints
- Isolation levels
- Transactions performance
- Dealing with duplicate rows
- Mass inserts
- Multi-table updates and deletes
- Temporary tables
Duration: 2 hours, including a 5 minutes pause
When: 14th July
- 3pm London time
- 4pm CEST
- 10am New Yotk time
Price: 50 GBP
Advanced MySQL Features for Developers
[paid webinar]
8th September – 3pm London time
Schedule
- JSON type and functions
- Simplifying database structure with JSON arrays
- Generated columns and indexes
- Default values
- Integrity checks
- All ways to insert rows
- Triggers for data validation and keeping history
- Special functions
- Debugging and analysing queries in your development machine
Duration: 2 hours, including a 5 minutes pause
When: 14th July
- 3pm London time
- 4pm CEST
- 10am New Yotk time
Price: 50 GBP
To be notified about next webinars, you can
subscribe Federico-Razzoli.com UPDATEs newsletter
or join open_source_databases Telegram channel.
Past webinars
Webinars are usually recorded and uploaded to YouTube.
- Database Design: most common pitfalls – 22nd June 2020
- MySQL Backups – 27th May 2020
- Webinar: JSON in MySQL and MariaDB databases – 6th April 2020
Old webinars
These recordings are quite old, and not interesting for those who use modern versons of MySQL or MariaDB.
In English
This webinar was organised by Percona when I was working for them.
- 2016 Virtual Columns in MySQL and MariaDB, organised by Percona
In Italian
These are even older, and hardly useful today, but they can still be interesting for historical reasons. Opinions I expressed at the time may have changed, or may be relative to objective facts that changed over time.
The titles were not chosen by me and don’t completely match the topics. The organiser was Ibuildings Italia.