Wednesday, December 17, 2014

SQL Review

I started reviewing and it's all pretty easy to understand except for a few things I had to review like "referencing". I kind of forgot how to import the files though and I don't think I ever documented that so I have to figure that out...

Movie Database
  • This file is for the actual creation of the database
  • Primary keys are unique values
  • When a value is referenced it is simply a value being supplied from another table

Movie Database Data
  • This was the actual data for the database, it's all very straightforward



Posted by at

1 comment:

  1. jelknerJanuary 11, 2015 at 1:58 PM

    I think I heard somewhere that the third time you learn something you never forget it, so this is the 2nd time you've learned SQL. One more time and its yours for life! ;-)

    The cool thing here is that you will now be using it in a customer driven application, so you'll get to see how it fits in with the web technologies we are learning.

    ReplyDelete

Subscribe to: Post Comments (Atom)