Introduction to databases and SQL CO225 / A23
Summary
During 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.
What topics are 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. You can learn independently or with colleagues to directly address your individual needs.
This course will be periodically facilitated by expert Professional Development Leaders.
Who is the course leader?
-
This is a self-paced Online Course
The course leader will be introduced in the course.
-
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
| Date | Time | Location | |
|---|---|---|---|
| Introduction to databases and SQL | 01 September 2023 | 00:00-23:59 | Online course |
Actions
Fees & Subsidies
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.
Interested in this course?
Sign up to receive our emails to hear about the latest CPD available