Data Analytics and Video Tutorials
A computer that stores data in tables with rows and columns.
In SQL a lot of the times there will be a need to write subqueries that will extract data that you can analyse. But what if you want to use the data as input to another query that can then be used to give you the result you desire? This is is the power of…
Often you will hear about deleting table records with SQL, but how is this achieved, if you have not done it before? In previous videos on SQL we discussed how to update records in SQL , how to insert data into a table in SQL. You could be faced with the scenario where there is…
There are multiple reasons for wanting to update records in a database table, from data quality to enriching your data for any machine learning projects. One example maybe where you want to add a creation date to a record. In this blog post we will look at how to update database records, and also where…
When working with databases in your data analytics projects, most likely you will deal with more than one table. As a result in certain scenarios there will be a link between the tables This will ensure that you can use data from the two or more tables that can be joined together. But how would…
In Data Analytics, that is a very relevant question, and something I look to implement in most projects, sometimes it is too easy to click the shortcut icon to your spreadsheet application! Here we are looking to bring a little automation into these videos. Building on How to import data from files and Removing characters from…