Creating the Student Database
To begin with, we need to create a job seekers database database to store information about students. We can use SQL commands to create a new database by executing the following query:
CREATE DATABASE StudentDatabase;
Next, we need to create a table within the database to store student information such as student ID, name, age, gender, and course. We can execute the following query to create a student table:
To retrieve information from the student database, we can use the SELECT statement in SQL. For example, to retrieve the names of all students in the database, we can execute the following query:
Updating Data in the Student Database
If we need to update the information of a specific student in the database, we can use the UPDATE statement in SQL. For instance, to update the age of a student with the StudentID of 2, we can execute the following query.