Skip to content

VedantTinkhede/SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQL Practice Repository

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.

πŸ“‚ Folder Structure

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, and LIMIT.
  • Joins & Unions: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and UNION.
  • 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.

πŸš€ Getting Started

  1. Clone this repository:
    git clone https://github.com/VedantTinkhede/SQL.git
  2. Open the .sql files in your preferred SQL client or database system.
  3. Run the queries and practice SQL concepts.

πŸ› οΈ Requirements

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)

πŸ“œ License

This project is licensed under the MIT License. For more details, refer to the LICENSE file.

About

This is the repository to store my SQL lessons.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published