UC1PR210 Programming and Databases

Start semesters

UC1PR210 Programming and Databases

Course description
- NQF Level
  Bachelor's degree (Level 6 1. Cycle)
- Area of Study
  Computing
- Program of Study
  Computing 1. year
- ECTS
  10
- Campus
  Kristiansand, OnlinePLUS - Bergen, OnlinePLUS - Oslo, Online
- Course Leader
  Prof. Johan Van Niekerk

Introduction

Language of Instruction and assessment: English
May be offered on Campus and Online.
May be offered as a separate course.

Included in the following bachelor's degrees:

Applied Data Science
Digital Assurance and Security Management
Digital Forensics and Incident Response
Digital Forensics
Cyber Security

Course Aim(s)

This course aims to familiarize students with the principles of database design, construction, utilization, and maintenance. Students acquire knowledge in relational database design, SQL, and data manipulation techniques. They also develop practical skills in designing simple relational databases, extracting and manipulating data using SQL and programming code, and solving programming problems with precision and adherence to unit testing standards.

Course Learning Outcomes

Knowledge

The student has knowledge of

K1	relational database design.
K2	structured Query Language (SQL).
K3	data manipulation techniques using programming code and third-party tools.

Skills

The student gain skills in

S1	design and develop simple relational databases.
S2	extract and/or manipulate data using SQL and programming source code.
S3	solve programming problems in a precise, specification-oriented, approach according to defined unit testing standards.

General Competence

The student can demonstrate

G1	ability to solve problems independently.
G2	understanding business processes and the possible role of database systems within these processes.

Course Topics

Databases Key Concepts
Relational Database Systems
Introduction to Programming with Databases
Advanced Data Manipulation

Teaching Methods

Teaching will be based on a hybrid-flexible approach. Instructor-led face-to-face learning is combined with online learning in a flexible course structure that gives students the option of attending sessions in the classroom, participating online, or doing both.
All activities require active student participation in their own learning.
Learning delivery methods and available resources will be selected to ensure constructive alignment with course content, learning outcomes and assessment criteria.
Students will be taught using a mixture of guidance, self-study, and lecture material. Topics will be introduced in a series of weekly lectures. The guidance sessions will be directed practical exercises and reading in which students can explore topics with support from a teacher. This material will also require students to self-manage their time to ensure tasks are completed and the theory is fully understood. This will allow the students to fully engage with lectures and with their peers.

Resources and Equipment

Learning resources are available in the LMS and include, but is not limited to:
- literature and online reading material (essential and recommended)
- streams, recordings and other digital resources, where applicable
- video conferencing and communication platforms, if applicable
- tools, software and libraries, where applicable
Students must have access to an internet connection, and suitable hardware.
- Accessing live streams and virtual laboratories requires a minimum broadband connection of 2Mbps (4Mbps recommended).
Students working on their own laptop/computer are required to acquire appropriate communications software, a webcam, and headphones (or a similar alternative).

Prerequisite Knowledge

Refer to the entry requirements.

Reading List

The reading list for this course and any additional electronic resources will be provided in the LMS.

Study Workload

250 nominal hours.
Study workload applies to both Campus and Online students.

Activity	Duration
Teacher-led activity	33 Hour(s)
Teacher-supported work	48 Hour(s)
Self-study	169 Hour(s)

Work Requirements

There are no mandatory assignments in this course.

Assessment Strategy

This course has two (2) exams contributing towards the overall and final grade of the course.

All exams must be assessed as passed to receive the final Course Grade.

Form of assessment	Grading scale	Grouping	Duration of assessment
Portfolio of Work	A-F
Online Exam	A-F