A collection of MySQL and SQL learning exercises, practice tasks, and database concepts that I worked on and shared on LinkedIn.
This repository serves as a personal learning archive and reference for SQL and MySQL concepts covered during my database learning journey.
This repository contains SQL practice files covering fundamental to intermediate database concepts, including:
- MySQL Basics
- SQL Operators
- SQL Joins
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- OUTER JOIN
- CROSS JOIN
- SELF JOIN
- SQL Clauses
- Subqueries
- Window Functions
- Views
- Triggers
- Practice Questions
- Learning Tasks
The files were created as part of my continuous practice and learning in SQL and MySQL.
| File / Topic | Date |
|---|---|
| VIEWS & TRIGGERS in MySQL | 16-02-2026 |
| WINDOW FUNCTIONS | 13-02-2026 |
| SUBQUERIES IN SQL | 11-02-2026 |
| OUTER, CROSS & SELF JOIN | 09-02-2026 |
| OUTER JOIN | — |
| CLAUSES TASK | 02-02-2026 |
| SQL JOINs | 31-01-2026 |
| LEFT JOIN Practice Questions | 30-01-2026 |
| LEFT JOIN | 29-01-2026 |
| RIGHT JOIN Practice Questions | 28-01-2026 |
| RIGHT JOIN | 27-01-2026 |
| INNER JOIN | 26-01-2026 |
| MySQL INNER JOIN | 24-01-2026 |
| MySQL Operators | 23-01-2026 |
| MySQL Practice | 21-01-2026 |
| MySQL Practice | 20-01-2026 |
| Sankranthi Holidays Task 2 | — |
| Sankranthi Holidays Task 1 | — |
Practice and exercises related to:
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- OUTER JOIN
- CROSS JOIN
- SELF JOIN
Exercises covering the use of queries inside other SQL queries for retrieving and filtering data.
Practice with SQL window functions for performing calculations across related rows while preserving individual row-level results.
Learning and practice related to creating and working with database views.
Exercises covering database triggers and automated actions performed in response to database events.
Practice involving commonly used SQL clauses for filtering, grouping, sorting, and retrieving data.
Exercises covering different SQL/MySQL operators used for comparisons, conditions, calculations, and logical operations.
The main objectives of these exercises were to:
- Build a strong foundation in SQL.
- Understand relational database concepts.
- Practice writing SQL queries.
- Learn how tables can be combined using different types of joins.
- Understand subqueries and nested queries.
- Practice window functions.
- Learn database views and triggers.
- Improve query-writing and problem-solving skills.
- Gain hands-on experience with MySQL.
- MySQL
- SQL
- Relational Databases
January 2026 – February 2026
These files represent my SQL and MySQL practice during this period.
This repository is maintained as a learning archive rather than a production application.
The purpose is to preserve my practice work, exercises, and learning materials so they can be referenced later while working on database-driven applications.
Charan Teja Epuri
Aspiring Python Full Stack Developer
This repository documents my learning and practice journey with SQL and MySQL.
I believe consistent practice and building a strong foundation in databases are essential for developing reliable and scalable applications.
This repository is intended for educational and personal learning purposes.