CSC230-3 2021: Database Technologies for Analytics
Section outline
-
-
Here's some music that I like. I offer it to you in the hopes that you'll enjoy it, too. The song is right for this season!
-
Look for the answers to these questions in the article titled "Orders of magnitude (data)" on Wikipedia.
-
LinkedIn Learning
-
CBT Nuggets
-
Lucid Chart
-
by Susan Harkins and published on the April 2, 2003 by TechRepublic
-
from IBM's 100 Icons of Progress, a part of the company's celebration of its centennial anniversary
-
I offer this resource to the computer science majors who might want more programming challenges.
-
I offer this resource to the computer science majors who might want more programming challenges.
-
I offer this resource to the computer science majors who might want more programming challenges.
-
I offer this resource to the computer science majors who might want more programming challenges.
-
This is a CSV (Comma Separated Values) file.
-
This PDF document contains links to web pages that you will need to answer today's questions.
-
Read Chapter 16 (normalization, "I'm Okay, You're Abnormal") in Philip Greenspun's SQL for Nerds. Also, read Chapters 4, 5, and 6 in Head First SQL.
-
-
-
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.
-
-
-
More than 40 years ago, a German band with Caribbean members produced this English language disco song about a part of Russian history. This cover of the song comes from the Czech Republic (Czechia). Learn more here.
-
Length of video: 7:37
-
Length of video: 11:17
-
Length of video: 6:22
-
This is a tutorial article from the IBM Cloud Learn Hub.
-
The Oracle Corporation produced this article.
-
In 256 to 512 words, summarize the main points of one of the papers that MongoDB has published on its website.
-
Complete this SQL script. This file is also on the server (cs1.cornellcollege.edu) in the instructor's home folder.
-
-
-
The the man playing the accordion and singer are husband Jack Conte and wife Nataly Knutson (stage name, Nataly Dawn). Jack is co-founder and CEO of Patreon, an Internet company. The two met at Stanford University. Nataly sings in both English and French. This is a traditional Russian song, translated to French (although she does say "dark eyes" in Russian).
-
Use this script to create the database for the exercise on Monday, November 8. That exercise calls for you to write queries on this database.
-
Write queries on the matchmaker database that meet the specifications contained in this SQL script.
-