What is ACID property in a database? For data analytics tasks, do you need to care about ACID properties ?

ACID properties are important in an RDBMS setting where operations are transnational and there are database updates involved as a part of the task. For instance a banking or an e-commerce application where real-time user data is updated typically needs an RDBMS. A data analyst typically handles structured data using query languages such as SQL. However,…

What are the different types of Joins while wrangling data?

Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Returns ALL records from the left table, and the matched records from the right table RIGHT (OUTER) JOIN: Returns ALL records from the right table, and the matched records from the…