Discover how databases work and how to use SQL in this introductory course. Supported by Google.
19,587 enrolled on this course
Duration
3 weeksWeekly study
2 hours100% online
How it works
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. 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.
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
When would you like to start?
Start straight away and join a global classroom of learners. If the course hasn’t started yet you’ll see the future date listed below.
Learning on this course
On every step of the course you can meet other learners, share your ideas and join in with active discussions in the comments.
What will you achieve?
By the end of the course, you‘ll 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
- Explain the key terms used to describe databases
Who is the course for?
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 up to GCSE level or equivalent, as well as students and parents.
What software or tools do you need?
To take part in the course you will need to be able to download a files from the internet and either have access to the website sqliteonline.com or be able to install the application DB Browser
----------------------------------------------------------------------------------------
Endorsers and supporters
supported by
Comments
Post a Comment