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.
April 12, 2021 in SQL 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!
March 22, 2021 in SQL How To Select Data From Databases Using SQL Learn how to get data from a database using the SELECT, WHERE, and LIMIT statements.
February 01, 2021 in SQL 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!