This repository contains structured SQL lessons and practice files covering various SQL concepts. It is designed for beginners and intermediate learners to improve their SQL skills through hands-on exercises.
This repository contains .sql files covering key SQL concepts:
- Database Management: Creating databases, tables, and managing data.
- Querying Data:
SELECT,WHERE,LIKE,GROUP BY,ORDER BY,HAVING, andLIMIT. - Joins & Unions:
INNER JOIN,LEFT JOIN,RIGHT JOIN,FULL JOIN, andUNION. - Functions & Logic: String functions,
CASEstatements, and subqueries. - Advanced SQL: Window functions, CTEs, temp tables, stored procedures, triggers, and events.
Each file focuses on a specific SQL topic for structured learning.
- Clone this repository:
git clone https://github.com/VedantTinkhede/SQL.git
- Open the .sql files in your preferred SQL client or database system.
- Run the queries and practice SQL concepts.
To execute these SQL scripts, you will need:
- A relational database management system (RDBMS) such as MySQL, PostgreSQL, or any other SQL-supported database.
- A database client for running queries, such as:
- MySQL Workbench (for MySQL)
- pgAdmin (for PostgreSQL)
- DBeaver (cross-platform database tool)
This project is licensed under the MIT License. For more details, refer to the LICENSE file.