Welcome to the MySQL Notes repository! This collection of notes is designed for students, developers, and anyone new to relational databases who want a structured, beginner-friendly reference to MySQL.
- What is SQL & CRUD Operations
- SQL Data Types (INT, VARCHAR, BLOB, etc.)
- SQL Command Types
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- DQL (Data Query Language)
- DCL (Data Control Language)
- TCL (Transaction Control Language)
- Creating and Managing Databases & Tables
- Primary and Foreign Keys
- SQL Constraints (NOT NULL, UNIQUE, PRIMARY KEY, DEFAULT, CHECK)
- SELECT Queries & Filtering
- WHERE Clause
- DISTINCT, LIMIT, ORDER BY
- Logical & Comparison Operators
- Aggregate Functions (SUM, COUNT, AVG, MAX, MIN)
- GROUP BY & HAVING Clauses
- Data Manipulation
- INSERT, UPDATE, DELETE, TRUNCATE
- Joins
- INNER, LEFT, RIGHT, FULL, EXCLUSIVE Joins
- SQL Subqueries
- Views (CREATE, SELECT, DROP)
- Schema Changes with ALTER
- Foreign Key Cascading
This repository is meant as a quick reference or learning tool. Each concept is explained clearly with:
- Simple definitions
- Syntax examples
- Real-world use cases
Great for students preparing for interviews or developers revisiting SQL fundamentals.
- Computer science & IT students
- Beginners in database programming
- Self-taught developers and hobbyists
- Notepad / Text Editor
- Structured SQL Syntax Examples
- MySQL Workbench
Aayush Kumar Vijaykumar Tiwari
B.Sc IT Student at Siddharth College of Commerce and Economics
Email: kamleshvijay20@gmail.com
If you find this useful, feel free to star 🌟 the repo and share it with fellow learners!