Skip to content

Latest commit

ย 

History

History
51 lines (25 loc) ยท 963 Bytes

File metadata and controls

51 lines (25 loc) ยท 963 Bytes

๐Ÿ“˜ SQL Learning Repository

Welcome to my SQL Practice Repository ๐Ÿš€ This repository contains all the SQL concepts, queries, and practice exercises that I am learning and implementing as part of my journey in becoming a skilled backend/full-stack developer.

๐Ÿ“Œ About This Repository

This repository includes:

๐Ÿ—„๏ธ Database creation scripts

๐Ÿ“Š Table creation & constraints

๐Ÿ” CRUD operations (Create, Read, Update, Delete)

๐Ÿ”— Joins (Inner, Left, Right, Full)

๐Ÿ“ˆ Aggregate functions

๐Ÿงฎ Group By & Having

๐Ÿง  Subqueries

๐Ÿ”„ Views

๐Ÿ” Constraints (Primary Key, Foreign Key, Unique, Not Null, Check)

๐Ÿ“š Normalization basics

โšก Indexing concepts

๐Ÿ› ๏ธ Stored Procedures & Functions (as I progress)

๐Ÿ› ๏ธ Technologies Used:

SQL

MySQL

๐ŸŽฏ Purpose:

To build strong fundamentals in SQL

To prepare for technical interviews

To understand how databases integrate with Java (JDBC)

To strengthen backend development skills