GitHub - sand-it-100/MySQL: here it is

📘 MySQL Learning Journey – 59 Days

🚀 Overview

Documenting a 59-day journey of learning MySQL
Covers fundamentals → advanced queries → optimization → projects
Goal: build strong SQL/database skills for real-world applications

📅 Timeline -DAY1 MySQL Create Table [20 exercises with solution] CONSTRAINTS NOT NULL , CHECK constraint ,ENUM / Values restriction - Question 7 (only Italy, India, China), DEFAULT values ,UNIQUE constraint ,PRIMARY KEY

DATA TYPES INT, VARCHAR, DECIMAL, DATE, etc.

TABLE COPY OPERATIONS CREATE TABLE LIKE, CREATE TABLE AS SELECT

FOREIGN KEYS (Referential Integrity) FOREIGN KEY constraint

Different referential actions: ON DELETE CASCADE ON UPDATE CASCADE ON DELETE SET NULL ON DELETE RESTRICT/NO ACTION ON UPDATE RESTRICT

AUTO INCREMENT AUTO_INCREMENT

ENGINE SPECIFICATION ENGINE=InnoDB

COMPOSITE KEYS Multiple columns as primary/unique key

Day 11–20: Intermediate Queries
Joins (INNER, LEFT, RIGHT, FULL)
Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
GROUP BY and HAVING
Day 21–30: Advanced SQL
Subqueries, nested queries
Views and indexing
Constraints, normalization
Day 31–40: Practical Applications
Import/export CSV data
Schema design for projects
Handling NULLs, defaults
- Day 41–50: Optimization & Administration
Query optimization
Transactions, ACID properties
User management, permissions
Day 51–59: Projects & Wrap-Up
Mini-projects (Library DB, E-commerce DB)
Final review of concepts
Documenting best practices

🛠️ Tools & Setup

MySQL Community Server
MySQL Workbench / CLI
SQL + Python integration
OS: Windows/Linux

Documenting best practices

📂 Repository Structure

notes/ → Daily notes & explanations
exercises/ → Practice queries & solutions
projects/ → Mini-projects built during learning
resources.md → Helpful links, docs, tutorials
README.md → Overview of the journey

🛠️ Tools & Setup

MySQL Community Server
MySQL Workbench / CLI
SQL + Python integration
OS: Windows/Linux

📖 Resources

MySQL Documentation
SQLBolt – Interactive lessons
LeetCode Database Problems – Practice queries

✅ Goals

Write efficient SQL queries
Understand database design principles
Apply MySQL in real-world projects
Build portfolio projects

