SQL

This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: What are SQL Aggregate Functions? When working with data in SQL, there are a lot of ways we can filter down the data to bring in exactly what we are after. This could be a range of…

This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: What is a SQL Wildcard Character? Wildcard characters in SQL are a series of specific characters that are used within the LIKE operator as part of a WHERE filter. They are a great way to find specific…

This tutorial is part of the SQL Made Easy series of posts. When first learning about SQL and relational databases in general, one of the terms you are likely to come across when looking at the data is Primary Key. This is a really important concept to learn about early on as it will make…

In this simple guide, we are going to look at SQL Operators, explaining the concepts and use cases of logical, comparison and arithmetic functions that can be performed in SQL. This tutorial is part of the SQL Made Easy series of posts. In this post we will discuss: When would we use operators? When working…

This tutorial is part of the SQL Made Easy series of posts. In this tutorial we will discuss: Sometimes when working with large tables in SQL you will come across columns that contain duplicate values. Most of the time these duplicates aren’t an issue as they aren’t meant to be a unique identifier or primary…