Database Design & Development

Database Design & Development Theory Notes

Entity Occurrence Diagrams & Participation

Entity Relationship Diagrams

Data Dictionaries

DDL: Create

DDL: Constraints

DQL: Logical Operators

DQL: Having

DQL: Subqueries, ANY & EXISTS

You can download a complete set of notes below:

Data Definition Language Practical Tasks

Database Design

The Secrets of CREATE

An Empty Database Gathers No Customers

Presence & Primary Keyness

CHECKing out and AUTO INCREMENTing in

All of the Keys!

This Seems Familiar?

Data Query Language Practical Tasks

Data Import

NOT

BETWEEN

HAVING

IN

Subqueries

ANY 

EXISTS

You can download CSV files to import into your database below