This repository contains a collection of SQL scripts, queries, and mini projects that demonstrate various database concepts and operations.
It serves as a personal learning and practice space for mastering SQL fundamentals and advanced topics.
- Basic Queries β SELECT, WHERE, ORDER BY, DISTINCT, etc.
- Joins & Subqueries β INNER JOIN, LEFT JOIN, nested queries, etc.
- Database Design β Tables, Primary/Foreign Keys, Constraints.
- Aggregate Functions β COUNT, SUM, AVG, GROUP BY, HAVING.
- Normalization & Relationships β 1NF, 2NF, 3NF examples.
- Advanced SQL β Views, Triggers, Stored Procedures, and Functions.
- Mini Projects β Real-world database examples for practice.
- Strengthen SQL query writing and problem-solving skills.
- Understand database schema design and optimization.
- Gain hands-on experience with MySQL / PostgreSQL / SQLite.
- Database: MySQL / SQLite / PostgreSQL
- Editor: VS Code
- Version Control: Git & GitHub
- Clone this repo:
git clone https://github.com/Vishalxp20/SQL.git