
Accessing data from program code
- Class 30
- Practice 30
- Independent work 90
Course title
Accessing data from program code
Lecture type
Obligatory
Course code
23-11-524
Semester
5
ECTS
5
Lecturers and associates
Course overview
This module introduces students to different ways of persisting data in SQL and NoSQL data storages from the application code.
This is the central module within the study program and provides students with knowledge and skills for other programming modules that students enroll in in the coming semesters. Acquired skills significantly contribute to the professional development of students in related professional fields.
The module is taught in the programming language C
. The final evaluation is based on individual student projects in which students create applications that use SQL and NoSQL databases in accordance with given specifications.
Content
Students will learn:
• overcome the differences between object-oriented programming languages and relational databases
• persist data in databases and materialize them as needed
• use object-relational mapping (ORM) frameworks to automate persistence and materialization processes
• apply the principle of convention before configuration
• what are the specifics of NoSQL databases and how to use them
• what are the specifics of unstructured data storage and how to use them
• how to use data sources in the Cloud.
Literature
1. Gorman, B.R. (2020) Practical Entity Framework: Database Access for Enterprise Applications. New York City: Apress.
2. Dayley B. (2014) NoSQL with MongoDB in 24 Hours. 1st edn. Carmel: Sams Publishing.
Additional reading
1. Shaikh K.A. (2020) Azure for .NET Core Developers: Implementing Microsoft Azure Solutions Using .NET Core Framework. 1st edn. New Delhi: BPB Publications.
Minimal learning outcomes
- Create a software solution using a relational database in the Cloud as a data source.
- Create a software solution using solutions for storing unstructured data in the Cloud as a data source.
- Create a software solution using a non-relational database in the Cloud as a data source.
- Select and implement the optimal conceptual data model.
- Implement a software solution using selected ORM tools.
Preferred learning outcomes
- Create a relational database in the Cloud and a software solution using that database as a data source.
- Create a database for storing unstructured data in the Cloud and a software solution using a solution for storing unstructured data in the Cloud as a data source.
- Create a non-relational database in the Cloud and a software solution using a non-relational database in the Cloud as a data source.
- Select and implement the optimal complex conceptual data model.
- Implement a complex software solution using selected ORM tools.