SQL PROJECTS

In this section, you’ll find some of my first SQL projects, which I began using MySQL Workbench. The main highlight is the «employees» sample database, a widely used dataset that spans six separate tables and more than a million records.

This dataset includes the tables: employees, departments, dept_emp, dept_manager, titles, and salaries, each varying in scale and complexity. This enabled me to practice various SQL query types, from complex joins and filtering to aggregations and more.

Feel free to explore the queries in action and observe how I tackled different tasks. And don’t forget to check my main portfolio section, where I showcase my TOP projects: the ones that best reflect my current capabilities as a Data Analyst.

🧑‍💼 1. Employee Analysis
Seniority, job roles, title history, hiring dates, work history.

📊 2. Salary Statistics
Averages, mins, maxs, outliers, percentiles, salary bands.

🎯 3. HR Insight, Promotions
Changes, titles, promotion candidates, department shifts.

⚙️ 4. Automation & Performance
Temp tables, views, indexing, stored procedures, triggers.

Scroll al inicio