Week 2
Section outline
-
-
Germany has 16 states. Mecklenburg-Vorpommern is in the northeast corner of the country. It lies on the Baltic Sea, has numerous lakes, and contains several national parks. I visited this region a few years ago. I want to go back. "Urlaub" means vacation. At the end of this short film you will see the words "bis bald." That means "see you soon."
-
We will be working with this database this week.
-
John Aaron was just a few years older than most of you are now when he helped save the astronauts of Apollo 13. A few months before, he also saved Apollo 12. He knew his piece better than anyone and he was not afraid to speak up.
-
Margaret's studied at a college like ours. She paid attention to details!
-
This example will help you understand the several kinds of joins.
-
Find articles on the Internet. Write a sentence or two about what we will find in these articles.
- Is normalization always necessary? always desirable? sometimes undesirable?
- Are there alternatives to relational databases? What are they?
-
Create a small database, practice with joins and aggregate functions.
-
Here is a SQL script that creates a database of waterfalls in Michigan's Upper Peninsula and challenges you to write several queries.
-
This article from Microsoft defines some important terms that we heard in Professor Nenad Jukic's Zoom presentation on Wednesday, October 27. Can you find other short articles or videos that will increase our understanding of ideas that Professor Jukic shared with us?
-
In this part of the exercise, you will show that you know how to join two tables.
-
In this part of the exercise, you will share some of what you have learned through our discussions and your reading.
-