Introduction to databases and SQL CO225 / A02

Duration
3 Weeks
Learning Method
Online Delivered CPD

Summary

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 GCSE 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

Sessions

DateTime
Introduction to databases and SQL06 July 202000:00-00:00

Share with your CPD booker

Additional information

If the course you would like to attend is fully booked, please contact enquiries@stem.org.uk to express your interest in being added to a waiting list. We will contact you when the course is due to run again.

Are you a state-funded Special School or PRU unit in England? You may be eligible for reduced course fees and even subsidies. Get in touch to check your eligibility and book your place directly. You can see our fees and subsidy information here.

Interested in this course?

Sign up to receive our emails to hear about the latest CPD available