- A Cloud Guru
Performing SQL Commands in MariaDB
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.
Table of Contents
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
tom pineas the teacher of
cs201, using the
UPDATEstatement, and then add yourself to the course.
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.