/db-capstone-project

Meta Database Engineer Course Capstone Project. Using Python and SQL to complete data analysis on Little Lemon Restaurant

Primary LanguageJupyter Notebook

db-capstone-project

Meta Database Engineer Course Capstone Project

  • Final project for the Meta Database Engineer course.
  • Practicing my SQL and Python skills!
  • Creating a SQL database and normalised schemea.
  • Adding stored procedures, including transaction management, to the database.
  • Creating some visualisations on Tableau.
  • Using the mysql connector module to write SQL queries as strings assigned to variables in python.