title: setting up a database for tracking which users have clicked which links?
body: <p>I'll try and elaborate on my problem a bit more.</p>
  
  <p>I recently got an entry-level part time developer position with my university, in efforts to sharpen my dev skills. While I have used MySQL in the past, it was only briefly covered in a single course, as I am mostly a front end guy (HTML/CSS/JS).</p>
  
  <p>Anyways, the department that hired me has a website designed for incoming students, to get them acclimated to college. It has tutorials and videos for them to watch, etc. In order to access the site, they must log in to their university account (which uses LDAP). Account names are in the format of abc1234. </p>
  
  <p>Now, my problem is I need to create a way for the staff to track which tutorials/videos the freshman have watched. They would like me to do this using databases. There will potentially be thousands of students, and they want to be able to see exactly which students have / have not clicked each link/watched each video.</p>
  
  <p>How should I set up databases for this? There will be multiple links/tutorials/videos that they want to track. Bonus points if there was a way of tracking which users watched the videos through to the end, however not required.</p>
  
  <p>I believe I will need to use PHP for handling the exchange between the browser and the database, correct?</p>
  
  <p>Thank you for any helps or tips. :)</p>