Archives: Projects

DPC – Making the most out of MySQL

Conference: Dutch PHP Conference 2018

Location: Amsterdam, NL

Language: English

Feedbackhttps://joind.in/talk/8884c

Abstract

MySQL 5.7 is two years old and adoption is growing. The new JSON Data Type shines away as the most talked feature in this version. But they are by no means the only awesome things this it has to offer. Learn how to manipulate JSON fields and how Generated Columns can help you index data and much more with real life examples.

DPC – OMG MySQL 8.0 is out! are we there yet?

Conference: Dutch PHP Conference 2018

Location: Amsterdam, NL

Language: English

Feedbackhttps://joind.in/talk/2e783

Abstract

Sick and tired of “X technology is only good for starting out; after you do, move to Y”? Good news: you don’t need to move away, you just need to get in further! In this talk, you’ll learn about improvements in the newest version of the most used database in the world. What are Window Functions? How do you use CTEs? How can the new default encoding help me? We’ll also talk about new JSON features and extended UUID support! Be prepared to drink from the firehose of what’s new and awesome about MySQL 8.0.

php[tek] – Making the most out of MySQL

Conference: php[tek] 2018

Location: Atlanta, USA

Language: English

Abstract

MySQL 5.7 is two years old, and adoption is growing. The new JSON data type shines as the most talked feature in this version. But, they are by no means the only awesome thing it has to offer.

Learn how to manipulate JSON fields and how generated columns can help you index data and more. This talk will teach you how to properly do a GROUP BY without being stuck in the new default mode of MySQL 5.7. Changing the default won’t solve your problem. It’s a temporary fix to hide something much more significant: the code that needs to be fixed.

Generated columns are a concept available in databases such as Oracle and MS SQL Sever. MySQL, however, is one of the biggest open source databases to implement it and this is very helpful when using JSON data types.

Knowledge of JSON data type is required for this talk.

Diving into MySQL 5.7: advanced features

Conference: Midwest PHP 2018

Location: Minneapolis, USA

Language: English

Abstract

Since launch, this current version of MySQL have new features such as: JSON Data Type and Generated/Virtual Columns,. If your application is breaking when you upgrade to 5.7, the new GROUP BY default may be the reason, learn here how to properly address that issue and keep your data consistent, how to index JSON data type and when to use generated columns.

SunshinePHP 2017 – Making the most out of MySQL

Conference: Sunshine PHP 2017

Location: Miami, USA

Language: English

Abstract

The new JSON fields are some of the most talking about new features in MySQL 5.7. But they are by no means the only awesome things this version has to offer. MySQL 5.7 is a year old, so this talk won’t be an introduction to this version. We will be digging into 5.7 to see how to make the most of the tools available in it. Want to tackle important practical problem solving for your data, make your query performance analysis more efficient or look at how virtual columns can help you index data? This talk is for you!

Making the most out of MySQL

Conference: LaraconEU 2016

Location: Amsterdam, NL

Abstract

The new JSON fields are some of the most talking about new features in MySQL 5.7. But they are by no means the only awesome things this version has to offer. MySQL 5.7 is about a year old, so this talk won’t be an introduction to this version. We will be digging into 5.7 to see how to make the most of the tools available in it.

Want to tackle important practical problem solving for your data, make your query performance analysis more efficient or look at how virtual columns can help you index data? This talk is for you!

Joindin Reviews: https://joind.in/event/laracon-eu-2016/making-the-most-out-of-mysql