Data Cleaning – A detailed view for Data Analysts
SQLZealots
by Latheesh NK
1M ago
Definition of Data Cleaning Data cleaning is a process of preparing data for analysis by removing or modifying data that ..read more
Visit website
UnPivot data in Excel using Power Query
SQLZealots
by Latheesh NK
1M ago
Its a very frequent requirement to transform data in your excel sheet to meet some of your requirement or understanding ..read more
Visit website
A glimpse of Dimensional Modelling
SQLZealots
by Latheesh NK
2M ago
Why Data Warehouse? Datawarehouse is important in modern technology world for several reasons as below: Transactional Versus Reporting Transactional Database ..read more
Visit website
Data Modelling & Key Concepts
SQLZealots
by Latheesh NK
2M ago
Definition of Data Modelling Data Modelling is a process of identifying the business requirements of an organization and modelling the ..read more
Visit website
Azure Data Studio
SQLZealots
by Latheesh NK
5M ago
Introduction Azure Data Studio (ADS) is a cross-platform database tool for those who work in On-Premise or Cloud platforms on ..read more
Visit website
ANY, ALL & SOME Operators in SQL Server
SQLZealots
by Latheesh NK
7M ago
ANY is a SQL operator that used to compare a scalar value with a set of single column resultset from ..read more
Visit website
Exception: “Invalid parameter 1 specified for datediff.” in SQL Server
SQLZealots
by Latheesh NK
10M ago
Problem Statement: One of the view creation scripts in our deployment failed continuously with the below exception: Invalid parameter 1 ..read more
Visit website
Retry SQL Code for X times within SQL Script
SQLZealots
by Vigneshwaran A
1y ago
In some genuine cases, we may experience a failure even when there are no issues with SQL Script or SQL ..read more
Visit website
How to identify duplicate lines in a text file using Python
SQLZealots
by Latheesh NK
1y ago
Here is a short program in Python to identify the count of duplicate lines in a text file. Output: If ..read more
Visit website
SQL Behaviour – Assignment of value to Variable
SQLZealots
by Vigneshwaran A
1y ago
We are going to see the SQL Behaviour while assigning value to variable, we thought of writing this post since ..read more
Visit website

Follow SQLZealots on Feedspot

Continue with Google
OR