This course provides balanced coverage of database use and design,focusing on relational databases. Students will learn to design relational schemas, write SQL queries, access a DB programmatically,and perform database administration. Students will gain a working knowledge of the algorithms and data structures used in query evaluation and transaction processing. Students will also learn to apply newer database technologies such as XML, NoSQL, and Hadoop.
Final Project
For the final project of this course, our team did a database technology investigation on Google’s BigQuery. This involved writing a report on BigQuery, discussing its architecture and comparisons to a traditional RDBMS. We also produced a video presentation, which includes a short demo on upserting data in BigQuery with the Python SDK.
The code for the tech demo is available on GitHub: