Skip to content

Database Management System (SQL and Tables Design)

Oscar Chan edited this page Dec 21, 2022 · 1 revision

In Django, we work with tables that hold user and website data. Designing them is an art, but hopefully, these resources help you get started on knowing not only what happens in the background, but also good tables design.

Videos are sourced from Summer 2020 Data 100

SQL (Important)

  • Lecture 4 - SQL (http://www.ds100.org/su20/lecture/lec4/)
    • Please look at videos: 4.2 to 4.5, 4.7 (for 4.7, start from 3:23 to end)
    • All the other videos are sort of out of scope for the needs of CompServ (theory stuff or stuff we most likely won’t use), but you are free to watch them (they are short luckily)
    • What to look for:
      • Conceptual idea of Tables (Relational Databases, Joining, NULL, and Subtables)
      • SQL understanding would be nice, but not required (but do note that Django (and Ruby on Rails) uses a SQL backend), and many SQL syntaxes exist on both Django and Ruby on Rails

Finger Exercises on SQL and Tables

Concentrate on: Table Operation Concepts (less on the SQL)

Multidimensional Data Model (Highly Recommended)

  • Lecture 25.2 - Big Data: Multidimensional Data Model
    • Lecture 25 link: http://www.ds100.org/su20/lecture/lec25/
      • ONLY 25.2!
      • Other videos are out of scope ENTIRELY for the needs of CompServ
    • Note the fact that we have Multiple Tables to relate certain information
    • If you are going to make potentially redundant info, like common identification, use another model

Tools for Database Management