SQL Exercises : Main SQL function used for data science.

Table of Contents

1. Project Purpose
2. Installation
3. Files Descriptions
4. Authors and motivations

What is the project ?

Using examples, this project is just a quick reminder of the main SQL commands you need to know to work effectively in the data professions. The SQL queries are made with DuckDB and written in a Jupyter Notebook. The databases used are fictitious.

Installation

To explore this project download the databases from Git.

All dependencies to install are listed in requirements.txt file.

Files Descriptions

• client.csv : all the information of each client.

• invoice.csv : The detail of the invoices issued to clients.

• item.csv : The items list.

• SQL_Examples_Wine_Sales.ipynb : Jupyter notebook with all the SQL command used.

Authors & Motivations

This project was carried out by Guillaume NONY as part of the ‘data upskilling’ course.