Introduction to databases and SQL

CO225 Online course

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 the data.

Data & information Key stage 4 CS Accelerator

Free online course Approximately 8 hours of self-study

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 the 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.

Topics covered

• 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

Outcomes

You will be able to:

• Produce SQL statements to search and update a database
• Explain the comparison of databases to spreadsheets
• Apply filters in SQL statements
• Demonstrate how to use SQL statements to create relationships for tables in a database
• Produce SQL statements to search across multiple tables

This course is part of the Subject knowledge certificate

Subject knowledge certificate

Our professional development programme, Computer Science Accelerator, is designed to help you develop or refresh your subject knowledge and leads to a nationally recognised certificate.

Find out more

Join this course

You need to be logged in to start the course.

Not got a STEM Learning account?
Create an account

This course is from Teach Computing and delivered by Raspberry Pi Foundation

Adapted teaching and effective learning interventions in secondary computing

Develop an evidence-informed approach to education recovery over a sustained period, securing the computing education of young people following a period of great disruption.

Live remote training course

An Introduction to algorithms, programming and data in computer science - remote

Create some simple block-based computer programs and discover how to implement them in the text based language Python.

Live remote training course

An introduction to algorithms, programming and data in GCSE computer science - face to face

Create some simple block-based computer programs and discover how to implement them in the text based language Python.

Face to face course