Data Analytics and Video Tutorials
SQL otherwise known as a structured query language is used by programmers to query and return data on a screen.
You have been probably looking at large sets of data for a while, and projects to extract insights from them. If you are given a set of data that is so large you may need something more! This is where Apache Spark comes in! So what does Apache Spark do? It performs the following functions:…
Sometimes in your data analytics project, you will be working with float data types and integers, but the value NaN may also appear, which will give you headaches if you don’t know how to fix the problem at hand. A NaN is defined as “Not a Number” and represents missing values in the data. If…
Read More “ValueError: cannot convert float NaN to integer” »
You are working on a data visualisation project, but in some instances the data may not be in a format that you want in the output. This is is where a calculated field comes in, it allows you define the output in a way you would like to see it. So what are calculated fields…
You maybe working with a lot of data and inserting it into tables, and want to create a date stamp so you can see when the record was created. Below we will take you through the steps of how to complete this in SQL server management studio. In this table we have created a new…
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…
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…
SQL group by is one of the most commonly used statements you will come across and it has many different applications. It is a great way to aggregate data, when you are using one of the following in the select statement: (A) Sum (B)Count (C) Average (D) Max (E) Min There are more that can…
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…
After building your data using a create statement, one of the next steps using SQL is to now get your data in, so it can be managed and updated where necessary. There are many ways to import your data including , one you could use is import a CSV file with an SQL query. Here…