Introduction to databases and SQL
CO225 Online course
On this course you’ll learn what databases are and why we use them, exploring how to use SQL to search and manipulate the data.
Skip to course bookingDuring this course 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.
Who is it for?
This course is aimed at classroom teachers teaching up to and including GCSE computer science.
Topics covered
You'll cover the following topics:
What are databases used for and how they compare to using spreadsheets
- Creating and using SQL statements, including adding data using SQL statements
The role of primary keys
- Apply relationships to tables within a database
Use joins to search across multiple tables
Group data in a database
How will you learn?
This online, self-paced course can be completed flexibly. You can join and start this course at any time after the advertised date, and keep access for a year after booking. You can learn independently or with colleagues to directly address your individual needs.
This course will be periodically facilitated by expert Professional Development Leaders.
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 KS3 and GCSE Computer Science subject knowledge certificate
Key stage 3 and GCSE Computer Science certificate
Our certificate is designed to help you develop or refresh your computer science subject knowledge.
Join this course
You need to be logged in to join the course.
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.
Adapting the Teach Computing Curriculum for mixed-year classes - short course
Explore progression within Teach Computing Curriculum and how to use this to adapt it for your own mixed-age setting.
AI and Ethics in GCSE computer science
Artificial intelligence, what is it? How does it work? What are the ethical considerations for GCSE students. How could you teach it to your students?