Manage Data for an Online Grocer Using MySQL Workbench
By External Provider
About this course
In this project, you’ll help Greenspot Grocer, an online grocery store, prepare for rapid growth and planned expansion. You’ll explore the company’s product data, currently stored in a spreadsheet format, and build a relational database that will help it better manage its inventory and accommodate future growth. Upon completion, you’ll demonstrate your ability to use MySQL Workbench to complete database design and implementation, from modeling a database to creating and loading data to testing and validating your design. There isn’t just one right approach or solution in this scenario, which means you can create a truly unique project that helps you stand out to employers. ROLE: Data Analyst SKILLS: SQL PREREQUISITES: Modeling tool, create and load data tables with MySQL Workbench Write SQL retrieval query code.
What you will learn
- Examine the current data and reorganize it into relational tables using the modeling tool in MySQL Workbench
- Create and load the database with the sample data provided
- Test the database design and verify the design by generating SQL JOIN queries