Skip to content
  • YouTube
  • FaceBook
  • Twitter
  • Instagram

Data Analytics Ireland

Data Analytics and Video Tutorials

  • Home
  • About Us
    • Latest
    • Write for us
    • Learn more information about our website
  • Useful Links
  • Glossary
  • All Categories
  • Faq
  • Livestream
  • Toggle search form
  • What is The Julia Programming Language Julia programming
  • ValueError: pattern contains no capture groups Value Error
  • How to Pass Python Variables to Javascript Javascript
  • How can I filter my data in Tableau? data visualisation
  • What is Assembly Language? Assembly Language
  • TypeError: Array() Argument 1 Must Be A Unicode Character, Not List array
  • What does the … operator do in Julia? julia
  • What is an Algorithm? machine learning

Category: SQL

SQL otherwise known as a structured query language is used by programmers to query and return data on a screen.

What is Apache Spark and what is it used for?

Posted on February 12, 2023March 12, 2023 By admin

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:…

Read More “What is Apache Spark and what is it used for?” »

Apache Spark, Python, SQL

ValueError: cannot convert float NaN to integer

Posted on October 16, 2021December 16, 2021 By admin No Comments on ValueError: cannot convert float NaN to integer

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” »

Null values, SQL, Value Error

How to create a calculated field in Tableau

Posted on June 27, 2021June 27, 2021 By admin No Comments on How to create a calculated field in Tableau

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…

Read More “How to create a calculated field in Tableau” »

data visualisation, SQL, Tableau

How to add a date when a record is created

Posted on May 13, 2021October 31, 2022 By admin No Comments on How to add a date when a record is created

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…

Read More “How to add a date when a record is created” »

SQL

Import a CSV file with an SQL query

Posted on May 13, 2021May 18, 2021 By admin No Comments on Import a CSV file with an SQL query

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…

Read More “Import a CSV file with an SQL query” »

CSV, File Handling, SQL, Working with databases

how to write subqueries in SQL

Posted on April 5, 2021May 6, 2021 By admin No Comments on how to write subqueries in SQL

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…

Read More “how to write subqueries in SQL” »

SQL

How to Group By in a Select Statement

Posted on April 5, 2021May 23, 2021 By admin No Comments on How to Group By in a Select Statement

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…

Read More “How to Group By in a Select Statement” »

SQL

Deleting table records with SQL

Posted on March 21, 2021November 8, 2022 By admin No Comments on Deleting table records with SQL

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…

Read More “Deleting table records with SQL” »

SQL

how to update records in SQL

Posted on March 15, 2021May 23, 2021 By admin No Comments on how to update records in SQL

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…

Read More “how to update records in SQL” »

CRUD, SQL

how to insert data into a table in SQL

Posted on March 9, 2021May 23, 2021 By admin No Comments on how to insert data into a table in SQL

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…

Read More “how to insert data into a table in SQL” »

SQL

Posts navigation

Previous 1 2 3 Next
  • Recursion Definition
  • What is data analytics and why it is important Articles
  • select rows with a certain value using SQL SQL
  • What does the … operator do in Julia? julia
  • How to sort a Python Dictionary Python
  • python constructor self and __init__explained Python
  • How do I fix TypeError: unhashable type: ‘list’ Error? Articles
  • Explain different types of data Normalization. SQL

Copyright © 2023 Data Analytics Ireland.

Powered by PressBook Premium theme