December 26, 2022 in SQL How To Use MySQL’s GROUP_CONCAT To Get Aggregated Lists of Values One of my favorite MySQL functions that I wished more people knew about is GROUP_CONCAT. This lets you create an aggregated list of values in your queries. Read on to learn how to use it. Read more...
April 12, 2021 in SQL | Part of my SQL 101 series How to Insert and Update Data From Databases Using SQL Need to insert some data into your database or update some existing data? Learn how using SQL! Read more...
March 22, 2021 in SQL | Part of my SQL 101 series How To Select Data From Databases Using SQL Learn how to get data from a database using the SELECT, WHERE, and LIMIT statements. Read more...
February 01, 2021 in SQL | Part of my SQL 101 series Learn How Databases and Tables Are Structured Just getting started with SQL? Let's learn a high-level overview of how databases and tables are structured! Read more...