Project

Library Management System

Medium

139 completions

~ 7 hours

4.2

Learn the basics of SQL by operating a database. Study what data types can be used for management systems and how structures are created. Discover how to process data and define functions in SQL. Learn the data types and constraints that work with SQLite.

Provided by

JetBrains Academy

About

Good library management is all about keeping records. In the past, special logbooks were reserved for these purposes. The modern solution are databases, an excellent tool for storing big chunks of information — anything, from images to text, single-character data to thousands of digits. You don't even need to keep this data on your computer! Let's see how databases can help you with running a library.

Training project

This project allows you to practice and strengthen your coding skills, helping you get ready for more advanced tasks ahead.

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:

Learn how to create tables and data types.

Learn how to add or edit new data in a table.

Learn to delete data in a table.

Learn how to compare data. Find out who delayed books and print their list.

Reviews

Dan Murphy

5 months ago

4.7

I got to practice SQL CREATE, INSERT, UPDATE and SELECT commands, using JOIN, WHERE and ORDER BY to create precise queries. I also got to work with the SQLite date() command.

Tomas Kanuch

7 months ago

4.7

I have learned very basic work with SQLite: create tables, populate tables. Then simple table manipulations: Insert, Update table SET column, JOIN, WHERE, ORDER BY

Mauro Gonçalves

1 year ago

5.0

This project provided a practical deep dive into SQL database management using SQLite.

4.2

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

Usefulness

4.4

Fun

4.1

Clarity

4.2