Skip to content
  • YouTube
  • FaceBook
  • Twitter
  • Instagram

Data Analytics Ireland

Data Analytics and Video Tutorials

  • Home
  • Contact
  • About Us
    • Latest
    • Write for us
    • Learn more information about our website
  • Useful Links
  • Glossary
  • All Categories
  • Faq
  • Livestream
  • Toggle search form
  • What are bitwise operators in Julia? julia
  • how to create an instance of a class class
  • how to create charts in Tkinter Python
  • how to update records in SQL CRUD
  • What does the … operator do in Julia? julia
  • What is a CTE in SQL? SQL
  • how to copy/paste special a range of cells with xlwings Python
  • how do I declare a null value in python? exception handling

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

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

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

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

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

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

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

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

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

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

Select your language!

  • हिंदी
  • Español
  • Português
  • Français
  • Italiano
  • Deutsch
  • How to create a combobox in tkinter Python
  • Deleting table records with SQL SQL
  • how to copy/paste special a range of cells with xlwings Python
  • TypeError: not all arguments converted during string formatting Python
  • how to compare two lists in Python Python Lists
  • how to create charts in Tkinter Python
  • ValueError: cannot convert float NaN to integer Null values
  • Tkinter python tutorial Python

Copyright © 2023 Data Analytics Ireland.

Powered by PressBook Premium theme

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT