Introduction to Databases and SQL

Learn about databases and how to use SQL to search and manipulate data

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. In the final week, you’ll finish by grouping and looking at exporting data from the database.

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

This course is designed for learners who haven’t used or created a database and SQL before but would like to learn how to. This could include teachers delivering lessons up to GCSE level or equivalent, as well as students and parents.

To take part in the course you will need to be able to download a files from the internet and either have access to the website sqliteonline.com or be able to install the application DB Browser

• What is a database?
• What is a database?
• Explore a database
• Databases in society
• SQL
• Introduction to SQL
• Reading data within a database
• Modifying data within a database
• Modifying a database
• Adapting databases
• Relationships
• Data analytics