This category entails tips, tricks and tutorials useful for data analytics and data engineering using SQL
One of my friends who is getting into data analytics, recently asked me what is null and why does it, need special treatment in any […]
Lead and lag are the window functions which are used fetch subsequent and previous rows based on over clause expressions provided. In this blog we […]
These are quite useful SQL functions which come handy in many cases while analyzing data. In this blog we will see how those work, we […]
DELETE, TRUNCATE and DROP commands are 3 SQL commands used to clean data; which can be used based on our requirements; Below is small comparative […]
CHARACTER POSITIONING IN SQL: In SQL databases each character in string are having a location index starting from 1 from left side of the string; […]
Approximating and standardizing the numbers is one of the common data cleaning requirement before data analytics. In this blog we will discuss 3 useful functions […]
Copyright © 2024 | WordPress Theme by MH Themes