This repository contains exercises and visualizations from the course "SQL - MySQL for Data Analytics and Business Intelligence" on Udemy, created by [365 Careers, 365 Team].
The exercises are based on the Employee Database, which includes the following tables:
t_employees: Employee details (name, gender, hire date).t_departments: Lists of department names and numbers.t_dept_emp: Employee-department relationships.t_dept_manager: Department managers' details.t_salaries: Salary information for employees.
SQL Task: Create a visualization that provides a breakdown between the male and female employees working in the company each year, starting from 1990.
SQL Task: Find the number of female employees who signed contracts before January 1, 1998, and the number of male employees who signed contracts in the same period.
SQL Task: Compare the number of male managers to female managers across departments for each year starting from 1990.
SQL Task: Compare the average salary of female versus male employees across all departments up to 2002.
SQL Task: Filter the comparison of average salaries by contract dates (before or on/after January 1, 1998).
SQL Task: Create a stored procedure that retrieves the average salary of male and female employees within a user-defined salary range per department.
Tableau Task: Organize visualizations from tasks 1-4 into a Tableau dashboard.
This repository includes exercises and visualizations from the course "SQL - MySQL for Data Analytics and Business Intelligence" on Udemy. Special thanks to [365 Careers, 365 Team] for the insightful content.