Data Analytics and Video Tutorials
The process of connecting to and retrieving data that is stored on large tables with many rows and columns.
In many of the SQL programming softwatre tools, there will most likely be an option for you to import your data torugh a screen they have provided. In SQL Server Management Studio the below screen is available to pick your file to import, and it quickly guides you through the steps. But what if you…
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 easiest way is to add a where clause…
Building on how to select all records with SQL , you may want to learn how to get specific columns of data from your table. Using SQLite again , we will now look to select two columns from the table below, namely name and iso_code. The purpose of completing this, is to allow the user…
As part of working as a data analyst, in order to retrieve your data you will most likely need to connect into a database, and look at the database records and then start analysing, but how? At the start of any data analytics project you will need to understand the structure of your data and…
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…