Data Analytics and Video Tutorials
You should use a filter in a query so that only the records you want to see are returned.
In recent posts on SQL here on this website, we have covered off a number of ways to extract your data from wildcards to filters. Here we are going to build on that learning, but bring in a new dimension in the use of case statements. These are very handy to use when you may…
Following on from from our previous posts on SQL, this post will help to explain how to use wildcards in your query. What would you use a wild card in the first place? When a data analyst dealing with a large dataset, it is most likely that they will not know every piece of data….
You have now started to understand your database structure and want to extract data from it. Data analytics projects can have lots of data, you need a way to get to what you need quickly and easily. The question now becomes how would you achieve this? The most easiest way is to add a where…