CompSci 316: Introduction to Databases

Overview

This course intends to give you a solid background in database systems as well as managing and processing "big data" in general. Topics include data modeling, database design theory, data definition and manipulation languages (SQL, relational algebra, and NoSQL), database application programming interfaces, storage and indexing, query processing and optimization, parallel and distributed data processing, transaction processing, as well as a sample of other advanced topics.

Prerequisites:

CompSci 201 AND one of CompSci 210/250, or, consent of the instructor.

Time/Day

Lectures: Tuesdays and Thursdays, 1:25 pm - 2:40 pm, Bryan Center Griffith Theater

Discussion-01: Fridays, 10:05 am to 11:20 am, LSRC B101

Discussion-02: Fridays, 1:25 pm to 2:40 pm, Physics 128

Course Staff

Instructor

      Sudeepa Roy

Teaching Associate

      Violet Pang

Grad TAs

    Alex Chao, Zhuofan Jia, Fangzhu Shen, Owen Yang, Xuan Yang

UTAs

    David Bian, Camden Chin, Tony Cui, Miles Eng, Susan Feng, 

         Kelly Huang, Chris Kan, Ellie Kang, Lauren Pehlivanian, 

         Catherine Sernel, Philip Yi, Jay Yoon, William Zhou