SQL
Projects

I have worked extensively with MSSQL, MySQL, using SQL to perform
simple queries to more complex data analytics, performing data wrangling and exporting clean
dataset in csv format for use in other tools, building simple to complex joins. Using subqueries to
make a complex query much easier to manage. Aggregating data into one or more rows using
aggregate functions, and window functions to analyse data across multiple rows.

Retail dataset Analysis

The aim of this project is to create a database, create and insert data into tables, and analzing the data to give answers to some business questions.

Task:

  • Create database and 5 table. Insert data into the 5 tables.
  • Check for duplicate records in each table.
  • Query the data to get useful insight
  • ...

Danny's Diner Data Analysis

Danny wants to use the data to answer a few simple questions about his customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite.

Task:

  • Create a database and the various tables. Insert data into the tables.
  • Write queries to provide answers to Danny's questions.

CONVERT SQL QUERIES INTO PYTHON CODES

The aim of this project is to write python codes to obtain the same end result as the SQL queries in a sql file. Task:

  • Upload csv files.
  • using these files, translate the SQL statement in a sql file into Python codes
  • Output the result-set as a .csv file

INSERTING DATA INTO MYSQL AND MONGODB SERVERS

In this projects I inserted datasets of different format such as XML, CSV into MySQL and MongoDB servers.