CSC230-3 2019: Database Technologies for Analytics
Section outline
-
-
The syllabus contains links to online articles, references, and tutorials. Begin to explore these resources. Write a paragraph or two or three about something you find. Post it here.
-
On your own, view Jennifer Widom's "Introduction and Relational Databases" course. Register with a username and password here.
Begin working your way through the w3schools SQL Tutorial.
-
Write one, two, or three paragraphs about what you are learning. Elaborate the answers we shared to the questions that I presented in class and posted on Moodle. Or tell us how far you have gotten in the w3schools tutorial. Or take the role of teacher and share a lesson about relational algebra, drawing upon and summarizing what you learned from Professor Widom.
-
View Professor Widom's course on relational algebra.
-
Report on your progress on one or another of the online SQL tutorials. How far have you progressed thus far?
-
-
Find and share the answer to these questions during our morning meeting. Work with your classmates. Divide this work amongst yourselves.
-
Learn something interesting about Philip Greenspun, then use that knowledge to write a paragraph about Philip Greenspun.
-
Practice with joins.
-
Take some time to learn tools that can make you more productive before you begin your project.
-
For those who want to know more about how and why to use Mercurial...
-
If you are working to earn credit for a 300-level course this term, develop and demonstrate these additional skills.
-
-
-
Show us use cases for the Turing Award winners database that you are designing.
Show us a UML class diagram that describes a table in your design for the Turing Award winners database.
-
Some of these files are complete and some are not. They are works in progress. Take what is useful to you. Send me other files that you think might be useful to your classmates.
Buyer beware!
-
Read on the Web about indexing. Learn what this means, why it is important, and how we can create an index in MySQL. Write a paragraph or two, summarizing some of the important points and tell us where we can learn more.
-
The examination on Friday, November 8 will include questions that refer to these exercises. Study and understand the solutions to these problems. The best way to do this is at the computer.
-