IB Computer Science - Option A (Databases) - SL + HL

Need to cram? Buy my Option A Study Guide + Slides here: ($3.99): https://csclassroom.gumroad.com/l/opt...

Check out the Option A Supplement here (with some additional content):    • IB Computer Science - Option A (Datab...  

Also, check out my:
HL Paper 1 Cram Guide ($5.99): https://csclassroom.gumroad.com/l/ibc...
SL Paper 1 Cram Guide ($2.99): https://csclassroom.gumroad.com/l/ibc...
Paper 3 Guide ($2.99): https://csclassroom.gumroad.com/l/ibc...

Join the Discord:   / discord  
Insta:   / cs_classroom  

00:00 - Intro
01:01 - Data vs. Information
02:00 - Databases (Description and Purpose)
06:52 - Data Verification vs. Validation
08:01 - Entities
09:37 - Primary Keys
10:37 - Foreign Keys
12:10 - Data Types
13:30 - Practical Example - Creating a Table with SQL
14:37 - SQL Queries
20:16 - Secondary Key
21:15 - Candidate Key
21:35 - Composite Primary Key
22:20 - Database Schema
23:21 - Relational Databases
24:07 - Referential Integrity
25:05 - Database Management Systems
25:43 - DBMS Components
26:55 - Data Dictionaries
28:24 - Concurrency
29:27 - DBMS & Security
30:44 - Database Transactions
33:41 - ACID
36:00 - Data Integrity
38:00 - Data Redundancy
39:54 - Intro to Normalization
41:58 - Overview of Normal Forms (1NF, 2NF, 3NF)
50:50 - Normalization Steps for IB Problems
53:10 - IB Normalization Example #1
1:01:10 - IB Normalization Example #2
1:05:32 - IB Normalization Example #3
1:11:01 - IB Normalization Example #4
1:18:06 - Normalization Wrap Up & Advantages
1:21:06 - Anomalies (Insertion, Deletion, Update)
1:25:00 - Database Administrators
1:27:17 - Data Definition Language (DDL)
1:28:50 - Data Modeling (Conceptual, Logical, Physical)
1:32:37 - ERDs (Entity Relationship Diagrams)
1:36:10 - HL Intro
1:36:36 - Object-Oriented Databases
1:45:36 - Data Warehouse
1:48:21 - ETL (Extraction, Transformation, Loading)
1:49:51 - Data Warehouse vs. Database
1:52:01 - Data Mining
1:53:27 - Cluster Analysis
1:54:47 - Classification
1:56:29 - Cluster Analysis vs. Classification
1:57:43 - Association Analysis
1:59:33 - Link Analysis
2:01:12 - Deviation Detection
2:02:30 - Spatial Databases
2:03:55 - Data Segmentation
2:05:21 - Wrap Up