EBA 3420 Databases

EBA 3420 Databases

Course code: 
EBA 3420
Department: 
Economics
Credits: 
7.5
Course coordinator: 
Christian Brinch
Product category: 
Bachelor
Portfolio: 
Bachelor of Business Analytics - Programme Courses
Semester: 
2020 Spring
Active status: 
Active
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

.

Required prerequisite knowledge

Np spesific prerequisites is required. 

Exam categoryWeightInvigilationDurationSupport materialsGroupingComment exam
Exam category:
Submission
Form of assessment:
Written submission
Exam code:
EBA 34201
Grading scale:
ECTS
Grading rules:
Internal examiner
Resit:
Examination every semester
70No 2 Week(s)Group (1 - 3)
Exam category:
Submission
Form of assessment:
Written submission
Exam code:
EBA 34202
Grading scale:
ECTS
Grading rules:
Internal and external examiner
Resit:
Examination every semester
30Yes2 Hour(s)
  • Bilingual dictionary
Individual
Exams:
Exam category:Submission
Form of assessment:Written submission
Weight:70
Invigilation:No
Grouping (size):Group (1-3)
Support materials:
Duration: 2 Week(s)
Comment:
Exam code:EBA 34201
Grading scale:ECTS
Resit:Examination every semester
Exam category:Submission
Form of assessment:Written submission
Weight:30
Invigilation:Yes
Grouping (size):Individual
Support materials:
  • Bilingual dictionary
Duration:2 Hour(s)
Comment:
Exam code:EBA 34202
Grading scale:ECTS
Resit:Examination every semester
Type of Assessment: 
Ordinary examination
Total weight: 
100
Student workload
ActivityDurationComment
Teaching on Campus
36 Hour(s)
Other in classroom
36 Hour(s)
Problemsolvinng in class using SQL
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.