Lessons (5)
In this lesson, we will explore the key terminology required to be able to use SQL to search and update a relational database. Together we will step through the key concepts using a music database as an example. We will complete the lesson by gaining some hands on experience of using a database management system.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will use the music database from the previous lesson, 'Database essentials', to write our first SQL commands to access and manipulate the data.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will explore INSERT, UPDATE, and DELETE queries, before being given the opportunity to implement these queries using our music database.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
1 Slide deck
1 Worksheet
1 Quiz
1 Video
In this lesson, we will use our SQL skills to build, interrogate, and update a database to manage swimming lessons.
1 Slide deck
1 Quiz
1 Video