Project

Library Management System

Medium

129 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

Mauro Gonçalves

5 months ago

5.0

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

Przemyslaw Gorski

10 months ago

4.7

Thanks to this project I know now an useful time statements in SQLite.

Janek Kupper

12 months ago

4.7

This project learned how to create database and tables, insert data into tables, update table content and query data from database.

4.2

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

Usefulness

4.4

Fun

4.0

Clarity

4.1