Introduction to Databases and SQL

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.

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