SQL Repository

📌 Overview

Welcome to my SQL Practice Repository.

This repository contains my hands-on SQL learning journey, where I practice and implement various SQL concepts ranging from basic queries to advanced SQL operations. The purpose of this repository is to build a strong foundation in database management, data analysis, and query optimization through practical examples and real-world scenarios.

I created this repository as part of my learning path toward becoming a Data Analyst/Data Scientist.

---

🎯 Objectives

The main objectives of this repository are:

• Strengthen SQL fundamentals
• Practice real-world database operations
• Improve query writing skills
• Understand data manipulation techniques
• Learn data retrieval and analysis methods
• Build a portfolio of SQL projects and exercises
• Prepare for interviews and technical assessments

---

🛠 Technologies Used

• SQL
• PostgreSQL
• MySQL
• Database Management Systems (DBMS)
• Git & GitHub

---

📚 Topics Covered

Basic SQL Concepts

✔ SELECT Statements
✔ WHERE Clause
✔ DISTINCT
✔ LIMIT
✔ ORDER BY
✔ Aliases

---

Operators

✔ Arithmetic Operators
✔ Comparison Operators
✔ Logical Operators
✔ AND, OR, NOT Operations
✔ BETWEEN
✔ IN
✔ LIKE

---

SQL Functions

Aggregate Functions

✔ COUNT()
✔ SUM()
✔ AVG()
✔ MIN()
✔ MAX()

String Functions

✔ UPPER()
✔ LOWER()
✔ LENGTH()
✔ CONCAT()
✔ SUBSTRING()

Date & Time Functions

✔ CURRENT_DATE
✔ CURRENT_TIME
✔ EXTRACT()
✔ AGE()

Conditional Functions

✔ CASE Statements
✔ COALESCE()

---

JOIN Operations

✔ INNER JOIN
✔ LEFT JOIN
✔ RIGHT JOIN
✔ FULL JOIN
✔ CROSS JOIN
✔ SELF JOIN

---

Set Operations

✔ UNION
✔ UNION ALL
✔ INTERSECT
✔ EXCEPT

---

Advanced SQL

✔ Window Functions
✔ Ranking Functions
✔ Partitioning
✔ Row Number
✔ Common Table Expressions (CTEs)

---

📂 Repository Structure

SQL/
│
├── Aggregate Functions.sql
├── Arithmetic operations.sql
├── Comparison operations.sql
├── Date & Time Functions.sql
├── JOIN functions.sql
├── SQL Functions Practice.sql
├── String functions.sql
├── Window functions.sql
├── Union, Intersect and Except.sql
│
└── README.md

---

💡 Learning Approach

This repository follows a practical learning approach:

1. Learn concepts
2. Write SQL queries
3. Practice examples
4. Solve problems
5. Build mini-projects
6. Improve query efficiency

---

🚀 Future Improvements

Planned additions:

• SQL mini projects
• Real-world datasets
• Stored procedures
• Triggers
• Views
• Database design examples
• Interview questions and solutions
• Advanced query optimization

---

📈 Skills Developed

Through this repository I am improving:

• Data querying
• Database management
• Analytical thinking
• Problem solving
• Data manipulation
• Query optimization

---

🤝 Contributions

Suggestions and improvements are always welcome.

Feel free to:

• Fork this repository
• Raise issues
• Submit pull requests

---

👨‍💻 Author

Vijay K G

Aspiring Data Analysts | SQL Learner | Data Analytics Enthusiast

GitHub: https://github.com/vijaykg01

LinkedIn: https://www.linkedin.com/in/vijaykg01

---