-
Notifications
You must be signed in to change notification settings - Fork 16
Home
This wiki is for the Fall 2022 W4111 extra credit assignment.
The purpose of this open-ended extra credit assignment is for you to learn a database-adjacent technology, and create a tutorial that highlights its main concepts. In this way, you can teach the rest of your classmates something interesting.
Each technology will have a separate wiki page, and added to the following list. Up to 5 students can work together to write the wiki page for a given technology, and each person's contributions must be made clear at the top of the page (see template).
Although you will learn the technology by reading its documentation and tutorials, and using the technology, everything that you write and create should be completely original content for this extra credit assignment. If you wrote code in another project or class, then it is not original content.
It is probably a good idea to discuss your idea with Professor Wu during his office hours.
To submit, simply create a new Wiki page and edit it. No edits will be accepted after 12/9 11:59PM EST.
Extra credit can range from 0% to >3% of the total class grade. It is in your interest to make it easy for the staff to determine what you contributed. Since this is the first time we have done this, grading is subjectively determined by the staff based on:
- accuracy and conciseness of the text,
- how clearly the text and example builds on and relates to concepts we learned in W4111, and
- how easy the tutorial is to follow.
- (see template for more notes on the structure of the tutorial)
Remember, what you write should be completely original content for this extra credit assignment. If you wrote text/code in another project or class, then it is not original content.
Add links to tutorial pages here. When you add a new page, you should follow the template.
- Template
- Your Technology Here
- PostGIS
- Apache Kafka
- Kafka
- Clickhouse
- Microsoft SQL Server 2019 Transact SQL
- RDF Graphs and SPARQL Queries
The following is a partial list of technologies you can study. Technologies can be advanced SQL/database functionalities, databases, or data products. You can, and are encouraged to, create tutorials for technologies not listed below.
Database inspired
Data Tools
- The Datasette data multi-tool
- Ibis
- Prisma
- Great Expectations
- DBT (beyond project 2)
- Hex
- sqldiff
- Superset
- Apache Calcite Open Source Optimizer
- Kafka
- Apache Arrow
SQL Features/Extensions
- SQL Window Functions
- SQL foreign data wrappers
- PostGis
- In-DB machine learning
DBMSes/Query Engines
Scalable Pandas
Your idea (good idea to check with Professor Wu first)!