anekar/SQL-Cleaning

Project Information

This project was created for understanding the basic,
cleaning processes in SQL, with some important functions in result of exploring the dataset,
get duplicate values etc, converting variables in other formats etc.

Language

SQL

Setup

To start do the following:

       1. Start Microsoft SQL Server Management Studio
       2. Select Databases
       3. New Database 
       4. Give your new database a name 
       5. Start designing

Environment

Developed with:

SQL Server Management Studio 2018
SQL Server 2019

Sample Code

SELECT DISTINCT(CourseProvider) AS distinct_values
FROM newCleaning

SELECT TotalReviews,
CASE 
WHEN TotalReviews <= 16 THEN 'Not reliable course'
WHEN TotalReviews <= 455 THEN 'Some reliable course'
ELSE 'Very reliable course'
END AS CaseStatement
FROM newCleaning

 SELECT
 DISTINCT X1
 FROM
 Table

Visuals