Skip to main content

RaspberryPiFoundation: Introduction to Databases and SQL

Learn to create and manipulate databases using SQL.

Introduction to Databases and SQL
3 weeks
2–4 hours per week
Self-paced
Progress at your own speed
Free
Optional upgrade available

There is one session available:

After a course session ends, it will be archivedOpens in a new tab.
Starts May 17
Ends Sep 5
Enroll
Introduction to Databases and SQL

About this course

Skip About this course

On this course from the Raspberry Pi Foundation, you will learn about databases and how to use SQL to search and manipulate the data they store.

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.

At a glance

  • Institution: RaspberryPiFoundation
  • Subject: Education & Teacher Training
  • Level: Intermediate
  • Prerequisites:

    To take this course, you need to be familiar with basic database concepts, but you don't need any experience of relational databases or SQL.

  • Language: English
  • Video Transcript: English

What you'll learn

Skip What you'll learn

Over the following three weeks, you will:

  • Explain the key terms used to describe databases
  • 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

Syllabus

Skip Syllabus

This course will cover:

  • 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

Frequently Asked Questions

Skip Frequently Asked Questions

Who is this course for?

This course is designed for teachers delivering lessons at a GCSE level or equivalent, and for educators wanting to start using databases and SQL.

What software will I need?

To take part in the course you will need to be able to download files from the internet and either have access to the website sqliteonline.com or be able to install the application DB Browser.

Ways to take this course

Choose your path when you enroll.

Certificate

Free

Price

$59 USD

-

Access to course materials

Unlimited

Limited

Expires on Jun 7

World-class institutions and universities

edX support

Shareable certificate upon completion

Graded assignments and exams

Read our FAQsin a new tab about frequently asked questions on these tracks.

Interested in this course for your business or team?

Train your employees in the most in-demand topics, with edX For Business.
Purchase nowRequest information