Project

MySQL Workbench

Challenging

15 completions

~ 8 hours

4.5

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

Bojan Gjokjevski

1 month ago

5.0

Great exercise to start using MySQL WB, assisted by a free AI model. Thank you HS team!

Dimitris Margetis

3 months ago

4.7

This project was an excellent demonstration of how AI can effectively assist with complex SQL queries. The process provided a solid understanding of the MySQL Workbench environment and fundamental relational database concepts, including joins, subqueries, and window functions.

Mauro Gonçalves

5 months ago

5.0

I gained a deeper understanding of database design principles, particularly the Third Normal Form (3NF), which ensures data integrity and minimizes redundancy. Integrating Generative AI with MySQL Workbench proved valuable for automating repetitive tasks like generating INSERT statements.

4.5

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

Usefulness

4.6

Fun

4.5

Clarity

4.3