INFO20003 Database Systems Revision Workshop

Опубликовано: 01 Ноябрь 2024
на канале: CISSA

167

Database Systems Revision Workshop!
Presented by Lucy Martin

0:00 - Set up
6:57 - Introduction
9:12 - ER Modelling
27:27 - ER Modelling: Example
39:50 - Relational algebra
53:11 - SQL
53:49 - SQL: Keywords
55:20 - SQL: Types of joins
1:02:50 - SQL: Subqueries & set operations
1:04:17 - SQL: Unary joins & aliases
1:06:27 - SQL: Case study
1:19:10 - Query optimisation
1:26:55 - Query optimisation: Example
1:51:15 - Normalisation
1:59:30 - Transactions
2:02:04 - Distributed DBs
2:02:53 - No SQL

🩵follow us🩵
Instagram:   / cissa_unimelb
TikTok:   / cissa.unimelb
LinkedIn:   / cissa-unimelb
Discord:   / discord
Facebook:   / cissa.unimelb
Linktree: https://linktr.ee/cissa_unimelb

Become a CISSA Member! (it's free!!): https://umsu.unimelb.edu.au/buddy-up/...

https://cissa.org.au/

____________________________________________________

Tags
#cissa #unimelb #melbourne #compsci #tech #club