Database Schemas
-
LAB: Watch me configure a MySQL database to store Online Transactional Processing data
In this lab, I was required to design a database schema, create a database to store sales data based on sample data, create an index on the timestamp column and write an administrative bash script that exports sales data into a SQL file.