. "Other Data Management (rather Than Geospatial Data Architecture And Management) Kas"@en . . . . . . . . . . . . . . . "Database practice"@en . . "2" . "The course aims to develop the practical skills in SQL language application. The course includes both theoretical and practical parts. Each theoretical theme is reinforced with appropriate practical work. Examples are demonstrated and exercises are solved in a database management system Microsoft SQL Server 2017 and Transact SQL syntax. Tasks of the study course: 1. To acquire knowledge about Microsoft SQL Server architecture, functionality and data storage organization. 2. To learn Transact-SQL language. 3. To learn how to use Microsoft SQL Server tools for database creation, management and maintenance. The language of instruction is Latvian.\nResults Knowledge 1. is familiar with MS SQL Server concepts. (eb11, eb12) 2. tells about SQL Server architecture, functionality and data storage organization. (eb11, eb12) Skills 3. working in practice with MS SQL Server Management Studio tool, uses tool graphical interface features, as well as write commands in Transact-SQL language. (eb31, eb33, eb35) 4. uses MS SQL Server for database design and management. (eb31, eb33, eb35) 5. practically create and configure database objects, understand the objectives of the different types of indexes and operating principles of integrity constraints, implement the business functionality as triggers, stored procedures and functions, manage the database transactions and perform backup and restoration. (eb31, eb35, eb55) Competence 6. has practical experience in database management, builds databases according to requirements (eb31, eb33, eb35)" . . "Presential"@en . "FALSE" . . "Bachelor in Geoinformatics"@en . . "https://www.lu.lv/en/studies/study-process/courses/programme-search/?tx_lustudycatalogue_pi1%5Baction%5D=detail&tx_lustudycatalogue_pi1%5Bcontroller%5D=Course&tx_lustudycatalogue_pi1%5Bprogram%5D=21126&cHash=6f3dcba1688f6f3c1f0a12bd4f0d0313" . "243"^^ . "no data"@en . "KNOWLEDGE\r\n1. Understand the most important concepts and regularities in the field of natural sciences (natural and human geography, remote sensing, geodesy and cartography) and geoinformatics;\r\n2. Demonstrate typical basic and specialized knowledge in geoinformatics-related work fields, know geospatial data, standards and legal issues in the field of geoinformatics.\r\n\r\nSKILLS\r\n3. Perform professional activities in geoinformatics, independently obtain, formulate and analytically describe information, problems and solutions in geoinformatics, explain them and offer reasoned opinion in the discussion with both specialists and non-specialists;\r\n4. Critically analyse geoinformatic technologies, theories and problems;\r\n5. Demonstrate a scientific approach to problem solving, take responsibility and initiative in individual or team work, make decisions and find creative solutions in changing or uncertain circumstances.\r\n\r\nCOMPETENCE\r\n6. Independently obtain, select and analyse information and use it, make decisions and solve problems in geoinformatics, explain them and discuss them with specialists and non-specialists; develops solutions for the practical application of technology;\r\n7. Understand the problems and requirements of professional ethics in the field, assess the impact of their professional activity on the environment and society and participate in the development of the relevant professional field."@en . . "4"@en . "FALSE" . . . "Bachelor"@en . "Thesis" . "2800.00" . "Euro"@en . "3100" . "None" . "highly qualified geoinformatics specialists who are competitive in both the local and international labor market."@en . "no data" . "TRUE" . "Downstream"@en . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .