EBA 3420 Databases

EBA 3420 Databases

Course code: 
EBA 3420
Department: 
Economics
Credits: 
7.5
Course coordinator: 
Mass Soldal Lund
Course name in Norwegian: 
Databases
Product category: 
Bachelor
Portfolio: 
Bachelor of Data Science for Business - Programme Courses
Semester: 
2021 Spring
Active status: 
Active
Level of study: 
Bachelor
Teaching language: 
English
Course type: 
One semester
Introduction

A hands-on introduction to using SQL-databases will be given. Throughout the course, we use dynamic web-pages as an example application, which allows us to work through data extraction from databases, data input from webpages, as well as how to present data from databases through online pages showing key numbers and graphs. A blended learning-by-doing approach will be taken throughout the course. While the course will use web analytics as an application, this is more of an example application, and though this application is of practical importance in itself, the course focus is more general: The course aims at being a general introduction to applied work with databases, illustrated through a simple application-field. This means that for example web-page design will be kept to an extreme minimum, and the technical focus will be instead on themes that are of general value in the industry.

Learning outcomes - Knowledge

During the course students shall:

  • Acquire understanding of how information moves from one data-source to another.
  • Learn how to think in terms of data storage and applications, as well as getting an overview of the possibilities and limitations a company has when working with data stored in external systems. 
Learning outcomes - Skills

After completed course students will be able to:

  • Do basic work with an SQL-database, connect databases with applications such as web-pages, and develop basic applications that use SQL-like databases.
  • To connect a programming language (here: python) with a database language (here: SQL).
General Competence

The course will strengthen the analytical abilities of the students. The course will further improve the students' abilities in central 21st century skills, especially information literacy. The students will also gain an understanding of how the modern information driven society functions from a technical perspective, and how databases underlie the media and communication revolution we are now seeing. The students will gain experience working in teams on technical problems, and will understand the possibilities and risks associated with digitally stored information as they will gain hands-on experience on how easy it now is to process, extract and present individual-level details from vast datasets.

Course content
  • An introduction to SQL
  • The basics of dynamic and user-specific web-pages, implemented using Python and SQL.
  • Basic SQL usage of specific importance for web-pages: user databases, page information, collecting usage statistics, and in general dynamic content generation.
  • Collecting data from web surveys, including usage statistics and similar information.
  • Learn to create online presentations with key numbers and graphs.
Teaching and learning activities

The course consist of 45 hours and will be a combination of lectures combined with web-resources, and a high emphasis on student projects done under supervision.

Software tools
Software defined under the section "Teaching and learning activities".
Additional information

.

Qualifications
Required prerequisite knowledge

Np spesific prerequisites is required. 

Assessments
Assessments
Exam category: 
Submission
Form of assessment: 
Written submission
Weight: 
70
Grouping: 
Group (1 - 3)
Duration: 
2 Week(s)
Exam code: 
EBA 34201
Grading scale: 
ECTS
Resit: 
Examination every semester
Exam category: 
Submission
Form of assessment: 
Written submission
Invigilation
Weight: 
30
Grouping: 
Individual
Support materials: 
  • Bilingual dictionary
Duration: 
2 Hour(s)
Exam code: 
EBA 34202
Grading scale: 
ECTS
Resit: 
Examination every semester
Type of Assessment: 
Ordinary examination
All exams must be passed to get a grade in this course.
Total weight: 
100
Student workload
ActivityDurationComment
Teaching
36 Hour(s)
Seminar groups
36 Hour(s)
Problemsolving in class using SQL

Ved godkjenning av studieplanen med utkast til kursbeskrivelser, Undervisningsutvalget 27.09.2018, sto om dette kurset følgende om ressursbruk:

"Blended learning, with a few lectures/web-resources, but with a high emphasis on student projects done under supervision. Note this requires more teaching resources than standard lecturing, but is absolutely necessary: there is not much theory, the emphasis on the course is on doing".

Godkjent av Dean Lars Olsen 23.04.2019.
Student's own work with learning resources
86 Hour(s)
Examination
42 Hour(s)
One group asssignment and an individual written exam. Approxemately 42 hours in total.
Sum workload: 
200

A course of 1 ECTS credit corresponds to a workload of 26-30 hours. Therefore a course of 7,5 ECTS credit corresponds to a workload of at least 200 hours.