Building a Database

In this lesson, you'll create a simple database to store information about your favorite animals. You'll learn how to build tables, add data, and retrieve information from your database.

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Setting up SQLite
2 Creating a new table
3 Adding columns
4 Inserting data
5 Querying your data
6 Filtering data
7 Sorting data
8 Saving your work
Quiz

1 - Setting up SQLite

Visit the SQLite online editor at sqliteonline.com to start creating your database. You don't need to download or install anything.

👇 Mark your steps as done as you complete them.

+5 XP

2 - Creating a new table

Click on 'New Table' to create a new table for your database. Name the table 'Animals'.

👇 Mark your steps as done as you complete them.

+10 XP

3 - Adding columns

Add the following columns to your 'Animals' table: 'ID' (integer), 'Name' (text), 'Type' (text), and 'Habitat' (text). Make the 'ID' column the primary key.

+15 XP

4 - Inserting data

Now, let's add some data to your table. Insert at least 3 rows of data about your favorite animals, including their name, type, and habitat. For example, you can add data like this:

1, 'Elephant', 'Mammal', 'Savannah'

2, 'Penguin', 'Bird', 'Antarctica'

3, 'Shark', 'Fish', 'Ocean'

+20 XP

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.