Subject number:

Subject name:

Subject type:

Semester

obligatory
or
optional

general
or
professional

3038

Data access from the program code

Obligatory

Professional

5.

ECTS

Lectures

Exercises

Standalone work

Total

5

30

30

90

150

Lecturers and associates

Marko Petričević, dipl.ing., prof.; Bojan Fulanović, dipl.ing.

Aim of the subject

Students should be familiar with the methods and technologies to access data from the programming code, and especially competitive access to data.

Knowledge and skills

Students will acquire knowledge required for connecting to various types of databases using different technologies and mechanisms.

Lectures content

Formatting data access applications, Connecting to databases, Retrieval of data using T-SQL language, Using stored procedures to access and modify data, Using transactions, Work in offline environment, Programmatic control of offline data, Creating and using XML to work with data, Creating and using Web services for data access.

Exercises content

Laboratory:

Exercises consist of solving various tasks on the computer to reinforce knowledge gained during the lectures. The exercises are: Connecting to a database, Retrieval of data from the database, Changing data in the database, Using stored procedures, Using transactions, Retrieving offline data, Modifying offline data, Using XML methods, Creating web services, Using web services, JDBC. Database Application Building Concepts. SQL.

Delivery of

Lectures

Exercises

Teaching material is delivered through lectures accompanied by computer presentations and many examples.

Laboratory exercises:

Exercises consist of solving ready-made tasks on computers in Microsoft and Java development environment.

Knowledge assessment

Laboratory exercises, written tests

Final exam

MINIMUM LEARNING OUTCOMES

1. To use related way of work with data in  ADO.NET
2. To use JDBC for work with data in Java applications
3. To use  unrelated way of work with data in ADO.NET
4. To use Data Access Application Block (DAAB) to access data in.NET applications
5. To apply Visual Study tools to access data in .NET applications
6. To describe the use of XML to store data
7. To use Entity Framework environment to access data

DESIRED LEARNING OUTCOMES

1. To compare different mechanisms of related way of work in ADO.NET-u
2. To compare data access mechanisms using JDBC in Java applications
3. To come up with the best way of using data in unrelated way of work in ADO.NET
4. To compare data access with or without using DAAB in .NET applications
5. To compare tool and programme data access in .NET applications
6. To come up with the best way of using ASP.NET and Windows Forms of data-relational data access controls
7. To use XML for data storage