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,
CASE
statements, 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.