← Back

Category: Amelia's SQL TA notes

Intro

---

JOINs

---

Keys

---

First Normal Form

---

Physical Data Dependence

---

NULL Values

---

CREATE TABLE

---

INSERT, UPDATE, DELETE

---

HAVING

---

GROUP BY

---

Simple Aggregation

---

WITH

---

Witnesses

---

SELF JOIN Practice

---

Conceptual Database Design

---

Entity Relationship Diagram

---

Relationship

---

Weak Entity Sets

---

From ER Diagram to Relational Schema

---

Check Constraint

---

FK Constraints

---

Nested Queries

---

Row Number, Rank, Dense Rank