Course code

IFI6052.DT

old course code

IFI6052

Course title in Estonian

Andmebaasi võrguliidesed

Course title in English

Interface Development for Database

ECTS credits

4.0

Assessment form

Examination

lecturer of 2024/2025 Autumn semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

lecturer of 2024/2025 Spring semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

Course aims

The objective of the course is to give an overview of the Oracle database and SQL commands, to present a possibilities for java front end creation with JDeveloper, to introduce different libraries, such as JDBC, Enterprise JavaBeans and ADF. To support practical skills formation for java interface creation.

Brief description of the course

Datamodels. Concepts of relational database. Oracle Enterprise Manager. SQL commands. PL/SQL. Databases and Java. Java beans. Component usage in Java Front End creation. Oracle JDBC drivers. JDBC API. Web applications. Oracle Application Server and Java WEB Toolkit. Every student must prepare homework (java application), complete 75% of course tasks given during classes, pass test and exam.

Learning outcomes in the course

Upon completing the course the student:
Student is able to create databases and views using Oracle Database, has knowledge of database administration. Student can use SQL commands and create the java Front End for data visualization and management using as JDBC, Enterprise JavaBeans and ADF.

Teacher

dotsent Erika Matsak

Prerequisite course 1

Basic Course in Programming (IFI6069.DT)

Study programmes containing that course

Computer Science (IFIFB/13.DT)
Computer Science (IFIFB/12.DT)
Computer Science (IFIFB/11.DT)
Teacher of Computer Science (IFIOM/12.DT)
Computer Science (IFIFB/10.DT)
Teacher of Computer Science (IFIOM/11.DT)
Computer Science (IFIFB/09.DT)
Teacher of Computer Science (IFIOM/10.DT)
Computer Science (IFIFB/08.DT)
Computer Science (IFIFB/00.DT)