GUI client:
VB, Access; prototypes
Java, JDBC, JDBC-ODBC, JBuilder;
VB-Access - ODBC
text based;
Web access: forms, dynamic pages, (ASP, JSP)
functional design: usability, use-case
Architecture:
small DBMS: Access, DataStore;
client-server; multi-tier;
Oracle structure;
parrellel (Teradata systems)
DBMS:
mathematical models (relational algebra);
SQL
schema definitions: ER, OO, SQL
schema design: ED, FD & normalization; usability,
use-case,
optimizations: views,
transactions vs queries; locks..
DBA:
job roles;
access, permissions, roles;
monitoring, tuning,