Project

Food Blog Backend

Challenging

299 completions

~ 21 hours

4.5

You will create a simple backend that will allow you to populate an SQLite3 database. You will find out how to deal with an auto-increment primary key and how to use foreign keys to create relationships between tables. You will learn to work with many-to-many relations, with SQL queries, and with database cursor methods.

Provided by

JetBrains Academy

About

Your great-grandmother asked you to copy all the recipes that she had been collecting in her notebook for several decades to “that computer of yours”. You don't like easy solutions, so you decided to build a recipe database. You will need to refresh your SQL knowledge to build a simple backend.

Graduate project

This project covers the core topics of the Databases with SQL and Python 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 database and prepare the dictionaries.

Create the main table and a simple recipe entry tool.

Create an intermediary table to deal with many-to-many relations.

Create a table to store quantity, measure, and ingredient names. You will also need to implement ways to speed up the database completion.

Create your first backend interface that will allow you to return the data you are looking for.

Reviews

Gleb Fedorov

8 months ago

4.7

I've learned how to interact with sqlite DMBS, how to handle argparse parameters from terminal. Also get more practice with classes and methods.

DisparateBits

1 year ago

2.3

This one was kind of ambiguous and not clearly defined in my opinion. Didn't like it.

Carissa Lee OConnell

1 year ago

5.0

I enjoyed learning about command line arguments, how to do a database connection, using sql queries, dictionaries, loops, how to enumerate a function, and argparse

4.5

Learners who completed this project within the Databases with SQL and Python course rated it as follows:

Usefulness

4.7

Fun

4.4

Clarity

4.4