This repo contains the information related to database basics, SQL basics and data analysis using sql through a case study.
Pdfs related to sql concepts can be found here. The resources are taken from 365 data science.
Following topics are covered both theoritical and sql code:
π DDL, DML, DCL, TCL
π Relational Schema
π Database creation and queries
π MySQL Constraints
π Joins
π Sub Queries
π Views
π Stored Routines
π Indexes
π Triggers