Sample project based on an SQL query to filter data from a company database- In this project, included many files which filters all data of the company's employees, sales and other things. In employee table including their ID, Name, Salary, Hire Date, Department, etc.
- Filter the data from the company's database.
- Check employees' names, salaries, departments, and other relevant information according to the company's requirements.
- Check product sales of company and filter the different data collections from table of sales.
- Requirements to access employee data and sales data from a particular perspective.
- Filter the data for a better understanding of the workforce of the company and sales of company's product.
- SQL
- DBMS
There are 1000 of Data available in this Employees Table with 14 columns:
- EEID (Id of employees)
- Full_Name (full name of employees)
- Job_tittle (their job positions)
- Department (their departments)
- Business_unit (their Business unit)
- Gender (their genders identification)
- Ethnicity (their continent)
- Age (their age)
- Hire_date (their first hiring date)
- Annual_salary (their particular annual salaries)
- Bonus_per (their bonus in percentage)
- Country (their origin country)
- City (their city as well)
- Exit_date (their exit data from company)
[ In this project, I added two files containing employee data and performed various SQL queries to filter new data from the Employees Database.📄✍️🧑💻 ]
[ In sales tables , there are 50 plus data available of different product sale ( I add one file containing sale data and performed various SQL queries to filter new data from the Company's Database.📄✍️🧑💻]
( I did not mentioned all columns here from sales table).
Feel free to explore my other repositories and reach out to me for collaborations or discussions on new idea and projects.🤝😊🧑💻