SQL Assessment

Dilan Croos

Explore the docs »

· Report Bug · Request Feature

Table of Contents

1. About The Assessment
2. Getting Started
   • Prerequisites
   • Installation
3. Usage
4. Contact
5. Acknowledgments

About The Assessment

Star Wars Data Set - SQL - A basic for Data

Subject 📁

Work with SQL as a Data Engineer AND as a Data Analyst !

SQL for Data Engineers 📖

Based on what we have seen during the lesson, you will create a schema based on Star Wars API with several tables and relations (people, films, vehicles) -› https://swapi.dev/. Extract, Transform and Load your data using Python in a sqlite database. Analyse it with (and only with SQL). It means if you need some cleaning, do it during the Transformation step.

SQL for Analysis 💪

Do some SQL analysis

• 1 request with INNER
• 1 request with LEFT
• 1 request with GROUP BY
• 1 request with HAVING
• 1 request with CTE Comment your requests to explain what you wanted to display

To make it great 🔥

The harder the requests will be, the better the mark.

Constraint ☢

Jupyter notebook - Python 3 (only for SQL request) No bug/error/warning Save your work as {sqltp}{name}.pynb

(back to top)

Getting Started

To get a local copy up and running follow these simple steps.

Prerequisites

Python 3.11.6^

• install pip

  $ python3 -m pip install pip

Installation

1. Clone the repo

   $ git clone git@github.com:dilancroos/sql_assignment.git

2. Change to the working directory

   $ cd sql_assignment

• Check Usage to create a virtual environment

(back to top)

Usage

• Create a virtual environment .venv

   $ python -m venv .venv

• Enter the virtual environment .venv

   $ source .venv/bin/activate

(back to top)

Contact

Dilan Croos - antondilan.crooswarnakulasuriya@cri-paris.org.com

Project Link: https://github.com/dilancroos/sql_assignment

(back to top)

Acknowledgments

(back to top)