Lecture 14: Intro to SQL, Retrieving Data from DB

To-do for today’s class

• Download song.sql.
• Login to cPanel and create a new database named username_song_db
• Download and install the latest MySQL Workbench if you haven’t already: https://dev.mysql.com/downloads/workbench/.
• Refer to below EER diagram of Song Database.

Slides

Link to download PDF version of slides.

Completed Files

• 12pm: https://github.com/nayeonk/itp303-fall-2021-12pm/tree/main/lect14/
• 4pm: https://github.com/nayeonk/itp303-fall-2021-4pm/tree/main/lect14