SQL Part 11In the previous blog post, we explore the dataset that we will be using for the JOINS. We also ended with a simple JOIN statement that…Mar 29, 2022Mar 29, 2022
SQL Part 10In the last blog post, I left off using the DISTINCT statement along with aggregation. One thing to keep in mind with using the DISTINCT…Mar 29, 2022Mar 29, 2022
SQL Part 9In this post, we will further examine how a CASE statement can be used to count multiple categories. In our previous post, we took a look…Feb 27, 2022Feb 27, 2022
SQL Part 8In the last part of the previous blog, I introduced the CASE statement which is capable of creating a new column and filling it with a…Feb 27, 2022Feb 27, 2022
SQL Part 7In this blog post, I will be talking about several extremely useful functions that exist in SQL.Feb 7, 2022Feb 7, 2022
SQL Part 5Let us continue with a few more logical operators in this blog post.Jan 24, 2022Jan 24, 2022
SQL Part 4In this blog post, I will go further into some of the logical operators mentioned in the previous post.Jan 16, 2022Jan 16, 2022
SQL PART 3In my previous blog, I went over writing query statements, naming conventions for columns, formatting conventions for query statements, and…Jan 9, 2022Jan 9, 2022
SQL Part 2In a SQL table, each column has a data type as an attribute that specifies the type of data of any object in it. Each column, variable, and…Jan 1, 2022Jan 1, 2022