SQL (PostgreSQL, SSMS), Excel, SqlDBM - ER modeling) PostgreSQL: CTE, views, window functions, subqueries, joins / except, create / insert, procedures / functions / triggers. Excel: pivot tables, vlookup, descriptive statistics, dispersion, percentiles, quartiles, hypothesis tests, t-test, z-test.