Project

MySQL Workbench

Challenging

32 completions

~ 7 hours

4.3

In this project, you'll gain hands-on experience building a data model for art information with MySQL Workbench that conforms to the Third Normal Form. You'll learn how to translate this model into a functional database using forward engineering. You'll also explore the potential of Generative AI to assist in model creation and leverage prompt engineering to extract insights. This project equips you with the skills to become better at designing and querying databases through exploring the world of art.

Provided by

JetBrains Academy

About

Ever wondered how Generative AI could transform your data journey? In this project, you will discover how Generative AI and MySQL Workbench can help you become a more productive data modeler and analyst. You will combine these tools to create a data model, turn this model into SQL code to initialize a database, and extract insights from the database with Generative AI through prompt engineering.

Graduate project

This project covers the core topics of the SQL for Data Analysis course, making it sufficiently challenging to be a proud addition to your portfolio.

At least one graduate project is required to complete the course.

What you'll learn

Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:

Create a data model that conforms to 3NF and turn it into a functional database

Use Generative AI to assist with INSERT statements

Combine subqueries and aggregate functions

Practice working with self-join and date

Write advanced queries using subqueries, and aggregate and window functions

Reviews

Olga Nilova

1 month ago

5.0

Thank you for this amazing SQL project! It provided a fantastic hands-on experience in relational database management and data analysis.Key things I have successfully mastered and implemented:Database Architecture: Designing schemas, handling constraints (FOREIGN_KEY_CHECKS), and managing data i ...

Gilbert Pellerano

3 months ago

3.7

I deepened my understanding of executing and optimizing complex SQL queries within MySQL Workbench. The main challenge was debugging syntax errors in multi-table joins, which I overcame by breaking down the queries step-by-step and utilizing the visual explain plan feature to check indexing.

Tomas Kanuch

6 months ago

4.7

I have learned combining AI, MySQL querying and MySQL Workbench to work with relational database. Forward engineering seems helpful, "modeling" in Workbench seemed also like a useful function.

4.3

Learners who completed this project within the SQL for Data Analysis course rated it as follows:

Usefulness

4.2

Fun

4.3

Clarity

4.4