Latviešu Krievu Angļu Vācu Franču
Statuss(Aktīvs) Izdruka Arhīvs(0) Studiju plāns Vecais plāns Kursu katalogs Vēsture

Course title Database Access Applications
Course code InfT2035
Credit points (ECTS) 1.5
Total Hours in Course 40.5
Independent study hours 40
Date of course confirmation 19/11/2022
Responsible Unit Institute of Computer Systems and Data Science
 
Course developers
Mg. sc. ing., lekt. Ingus Šmits

Prior knowledge
InfT2034, Database Access Applications
Course abstract
The aim of the course work is to apply, strengthen and expand knowledge about the creation of application programs that use relational database technologies for data management, as well as knowledge about various programming models for working with data sources and their use scenarios. Students have the opportunity to use active data objects for relational database data processing. Students apply and develop acquired practical skills in application programming for working with databases.
Learning outcomes and their assessment
As a result of the study course students:
•are able to demonstrate theoretical knowledge of creating applications for working with relational databases (program, program documentation, coursework defence);
•are able to define the purpose and tasks of the course work, choose and use the most appropriate methods in its development (program documentation)
•know how to code and debug programs, use good programming style, implement user interfaces, use data request languages (program); •are able to independently code and debug program calculations, and to perform data processing tasks, implement user interfaces without using database management systems (program, program documentation, coursework defence).
Course Content(Calendar)
1. Selection of the topic of the course work and coordination with the supervisor. 2h
2. Preparing the database and connecting the program to the relational database. 8h
3. Program development. To perform data processing tasks, user interface implementation. 21h
4. Developing, designing and making the necessary corrections of the program documentation. 8h 5. Defence of the course work. 1h
Requirements for awarding credit points
Submitted and defended course work.
Description of the organization and tasks of students’ independent work
The student must develop the course work independently, using the advice of the responsible teaching staff, study literature and Internet resources.
The coursework must include:
• program • program documentation
Criteria for Evaluating Learning Outcomes
The grade of the course work is formed from three parts - evaluation of the program (40%), evaluation of documentation (40%), defence and answers to questions (20%).
Compulsory reading
1. Chauhan C. PostgreSQL Cookbook. Birmingham: Packt Publishing, 2015. Pieejams: EBSCO e-book academic collection
2.Learning PostgreSQL: Create, Develop and Manage Relational Databases in Real World Applications Using PostgreSQL. Birmingham: Packt Publishing, 2015. Pieejams: EBSCO e-book academic collection
3. Dombrovskaya H., Bailliekova A., Novikov B. PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries. 1st ed. APress, 2021. 319 p. Pieejams: LBTU ITF bibliotēka 4. Posadas M. Mastering C# and .NET Framework. Birmingham: Packt Publishing. 2016. Pieejams: EBSCO e-book academic collection
Further reading
1.C# Tutorial [tiešsasite]. Pieejams: https://www.w3schools.com/cs/index.php
2. Improving Your C# Skills: Solve Modern Challenges with Functional Programming and Test-driven Techniques of C#. O. M. A. Khan, J. Callaway, C. Hunt, R. Stephens. Birmingham: Packt Publishing, 2019. 589 p.
3. Angorro W. Functional C#. Birmingham, UK: Packt Publishing. 2017. 365 p. EBSCO e-book academic collection datubāzē 4..NET Documentation [tiešsaiste]. Pieejams: https://learn.microsoft.com/en-us/dotnet/
Periodicals and other sources
•EBSCO e-book academic collection. Pieejams: https://web-p-ebscohost-com.ezproxy.llu.lv/ehost/search/selectdb?vid=0&sid=8715372b-5e1d-4646-9ecc-530bf329861f%40redis
Notes
Compulsory course in Computer Science and Computer Science and Information Technology for Sustainable Development.