SQL Projects
This SQL project demonstrates the basic process of creating, designing and managing a database table called customers, aimed at creating a structured list of customers for a fictional company. The table stores essential customer information, including their names, addresses, cities, postal codes, and unique customer IDs. Each step in the project highlights how SQL is used to manage and maintain structured customer data effectively.
This SQL project covers the entire lifecycle of managing employee data, branch information, and sales records within a relational database system. It involves designing and managing a relational database system for a fictional company. In this database, I created employee details, branch information, and sales records tables. Inserting data, and performing operations like altering, updating, and querying the data. This approach provides a comprehensive understanding of how to manage and analyze business data in a structured, scalable manner.
This SQL project demonstrates a comprehensive analysis of employee salary data within an organization. It covers various aspects such as salary grouping, identifying top and low earners, and analyzing trends based on hire dates. It also involves updating the employee list, inserting new employee details, and generating reports on top earners and employee IDs. It shows how to manage and update the employee database, ensuring the data is current and accurate. .
This project is a visualization of transaction data from OList. OList is the largest department store in Brazil. The dataset has information on 90k orders from 2016 to 2018 made at multiple marketplaces in Brazil.
