Data modelling; systems databases and tables; data definition; retrieving data; retrieving data (advanced topics); modifying data; indexes; using views, defaults and rules programmability; triggers; replication; application development and Open Data Systems (ODS); practice exam 1; practice exam 2.