ITD 256: Week 6

• Watch a 30 minute video on life in the deep ocean ridges.

• Share join presentations and hopefully leave the process with a solid understanding of the different joins. To reiterate the requirements for this:

  1. Find an online tutorial showing the join statements that Dee discusses in In Orbit and which Kaleb shared in his presentation.
  2. Create a database on dbserver and create the tables in this database needed to illustrate your joins. Both of these should be in SQL scripts in your git repo. I suggest the names create_tables.sql and insert_data.sql respectively.

  3. Write another script named show_joins.sql that runs each of the following joins:

     • INNER JOIN
     • LEFT JOIN
     • RIGHT JOIN
     • FULL OUTER JOIN
     • CROSS JOIN
  4. Create a reveal.js presentation of your work on our vineland.local server.
• Begin working our way into the next chapter of A Curious Moon, Flyby.

NOTE: Join presentations are due by Friday, March 17th. One letter grade will be subtracted for each class period beyond that in which presentations are not ready.