Course GIK23M

Introduction to Relational Databases

7.5 Credits
First Cycle

Starts week 3, 2024

The overall goal of the course is that students shall acquire knowledge of principles and methods for designing and using relational databases.

After completing the course the student shall be able to:

Knowledge and understanding
  • explain the importance of normalisation when designing relational databases.
  • explain the importance of designing good identifiers for database tables.

Skills and abilities
  • use conceptual modeling and graphical description techniques for designing relational databases corresponding to the third normal form.
  • manipulate (search, add, modify and delete) data, and create, modify and delete database objects (tables, constraints, procedures, functions, triggers) using SQL and PL/SQL.
  • use normalisation to analyse, verify and modify a data model to meet the third normal form.


Starts and ends:
week 3, 2024 - week 22, 2024
Study Rate:
25%
Location:
Flexible (Borlänge)
Time of Day:
Mixed
Teaching form:
Distance
Language:
English
Entry Qualifications :
  • Fundamentals of programming 7,5 credits
Selection :
Higher education credits (1-165 credits)
Application Code:
HDA-V3HNH
Main field of study:
Online Education
Compulsory meetings:
0 physical
0 online
Computer Skills:

Surf on the Internet, read and send emails, use a word-processing programme (e.g. Word). Connect a camera and headphones to the computer and install a programme using instructions.

Computer Capacity:

Access to a computer (Not a mini pc, tablet or similar) that is not older than three years (or equivalent) and broadband connection, at least 1 Mbit/s (not mobile broadband, because mobile broadband can vary considerably in speed).

Means of Education:

Higher rate of web-based communication where our learning platform (Learn/Canvas) is a natural element of the course. Web-based meetings with sound and image where simple presentations can be held. Lectures can be broadcast live or can alternatively be made available afterwards online.

Tuition Fee
First Tuition Fee Installment:
16,875 SEK
Total Tuition Fee:
16,875 SEK
EU/EEA Citizens or exchange students are not required to pay fees.
Information on application and tuition fees: www.universityadmissions.se.
Closed for late application
Literature List

Literature lists are published at the latest one month ahead of the course start date.

To Literature List
How may we help you?

Ask us about studying at Dalarna University.
support@du.se
+46 23-77 88 88

Course room in Learn

In the learning platform Learn you can find more information about the course.

Visit the course room
Course Coordinator

Starts week 36, 2024

The overall goal of the course is that students shall acquire knowledge of principles and methods for designing and using relational databases.

After completing the course the student shall be able to:

Knowledge and understanding
  • explain the importance of normalisation when designing relational databases.
  • explain the importance of designing good identifiers for database tables.

Skills and abilities
  • use conceptual modeling and graphical description techniques for designing relational databases corresponding to the third normal form.
  • manipulate (search, add, modify and delete) data, and create, modify and delete database objects (tables, constraints, procedures, functions, triggers) using SQL and PL/SQL.
  • use normalisation to analyse, verify and modify a data model to meet the third normal form.


Starts and ends:
week 36, 2024 - week 3, 2025
Study Rate:
25%
Location:
Flexible (Borlänge)
Time of Day:
Mixed
Teaching form:
Distance
Language:
English
Entry Qualifications :
  • Fundamentals of programming 7,5 credits
Selection :
Higher education credits (1-165 credits)
Application Code:
HDA-H3K8F
Main field of study:
Online Education
Compulsory meetings:
0 physical
0 online
Computer Skills:

Surf on the Internet, read and send emails, use a word-processing programme (e.g. Word). Connect a camera and headphones to the computer and install a programme using instructions.

Computer Capacity:

Access to a computer (Not a mini pc, tablet or similar) that is not older than three years (or equivalent) and broadband connection, at least 1 Mbit/s (not mobile broadband, because mobile broadband can vary considerably in speed).

Means of Education:

Higher rate of web-based communication where our learning platform (Learn/Canvas) is a natural element of the course. Web-based meetings with sound and image where simple presentations can be held. Lectures can be broadcast live or can alternatively be made available afterwards online.

Tuition Fee
First Tuition Fee Installment:
16,875 SEK
Total Tuition Fee:
16,875 SEK
EU/EEA Citizens or exchange students are not required to pay fees.
Information on application and tuition fees: www.universityadmissions.se.
Apply
Open for late application
Literature List

Literature lists are published at the latest one month ahead of the course start date.

To Literature List
How may we help you?

Ask us about studying at Dalarna University.
support@du.se
+46 23-77 88 88

Course Coordinator