Study Guide

Objective

The student can perform practical database modeling.
The student can program applications in multi-user environments that read and write relational databases.
The student can use a framework for database programming.

Content

Rehearsal of SQL
Database applications with SqlServer, C # and ADO.NET
Objects of the type: Connections Commands, Parameters and DataReaders
Transaction Management
Objects of the types: DataSets, DataAdapters and CommandBuilders
Object Relational Mapping (ORM)
Introduction to LINQ and Entity Framework
Data in xml and json format.

Qualifications

Courses: Object Oriented Programming, Database Technology

Assessment criteria, satisfactory (1)

The student understands the basic theories of the relational model and can realize a relational model as a physical database.
The student can program simple database applications that read and write a database, and can use parameterized commands.
The student knows a framework for reading and writing databases.

Assessment criteria, good (3)

The student can create simpler conceptual, logical and physical database models.
The student can program database applications using Object Relational Mapping.
The student can implement transaction management in his code.
The student knows about security risks and knows how the risks are handled in program code.
The student can use a framework to read and write databases.

Assessment criteria, excellent (5)

The student can create advanced conceptual, logical and physical database models.
The student can encode different types of applications that reuse code for data management.
The student can use a framework for versatile reading and writing of databases.

Materials

Material on Moodle.