Name		Name	Last commit message	Last commit date
Latest commit History 37 Commits
DAY -1		DAY -1
Day -2 insert value from tab1 into tab1.sql		Day -2 insert value from tab1 into tab1.sql
Day2- AS SELECT.sql		Day2- AS SELECT.sql
Day3- NOT BETWEEN 15000 AND 23000 --- AND DEP_ID IN (30,70).sql		Day3- NOT BETWEEN 15000 AND 23000 --- AND DEP_ID IN (30,70).sql
Day3- NOT IN or IN.sql		Day3- NOT IN or IN.sql
Day3- Restricting & Sorting.sql		Day3- Restricting & Sorting.sql
Day3- WHERE LAST_NAME LIKE '__n%'.sql		Day3- WHERE LAST_NAME LIKE '__n%'.sql
Day3- WHERE last_name LIKE '______' (for chr =6 ).sql		Day3- WHERE last_name LIKE '______' (for chr =6 ).sql
Day3- using IN (90,60).sql		Day3- using IN (90,60).sql
Day3- using LIKE for searching ('%c%'-----AND--------'%b%' ).sql		Day3- using LIKE for searching ('%c%'-----AND--------'%b%' ).sql
Day3-DATE(HIRE_DATE) LIKE '1987%'.sql		Day3-DATE(HIRE_DATE) LIKE '1987%'.sql
README.md		README.md
day1 - create a table.sql		day1 - create a table.sql
day1- constraint FOREIGN KEY from diff two tables.sql		day1- constraint FOREIGN KEY from diff two tables.sql
day1- constraint in table using CHECK.sql		day1- constraint in table using CHECK.sql
day1- constraint in table using CHECK1.sql		day1- constraint in table using CHECK1.sql
day1- contraint AUTO_INCREMENT.sql		day1- contraint AUTO_INCREMENT.sql
day1- contraint CASCADE,RESTRICT.sql		day1- contraint CASCADE,RESTRICT.sql
day1- contraint DEFAULT.sql		day1- contraint DEFAULT.sql
day1- contraint FOREIGN KEY.sql		day1- contraint FOREIGN KEY.sql
day1- contraint NOT NULL.sql		day1- contraint NOT NULL.sql
day1- contraint ON DELETE NO ACTION and ON UPDATE NO ACTION.sql		day1- contraint ON DELETE NO ACTION and ON UPDATE NO ACTION.sql
day1- contraint PRIMARY KEY , UNIQUE.sql		day1- contraint PRIMARY KEY , UNIQUE.sql
day1- contraint UNIQUE.sql		day1- contraint UNIQUE.sql
day1- contraint using CHECK2.sql		day1- contraint using CHECK2.sql
day1- contraint using FROEIGN KEY on combination of columns.sql		day1- contraint using FROEIGN KEY on combination of columns.sql
day1- contraint using PRIMARY KEY on combination of columns.sql		day1- contraint using PRIMARY KEY on combination of columns.sql
day1- create new table similar to existing table.sql		day1- create new table similar to existing table.sql
day1- create table of already existing.sql		day1- create table of already existing.sql
day1- duplicate copy.sql		day1- duplicate copy.sql
day2- ADD INDEX (to make faster looping using indexes).sql		day2- ADD INDEX (to make faster looping using indexes).sql
day2- ADD combination of PRIMARY KEY.sql		day2- ADD combination of PRIMARY KEY.sql
day2- CHANGE(column name).sql		day2- CHANGE(column name).sql
day2- DROP COLUMN.sql		day2- DROP COLUMN.sql
day2- DROP INDEX.sql		day2- DROP INDEX.sql
day2- MODIFY(to change the datatype).sql		day2- MODIFY(to change the datatype).sql
day2- add FOREIGN KEY with CONSTRAINT.sql		day2- add FOREIGN KEY with CONSTRAINT.sql
day2- add col at first in table.sql		day2- add col at first in table.sql
day2- add new column after old column.sql		day2- add new column after old column.sql
day2- adding new column.sql		day2- adding new column.sql
day2- adding primary key to existing table.sql		day2- adding primary key to existing table.sql
day2- drop FOREIGN KEY.sql		day2- drop FOREIGN KEY.sql
day2- drop combination of PRIMARY KEY.sql		day2- drop combination of PRIMARY KEY.sql
day2- rename table name.sql		day2- rename table name.sql
day3 - two UPDATION at same time using (jobs.salary,employees.salary).sql		day3 - two UPDATION at same time using (jobs.salary,employees.salary).sql
day3- AVG and COUNT.sql		day3- AVG and COUNT.sql
day3- CONCAT(F_NAME , ' ' , L_NAME).sql		day3- CONCAT(F_NAME , ' ' , L_NAME).sql
day3- COUNT(DISTINCT(---) ).sql		day3- COUNT(DISTINCT(---) ).sql
day3- COUNT(asterisk).sql		day3- COUNT(asterisk).sql
day3- LENGTH().sql		day3- LENGTH().sql
day3- LIMIT.sql		day3- LIMIT.sql
day3- REGEXP '[0-9]'.sql		day3- REGEXP '[0-9]'.sql
day3- Removing leading and trailing whitespace characters.sql		day3- Removing leading and trailing whitespace characters.sql
day3- SELECT DISTINCT(---).sql		day3- SELECT DISTINCT(---).sql
day3- SELECT and ORDER BY.sql		day3- SELECT and ORDER BY.sql
day3- SELECT using (alias like 'AS' OR without 'AS').sql		day3- SELECT using (alias like 'AS' OR without 'AS').sql
day3- SUBSTRING(first_name, starting_pos, len of sub_str).sql		day3- SUBSTRING(first_name, starting_pos, len of sub_str).sql
day3- UPDATE using CASE,WHEN -THEN,ELSE,END.sql		day3- UPDATE using CASE,WHEN -THEN,ELSE,END.sql
day3- UPDATE using LIKE.sql		day3- UPDATE using LIKE.sql
day3- UPDATE using WHERE and conditions.sql		day3- UPDATE using WHERE and conditions.sql
day3- UPPER().sql		day3- UPPER().sql
day3- airthmetic operations.sql		day3- airthmetic operations.sql
day3- new col which does not exist using SELECT.sql		day3- new col which does not exist using SELECT.sql
day3- two updation using WHERE and UPDATE and ASSIGNMENT.sql		day3- two updation using WHERE and UPDATE and ASSIGNMENT.sql
day3- two updation.sql		day3- two updation.sql
day3- update table using(update--set---).sql		day3- update table using(update--set---).sql
day3- updation using 2 table.sql		day3- updation using 2 table.sql
day3- updation.sql		day3- updation.sql
day3- using ROUND() to find montly sal upto 2 dec place.sql		day3- using ROUND() to find montly sal upto 2 dec place.sql
day4 - JOIN departments USING (dep_id).sql		day4 - JOIN departments USING (dep_id).sql
day4 - SELF JOIN.sql		day4 - SELF JOIN.sql
day4 - three table JOIN.sql		day4 - three table JOIN.sql
day4- NATURAL JOIN.sql		day4- NATURAL JOIN.sql
day4- employees who was hired after 'Jones'.sql		day4- employees who was hired after 'Jones'.sql
day5 - NATURAL JOIN.sql		day5 - NATURAL JOIN.sql
day5 Subquery using IN.sql		day5 Subquery using IN.sql
day5- 3 subquery.sql		day5- 3 subquery.sql
day5- 5th maximum salary.sql		day5- 5th maximum salary.sql
day5- GROUP using DATEDIFF(NOW fn, hire_date)divideby 365 experience.sql		day5- GROUP using DATEDIFF(NOW fn, hire_date)divideby 365 experience.sql
day5- SELECT in SELECT subqueries.sql		day5- SELECT in SELECT subqueries.sql
day5- WHERE employees.job_id = jobs.job_id.sql		day5- WHERE employees.job_id = jobs.job_id.sql
day5- WHERE salary gt (SELECT AVG(salary) FROM employees).sql		day5- WHERE salary gt (SELECT AVG(salary) FROM employees).sql
day5- jh.asteristk.sql		day5- jh.asteristk.sql
day5- salary gt all the Shipping Clerk using 'ALL'.sql		day5- salary gt all the Shipping Clerk using 'ALL'.sql
day5- subqueries using ALL.sql		day5- subqueries using ALL.sql
day5- subquery.sql		day5- subquery.sql
day5-.sql		day5-.sql
day5-WHERE NOT EXISTS (SELECT 'X' FROM employees a WHERE a.manager_id = b.employee_id);.sql		day5-WHERE NOT EXISTS (SELECT 'X' FROM employees a WHERE a.manager_id = b.employee_id);.sql
day5-WHERE e.department_id = department_id.sql		day5-WHERE e.department_id = department_id.sql
day5.sql		day5.sql
day6- PARTITION BY.sql		day6- PARTITION BY.sql
day6- RANK,OVER.sql		day6- RANK,OVER.sql
day7- FIRST_VALUE, LAST_VALUE.sql		day7- FIRST_VALUE, LAST_VALUE.sql
day7- LAG().sql		day7- LAG().sql
day7- Partition by.sql		day7- Partition by.sql
day7- salary - AVG(salary) OVER(PARTITION BY department_id).sql		day7- salary - AVG(salary) OVER(PARTITION BY department_id).sql
day7-ROWS BETWWEN 2 PRECEDING AND CURRENT ROW.sql		day7-ROWS BETWWEN 2 PRECEDING AND CURRENT ROW.sql
day7-SUM(sales) OVER(ORDER BY month).sql		day7-SUM(sales) OVER(ORDER BY month).sql
day7-WITH ranked_employee AS.sql		day7-WITH ranked_employee AS.sql
day8- Outliers from laptops datasets.sql		day8- Outliers from laptops datasets.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

About

Uh oh!

Releases

Packages

sand-it-100/MySQL

Folders and files

Latest commit

History

Repository files navigation

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Packages