4.75(4)

#IT-04-07 Introduction to Databases and SQL

  • Categories IT
  • Duration 12h
  • Total Enrolled 5
  • Last Update September 21, 2020

About Course

Raspberry Pi Foundation

Description

Learn about databases and how to use SQL to search and manipulate data

On this course from the Raspberry Pi Foundation you’ll learn what databases are and why we use them, exploring how to use SQL to search and manipulate data.

Along the way, you’ll learn about primary keys and table relationships, as well as how to create joins to search multiple tables. Finally, you’ll finish by grouping and looking at exporting data from the database.

Learning about databases and SQL is a key component of GCSE Computer Science, so it’s important for educators, students, and parents alike to feel confident about the subject.

What topics will you 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

Who will you learn with?

Matt Hogan

Hi I am Matt. I love being a Learning Manager for Key Stage 4 at The Raspberry Pi Foundation. I feel privileged to support the computing education community from across the world.

 

 

Who developed the course?

raspberry pi

The Raspberry Pi Foundation works to put the power of digital making into the hands of people all over the world, so they are capable of understanding and shaping our increasingly digital world.

 

 

What Will I Learn?

  • 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

Topics for this course

9 Lessons12h

What is a database??

Discover where and when you use databases in the real world and why they are useful in everyday life.
Welcome to the course00:01:42
Meet the team and your fellow learners
Why use a database?

Explore a database?

Explore a real example of an SQL database. Browse tables within the database and start to add new data.

Databases in society?

Check your understanding of databases so far and think about where they may be used.

Student Feedback

4.8

Total 4 Ratings

5
3 ratings
4
1 rating
3
0 rating
2
0 rating
1
0 rating

This course teaches you how to be flexible with spreadsheets using databases or spreadsheets. I think it's something that everyone has to learn.

Although I really want to learn the course of database well, I find it difficult to learn because the course of database is quite boring. This is not so boring.

Very helpful information. The lectures are not long, to the point to keep, and keeps you focused.

It is the bestest platform to learn a particular course so engaging, I completed everything in span of 2 days thank you so much !!

USD$49

Material Includes

  • Official Certificate

Target Audience

  • This course is designed for learners who haven’t used or created a database and SQL before but would like to learn how to. This could include teachers delivering lessons at GCSE level or equivalent, as well as students and parents.