# Start MySQL Instance
$ systemctl start mysql.service
# Connect to the MySQL Instance
$ mysql -u<USERNAME> -p<PASSWORD>
- Fork this repository
- Make sure you have access to a running mySQL server, either on your laptop or on Digital Ocean
- For every exercise in this Workshop:
- Create a new file named "exercise-n.txt", containing:
- The SQL Statement used, when applicable
- The SQL Statement results, when applicable
- Create a new file named "exercise-n.txt", containing:
- Connect to the MySQL instance
- Create a database named
decodemtl_test
within MySQL - Create a database named
decodemtl_addressbook
within MySQL
- Remove database named
decodemtl_test
from MySQL
- Return the list of databases within MySQL
- Create table
Account
for databasedecodemtl_addressbook
- Create table
AddressBook
for databasedecodemtl_addressbook
- Create table
Entry
for databasedecodemtl_addressbook
- Create table
Test
for databasedecodemtl_addressbook
- Remove table
Test
for databasedecodemtl_addressbook
- Return list of tables within database
decodemtl_addressbook
- Reflect the data model shown in
schema/addressbook_denormalized.png
within databasedecodemtl_addressbook
Account.id
is a primary auto-increment keyAddressBook.id
is a primary auto-increment keyEntry.id
is a primary auto-increment keyEntry.type
is an ENUM column permittinghome
,work
andother
Entry.subtype
is an ENUM column permittingphone
,address
andemail
- Create a data model representing a Barn with Chickens ๐ฃ
- This model should provide answers to the following questions:
- How many rooster, hen and chicks existed in the Barn on a specific date
- How many chicks will come to age on a specific date
- Create a data model representing a Hotel with Floors and Rooms ๐จ
- This model should provide answers to the following questions:
- The list of Rooms available for rent on a specific date
- The list of Rooms which can be occupied by at least 3 people on a specific date
- The amount of unrentable Rooms (janitor closets, public laundry room, gym, etc.)
- The amount of Rooms having a private Kitchen
- The average amount of windows per Floor
- The amount of Floors having Rooms with carpets