HTTP

• Request vs Response
• Verbs:
  • Get vs Post
• URI
• Body

Intro to Web Services

• REST naming conventions

Javalin

• HTTP Hanlders
• Exception/Error Mapping
• WebSockets

Postman

Tools

• PostgreSQL
• Database administration
  • CLI, Client tool, IDE plugin

SQL: Structured Query Language

• Dialects, Vendors, Sublanguages
• Keys
  • Candidate
  • Primary
  • Composite
  • Foreign
• DCL: Data Control Language
  • Grant, Revoke
• DDL: Data Definition Language
  • Create, Alter, Drop, Truncate
• DML: Data Manipulation Language
  • Select, Insert, Update, Delete
  • DQL: Data Query Language
• TCL: Transaction Control Language
  • Commit, Rollback, Savepoint
• Select clauses
  • Where
  • Alias, And, Or
  • Subqueries
  • Joins
    • Inner
    • Outer
      • Left
      • Right
      • Full
      • Exclusive
    • Self
    • Cross
    • Natural
    • Equa vs. Theta
  • Set Operations
    • Union (ALL)
    • Intersect (ALL)
    • Except (ALL)
  • Group By, Having, Order By

RDBMS: Relational Database Management System

• Domain integrity
• Referential integrity
• ERD: Entity Relational Diagram
• Multiplicity
  • 1 to 1
  • 1 to many
  • many to 1
  • many to many
  • join (junction) tables
• Normalization
  • 1NF: Atomicity (No repeating attributes, Atomic values)
  • 2NF: Partial key dependencies
  • 3NF: Tansient(Non-key) dependencies
• ACID transactions
  • Atomic
  • Consistent
  • Isolated
  • Durable
• Transaction phenomenon
  • Dirty reads
  • Nonrepeatable reads
  • Phantoms
• Transaction isolation levels
  • Read uncommitted
  • Read committed
  • Repeatable Read
  • Serialization
  • Snapshot Serialization
  • MVCC

JDBC: Java Database Connectivity

• Set-up/Creating a Connection
• DriverClass, Connection
• Statement, PreparedStatement, Callable Statement
• ResultSet
• Design Pattern: Data Access Object
• Datasource: Properties, Environment Variables, JDBC URL

PL/pgSQL

• Function
  • Scalar
  • Aggregate
• Stored Procedure
• Cursors
• Index
• View
• Sequence
• Trigger