When I began my self-taught developer journey back in 2016 (I go more in-depth in this RTC interview), little did I know – at that time – learning the tech side of things would be the easy part. Here are 5 hard truths I’ve come to realize, personally, on this never-ending journey…
(more…)Blog
MySQL NULL value transformation with COALESCE() – Medium repost
Being mindful of NULL values is a good practice. NULLs can slip up on you and give you a heck of a time (especially in calculations) if you aren’t careful. In this post, we will see examples of NULL transformation with the MySQL COALESCE() function.
(more…)OpenLampTech issue #16 – Substack Repost
Honestly, if no one ever read the OpenLampTech newsletter, that’s fine because I always do! Hey everyone, here is your dose of PHP/MySQL content to help you learn, grow, and maintain your sanity for the week. Enjoy!
(more…)SQL Antipatterns – OpenLampTech Publication Repost
I’ve been publishing more articles outside of the OpenLampTech newsletter, directly to the Substack page. In this post, I’m sharing a recent post featuring one of my favorite SQL books…
(more…)Quick SQL Snippets in MySQL Workbench
Supercharge your productivity in MySQL Workbench with these ‘click and paste’ SQL code snippets available for any table in a schema. Continue reading and see the ‘Staple Five‘…
(more…)