Introduction to Databases and SQL (edX)

Introduction to Databases and SQL (edX)
Course Auditing
Categories
Effort
Certification
Languages
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.
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Introduction to Databases and SQL (edX)
Learn to create and manipulate databases using 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.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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.


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


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



MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
45.00 EUR
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.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.