BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

1Data versus information
2Records, fields, and datasets
3Persistent storage versus process memory
4Files versus database management systems
5Database engines versus database servers
6Database instances versus databases
7Schemas versus stored data
8Metadata and system catalogs
9Operational databases versus analytical databases
10Relational database systems
11Document database systems
12Key-value database systems
13Wide-column database systems
14Graph database systems
15Embedded versus client-server databases
16Database workloads and access patterns
17Relations, tuples, and attributes
18Tables, rows, and columns
19Domains and attribute values
20Relation cardinality and degree
21Unordered rows in the relational model
22Set semantics versus SQL bag semantics
23Candidate keys
24Primary keys
25Alternate keys
26Composite keys
27Surrogate keys versus natural keys
28Foreign keys and referential integrity
29Entity integrity
30Relational closure
31Relational algebra selection
32Relational algebra projection
33Relational algebra union
34Relational algebra Cartesian product
35Codd's relational model
36System R and the origins of SQL
37ANSI SQL and ISO SQL standards
38Declarative versus imperative queries
39SQL dialect compatibility
40DDL statements
41DML statements
42Transaction control statements
43Privilege management statements
44PostgreSQL release numbering
45SQLite release and file compatibility
46Choosing a database for a personal library
47Reading a relational schema diagram
48Mapping a spreadsheet to related tables
49Identifying keys in a school enrollment dataset
50Separating application validation from database integrity

Databases & SQL

1Data versus information
2Records, fields, and datasets
3Persistent storage versus process memory
4Files versus database management systems
5Database engines versus database servers
6Database instances versus databases
7Schemas versus stored data
8Metadata and system catalogs
9Operational databases versus analytical databases
10Relational database systems
11Document database systems
12Key-value database systems
13Wide-column database systems
14Graph database systems
15Embedded versus client-server databases
16Database workloads and access patterns
17Relations, tuples, and attributes
18Tables, rows, and columns
19Domains and attribute values
20Relation cardinality and degree
21Unordered rows in the relational model
22Set semantics versus SQL bag semantics
23Candidate keys
24Primary keys
25Alternate keys
26Composite keys
27Surrogate keys versus natural keys
28Foreign keys and referential integrity
29Entity integrity
30Relational closure
31Relational algebra selection
32Relational algebra projection
33Relational algebra union
34Relational algebra Cartesian product
35Codd's relational model
36System R and the origins of SQL
37ANSI SQL and ISO SQL standards
38Declarative versus imperative queries
39SQL dialect compatibility
40DDL statements
41DML statements
42Transaction control statements
43Privilege management statements
44PostgreSQL release numbering
45SQLite release and file compatibility
46Choosing a database for a personal library
47Reading a relational schema diagram
48Mapping a spreadsheet to related tables
49Identifying keys in a school enrollment dataset
50Separating application validation from database integrity

← Databases & SQL

Search the Databases & SQL glossary

Lesson 2 of 2,478·1. Database FoundationsFree lesson

Records, fields, and datasets

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy