Welcome to my SQL Learning Repository 🎯
This repo contains all my daily SQL practice and notes, focused on Software Testing & Automation use cases.
This repository documents my day-wise SQL learning and practice queries.
The goal is to gain strong database validation skills required for Manual Testing, Automation Testing, and API Testing.
| Day | Topics Covered | Description |
|---|---|---|
| Day 1 | Database Basics | Create Database, Tables, Insert Data |
| Day 2 | SELECT, WHERE, ORDER BY, LIMIT | Fetch & Filter Data |
| Day 3 | Operators & Expressions | Use Comparison, Logical & Arithmetic Operators |
| Day 4 | Joins | Combine Data from Multiple Tables |
| Day 5 | Aggregations | COUNT, SUM, AVG, GROUP BY, HAVING |
| Day 6 | DML & DDL Commands | INSERT, UPDATE, DELETE, ALTER, DROP |
| Day 7 | Subqueries & Views | Nested Queries, Virtual Tables |
| Day 8+ | SQL for Testing | Real-world Testing Scenarios + Automation Integration |
I’m using:
- 🐬 MySQL (local setup)
- 🌐 DB Fiddle — https://www.db-fiddle.com/
- 🧰 VS Code for writing
.sqlfiles - 📦 GitHub for version control and progress tracking
🎯 Testing Use Cases (Why Testers Need SQL)
Validate data after form submission
Check backend data after API call
Compare UI data with database records
Prepare test data before automation runs
Clean up test environment using queries
🧠 Tools & Skills Practiced
SQL Fundamentals
Data Validation for Testing
MySQL Database
DB Schema Design
Python Integration with SQL (PyMySQL)
Git & GitHub
🚀 Future Scope
I’ll soon extend this repo to include:
✅ Database Testing Project (User & Order Workflow)
✅ SQL + Python Integration
✅ Pytest DB Validation Scripts
📬 Connect with Me
👤 Rohit Dighe 💼 QA Engineer | Python Automation Tester 📧 rohitdighe47@gmail.com