Skip to content

Latest commit

 

History

History
70 lines (43 loc) · 2.18 KB

README.md

File metadata and controls

70 lines (43 loc) · 2.18 KB

PortfolioProjects with SQL and Python

I inspired and followed this youtube channel of Alex The Data Analyst : https://www.youtube.com/watch?v=qfyynHBFOsM&ab_channel=AlexTheAnalyst

In this portfolio project I will be preparing different analysis.

Projects can be divided different steps. I consider setting 4 projects respectively such as:

Project 1) GOAL is: Using the basic SQL commands and finding answers to the questions that I created, analyzing a dataset with Basic SQL queries.

Functions that I used

  • SELECT
  • COUNT
  • HAVING
  • GROUP BY
  • ORDER BY
  • CASE WHEN
  • WHERE
  • TIME FUNCTIONS

There are roughly 30 SQL queries to manipulate data by using FUNDAMENTAL SQL COMMANDS. You will find different concepts.

Project 2) Data exploration with SQL

Goal is : Data exploration and making some insights about COVID dataset, interpret it and conclude.

Functions that I used

  • AGGREGATE FUNCTIONS
  • CAST
  • CASE WHEN STATEMENTS
  • JOIN
  • DATA DEFINITION COMMNANDS
  • CREATING VIEW

Project 3) Data Cleaning with SQL

Main goal : Making data more useable, much more accurate and easy to understand.

Functions that I used

  • UPDATE
  • CREATE
  • CONVERT
  • JOIN
  • ISNULL
  • STRING FUNCTIONS
  • ROW_NUMBER
  • DROP AND ALTER COMMANDS

Project 4) Correlation with Python in Jupyter notebook

ABOUT DATASETS

  1. For the project 1, the dataset could be reached via link https://www.udemy.com/course/alistirmalarla-sql-ogreniyorum/.

This dataset is about Car features. We will be using BASIC and MODERATE SQL level to manipulate this dataset.

  1. For the project 2, the dataset could be reached via link: https://ourworldindata.org/explorers/coronavirus-data-explorer?zoomToSelection=true&time=2020-03-01..latest&country=USA~GBR~CAN~DEU~ITA~IND&region=World&pickerMetric=location&pickerSort=asc&Interval=7-day+rolling+average&Align+outbreaks=false&Relative+to+Population=true&Metric=Confirmed+cases

It is totaly about COVID and vaccinations number during the COVID. So I did some data explorations to understand what is going on COVID cases and vaccinations for each country.

  1. For the Cleaning Project the Dataset is Nashville Housing Dataset.