Web Analyst SQL Course

This repo will have all the assignments and projects from Advanced MySQL course - Maven analytics

DATASET DOWNLOAD - LINK

Dataset schema

MySQL Workbench Setup - steps :

STEP - 1

Open this 'preparing_workbench_vApril2022.sql' SQL query and run it

After it successfully ran, restart the workbench as we are modifying global settings

STEP - 2

Open this 'create_mavenfuzzyfacotory_vApril2022.sql' SQL query

if you get this below error, click on open and then run it

If you didn't get any error with above two steps, you are done with the setup. Follow below steps, only if you face any errors

move to preference page of workbench

and change the below-mentioned time limits to '6000'

For all business concepts and assignment question, refer the PDF 'Advanced_MySQL_Analysis.pdf'