| Statuss(Aktīvs) | Izdruka | Arhīvs(0) | Studiju plāns Vecais plāns | Kursu katalogs | Vēsture |
| Course title | Database Access Applications |
| Course code | InfT2034 |
| Credit points (ECTS) | 3 |
| Total Hours in Course | 81 |
| Number of hours for lectures | 16 |
| Number of hours for laboratory classes | 16 |
| Independent study hours | 49 |
| Date of course confirmation | 18/10/2022 |
| Responsible Unit | Institute of Computer Systems and Data Science |
| Course developers | |
| Mg. sc. ing., lekt. Jekaterina Smirnova Mg. sc. ing., lekt. Ingus Šmits |
|
| Prior knowledge | |
| DatZ1009, Introduction to Programming I DatZ1010, Introduction to Programming II InfT2033, Windows Programming |
|
| Course abstract | |
| The aim of the study course is to master the creation of application programs that use relational database technologies for data management, as well as to introduce students to various programming models for working with data sources and their use scenarios. Students are taught how to use active data objects for relational database data processing. As part of the course, scenarios of using active data objects for work in disconnected and connected mode are theoretically and practically examined. Students acquire practical skills in application programming for working with databases. | |
| Learning outcomes and their assessment | |
| As a result of the study course students:
•know about development applications for working with relational databases (laboratory work, independent work); •know how to code and debug programs, use good programming style, implement user interfaces, use data request languages (laboratory work, independent work); •are able to independently code and debug program calculations, and to perform data processing tasks, implement user interfaces without using database management systems (independent work). |
|
| Course Content(Calendar) | |
| 1. Connecting the program to the relational database - 2 hours
2. Reading data from the database - 2 hours 3. Adding, deleting and editing data in the database - 2 hours 4. A simple program for relational database data processing - 2 hours 5. Data transaction - 2 hours 6. Using the DataTable object - 2 hours 7. Using the DataAdapter object - 2 hours 8. Using the DataSet object and defining relations - 4 hours 9. Use of visual components for displaying and editing data - 4 hours 10. Binding data - 2 hours 11. Data selection and filtering - 2 hours 12. Dividing data into several windows - 2 hours 13. Work with recursive data structures - 4 hours |
|
| Requirements for awarding credit points | |
| Completed laboratory works and independently developed application with database. | |
| Description of the organization and tasks of students’ independent work | |
| During the semester, the student must complete the laboratory works using the assignment descriptions using consultation with the head of the laboratory work and the lecturer. The student must independently develop an application on the chosen topic, study literature and Internet resources. | |
| Criteria for Evaluating Learning Outcomes | |
| The exam grade is formed as an accumulative assessment from two parts - assessment of laboratory work (40%), assessment of independently developed application (60%). | |
| Compulsory reading | |
| 1. Chauhan C. PostgreSQL Cookbook. Birmingham: Packt Publishing, 2015. Pieejams: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=946187&site=ehost-live&scope=site
2. Juba S., Vannahme A., Volkov A. Learning PostgreSQL: Create, Develop and Manage Relational Databases in Real World Applications Using PostgreSQL. Birmingham: Packt Publishing. 2015. Pieejams: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1104912&site=ehost-live&scope=site 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: datubāzē EBSCO e-book academic collection https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1440572&site=ehost-live&scope=site |
|
| Further reading | |
| 1.C# Tutorial [tiešsasite]. Pieejams: https://www.w3schools.com/cs/index.php
2. Mehboob O., Khan A., Callaway J., Hunt C., Stephens R. Improving Your C# Skills: Solve Modern Challenges with Functional Programming and Test-driven Techniques of C#. 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ē https://search-ebscohost-com.ezproxy.llu.lv/login.aspx?direct=true&db=e000xww&AN=1446895&site=ehost-live&scope=site 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. | |