Databases@FCSE

Databases@FCSE News

World News

Student DB Projects

Related Links

Learning and Practice Web-sites

SQL exercises - not used as part of the courses since 2018

https://www.w3schools.com/sql/default.asp - not used as part of the courses since 2018

Open-source Modeling Software

TerraER - "An open-source modeling tool designed to support students in the creation of ER models that reflect exactly the data modeling concepts learned in the classroom."

  • The Materials/Software section includes a special version for use in classes and homework assignments

DBeaver - "Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc."

  • The Materials/Software section includes a special package customized for use in FCSE computer labs (this version is outdated, but should still work)

Modelio - "An open source modeling environment supporting the main standards: UML, BPMN, MDA, SysML, ..."