Software

Oracle SQL Developer

• Windows 64-bit with JDK 8 included (20.4)
• Windows 32-bit/64-bit (20.4)

Oracle JDBC

• Oracle Database 12c Release 1 (12.1.0.2): ojdbc7.jar, ojdbc6.jar, ucp.jar

CASE modelling software

• Oracle data modeler 19.1.0.081.0911 (direct link)
• Toad data modeler. Available as trial version for one month or as full version for 6 months (in the case of student licence).

Commerce software

Software available at the server 158.196.98.43 (OS Windows Server). If you want to use it for the education, write the request to address michal.kratky@vsb.cz. Server is available by Remote Desktop Connection.

• SQL Data Generator - data generator for SQL Server.
• Stylus Studio - IDE including set of tools for work with XML (XQuery, XML Pipeline, XSLT, XSL:FO, XML Schema/DTD, XPath, and so on).

Access to database servers

• Connection String pro ODAC:
  • dbsys.cs.vsb.cz: "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsys.cs.vsb.cz)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oracle.dbsys.cs.vsb.cz)));User Id=xyz;Password=xyz;"
• Connection String pro MS SQL:
  • dbsys.cs.vsb.cz: "server=dbsys.cs.vsb.cz\STUDENT;database=xyz;user=xyz;password=xyz;"