MySQL Skills
MySQL Skills
Proficient in writing SQL queries to retrieve, filter, and sort data using SELECT, WHERE, ORDER BY, LIMIT, and DISTINCT
Skilled in using joins (INNER JOIN, LEFT JOIN, RIGHT JOIN) to combine data from multiple tables
Experienced with GROUP BY, HAVING, and aggregate functions (COUNT(), SUM(), AVG(), MIN(), MAX()) for data summarization
Able to create and manage databases and tables using CREATE, ALTER, and DROP statements
Comfortable with data manipulation using INSERT, UPDATE, and DELETE
Familiar with subqueries, nested queries, and common table expressions (CTEs)
Understands data types, indexing, and performance optimization basics
Use of MySQL in real-world projects for data analysis
My MySQL Projects
The Northwind database is a well-known sample dataset that simulates a trading company’s operations. It includes data on customers, orders, products, employees, and more. This project uses the Northwind schema to demonstrate SQL querying, data analysis, and reporting using MySQL.
This project is inspired by platforms like SQLBolt, offering a hands-on approach to learning SQL. It includes structured lessons, example queries, and practice exercises that cover the basics of SQL syntax and logic.
Click here to see my project files