Day 4: Database and MySQL

This section includes the needed material to install, configure, and use MySQL database.

Readings

Practice

  • Create demo schema/database using MySQL Workbench.

  • Create students table with the following fields: id, name, average, email.

  • Using Workbench, write and execute the following on the students table:

    • INSERT statement that inserts a record in the student table

    • UPDATE statement that updates a record in the student table by ID

    • DELETE statement that deletes a record from thr student table by ID.

    • SELECT one record by ID

    • SELECT many records where average more than a value.