On this course from the Raspberry Pi Foundation you’ll learn what databases are and why we use them, exploring how to use SQL to search and manipulate data.

Along the way, you’ll learn about primary keys and table relationships, as well as how to create joins to search multiple tables. Finally, you’ll finish by grouping and looking at exporting data from the database.

Learning about databases and SQL is a key component of GCSE Computer Science, so it’s important for educators, students, and parents alike to feel confident about the subject.

What topics will you cover?

• What are databases used for?
• Why use a database or a spreadsheet?
• Create SQL statements to search a database
• The role of primary keys
• Add data using SQL statements
• Apply relationships to tables within a database
• Use joins to search across multiple tables
• Group data in a database

Matt Hogan

Hi I am Matt. I love being a Learning Manager for Key Stage 4 at The Raspberry Pi Foundation. I feel privileged to support the computing education community from across the world.

 

 

Who developed the course?

Raspberry Pi Foundation

The Raspberry Pi Foundation works to put the power of digital making into the hands of people all over the world, so they are capable of understanding and shaping our increasingly digital world.