In my previous post, I wrote on how to install MySQL Server and Workbench. In this post, we will take a closer look at MySQL Workbench. It is a great tool for working with databases and tables, as well as making queries.

As one might expect, the first thing to…


Over the past few posts, I have written about the different ways queries can be formed and how SQL can be used to analyze large amounts of data. …


In this post, we will go over the uses of Subqueries.

What is a Subquery?

A subquery is a query made within another larger query. Subqueries can also be called an inner query or a nested query. Since subqueries are nested within a larger query, that larger query is considered an outer query. …


In previous posts, I have described where certain options could be taken to help increase the efficiency of making queries in SQL. In this post, I will go over one the most helpful tools to increase efficiency: Stored Routines.

What are Stored Routines?

Stored Routines are prepared pieces of SQL code that are saved…


In a previous post, I wrote about different ways to filter data in SQL. One of those was using the LIKE operator, which is useful when trying to find patterns within data tables. This method will simply look for the pattern within the specified columns. However, there is another function…


In my previous post, I wrote an introduction on window functions and how useful they can be in analyzing data. In that post, we concentrated mainly on using common aggregate functions as window functions. …


In previous posts, I have written about aggregate functions such as MIN() and MAX() or the GROUP BY statement. The aggregate functions can help in the analysis of different data tables. …


In previous posts, I wrote about different data types and how important it is to use the correct data type for a new column. However, you are not always using a personal database or sometimes the requirements of the database change and you now need the data in a different…


So, I have written a number of posts on using SQL. I have gone over how to create databases and tables, insert/drop data from tables, and how to select/filter data from a table. Now what if we had a large dataset and we wanted certain actions to happen automatically? …


In the previous post, I wrote about how different programming languages can be connected to a SQL database. These connections allow the the use of a programming language, such as python, to write queries to a SQL database. However, what if you wanted to write queries to a dataset already…

Malcolm Katzenbach

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store