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
  • How to remove characters from an imported CSV file Python Tutorial
  • how to copy/paste special a range of cells with xlwings Python
  • Python tutorial: Pandas groupby ( Video 1) Python
  • Import a CSV file with an SQL query CSV
  • How to sort a Python Dictionary Python
  • How To Create An Empty Dictionary In Python python dictionaries
  • How to remove unwanted characters Python Data Cleansing
  • ValueError: invalid literal for int() with base 10 Value Error

Tag: join tables

You join tables using a primary key to combine data that is common to both.

How To Join Tables In SQL

Posted on February 20, 2021November 8, 2022 By admin No Comments on How To Join Tables In SQL

When running an sql select query, most likely we may have a need to bring in data from other tables. The reason for this is that tables have a specific purpose for the data they store. One of the most important features of a data architecture is to avoid duplication. This has the impact of…

Read More “How To Join Tables In SQL” »

SQL, SQLite

What is a Primary Key and Foreign Key

Posted on February 14, 2021February 21, 2021 By admin No Comments on What is a Primary Key and Foreign Key

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…

Read More “What is a Primary Key and Foreign Key” »

SQL, SQLite
  • How to group your data in Tableau data visualisation
  • What is Jupyter notebook? Jupyter Notebook
  • how to update records in SQL CRUD
  • How to use zip() function in Python Python
  • how to remove spaces from a string regular expressions
  • How do I fix TypeError: unhashable type: ‘list’ Error? Articles
  • How to use parameters in Python Python
  • How to connect to your data in Tableau data visualisation

Copyright © 2023 Data Analytics Ireland.

Powered by PressBook Premium theme