Databases for A‑level Computer Science
CO507 Online course
An introduction to databases for A-level teachers. Gain confidence in teaching the databases content in the A-level specification including attempting and marking exam questions.
Skip to course bookingLearn about a new topic from GCSE, the world of databases. We will discuss the key terminology you need to learn to teach the students in your classes.
You will learn the skill of normalising a database right from 1st normal form to 3rd normal form which, is a topic many students find a challenge. As well as learning about the theory of databases you will also learn how to use SQL to search and query the database.
You’ll develop key pedagogical approaches to teaching databases at A level including looking at the exam questions students are asked. We want you to come away from the course with the confidence to deliver this in your school or college.
Who is it for?
This course is aimed at teachers delivering A Level Computer Science. Since this content is not covered in most GCSE specifications we will take you right from the very basics to the more advanced topics.
During this course you’ll access the Isaac Computer Science platform, it is advised you sign up for a free, teachers account ahead of the course.
Topics covered
Intro to databases
What is a DB? Flat files v Relational DBsStructure of a DB and key termsWhat is a DBMS?Entity Relationship ModellingResolving many-to-many relations
Designing and using databases
The purpose of normalisationNormalisation in practiceTransaction processing and ACIDIntroduction to SQLPractice exam questions
How long is this course?
This online course will take your approximately 3 hours to complete.
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.
Outcomes
By the end of this intensive online CPD course you will be able to:
• Explain the key terminology needed for teaching A Level databases• Be able to teach the rules of database normalisation• Be able to use SQL with students to develop their knowledge of the subject• Be able to attempt exam board questions with students and mark their attempts confidently
This course is part of Teach secondary computing
Teach secondary computing
Our nationally recognised qualification will give you confidence to take your computing teaching to the next level and to apply those skills in the classroom.
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
Explore progression within Teach Computing Curriculum and how to use this to adapt it for your own mixed-age setting.
Advanced A-Level Programming
Deepen your knowledge of algorithms, recursion, and Big O notation with this CPD course for new A-level Computer Science teachers.