data cleaning in sql

Project: Cleaning Layoff Data During the COVID-19 Pandemic (SQL)

In this project, I cleaned and prepared a raw layoffs dataset using SQL. The dataset included inconsistencies such as duplicate rows, null values, and unstandardized text formats. Key steps included:

Removing duplicate records using ROW_NUMBER() and DELETE.

Standardizing text fields with string functions (TRIM, UPPER, LOWER, REPLACE).

Converting inconsistent date formats into a standard SQL date type.

Creating a clean staging table ready for analysis.

This process ensured data accuracy and reliability, enabling further analysis of layoff trends during the COVID-19 pandemic.