Understanding databases is an essential skill for information security professionals. In this hands-on lab, you will learn about relational databases and how to perform SQL statements.
Successfully complete this lab by achieving the following learning objectives:
- Create a Student Record
Create a student record for yourself, and assign yourself a 3.7 grade point average (GPA).
Get started by using the command:
Start MariaDB and access the database using the command:
Hint: Use the following command to see all the tables in the database:
Hint: Use the following command to see all the columns in a table:
- Identify Available Courses
coursestable, and find out which courses are available at the school.
- Find a Teacher’s Salary
Find the salary amounts for the teachers of courses
- Create a Teacher Record
Create a teacher record for a teacher named
tom pine, who is paid a salary of
- Update cs201
tom pineas the teacher of
cs201, using the
UPDATEstatement, and then add yourself to the course.