Notes on database application programming; ODBC/JDBC connectivity, the Java Web persistence layer, PL/pgSQL functions and stored procedures, triggers, and cursors.
12 min read
Tags
- 7 writings
- since 2024
Spring ’24
Database design process and strategies, E-R model elements, entity relationship types, weak entities, CDM/LDM/PDM design, functional dependencies, normal forms, denormalization, and SQL implementation with Power Designer.
11 min read
SQL statement types and data types; DDL for databases, tables, and indexes; DML for insert, update, delete; DQL with sorting, grouping, subqueries, joins; and views.
6 min read
Relational model, relation tables, primary keys, foreign keys, compound keys, entity integrity, and referential integrity.
5 min read
Winter ’23/24
A database glossary covering structured, unstructured, and semi-structured data, plus relational and NoSQL data models.
4 min read
Database study notes. This post covers SQL functions and constraints.
7 min read
Database study notes covering core database concepts and basic SQL syntax, including DDL, DML, DQL, and DCL statements.
11 min read