Webinars

Federico Razzoli talking at PHP Hampshire meetup

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 Optimization for MySQL, cover slide

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 EXPLAIN command
  • SQL operators and index usage
  • Functions and indexes
  • Logical operators and indexes
  • Ordering and grouping: avoid materialisation
  • JOIN types, 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

Subscribe now


Developing Modern Transactional Applications with MySQL, cover slide

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

Subscribe now


Advanced MySQL Features for Developers, cover slide

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

Subscribe now


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.


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.

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.