Lecture 14: Intro to SQL, Retrieving Data from DB

Recording

Class was not held in person on this day. See edstem announcement for details.

Link to recording:
https://usc.zoom.us/rec/play/xWvs-0P-v5gcbYgnM-KPuLLCpjmOsnn1MsUAMRjXpFQU7Jzb0_O9Q1mnEFWVpxhKgu8c2tZsXolOIGY.j1Fa_IxLbbgdkwhj

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