EBA 3420 Databases

EBA 3420 Databases

Course code: 
EBA 3420
Department: 
Data Science and Analytics
Credits: 
7.5
Course coordinator: 
Magdalena Ivanovska
Course name in Norwegian: 
Databases
Product category: 
Bachelor
Portfolio: 
Bachelor of Data Science for Business - Programme Courses
Semester: 
2022 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

Higher Education Entrance Qualification

Covid-19

Due to the Covid-19 pandemic, there may be deviations in teaching and learning activities as well as exams, compared with what is described in this course description.

Teaching

Information about what is taught on campus and other digital forms will be presented with the lecture plan before the start of the course each semester.

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)
Comment: 
All exams must be passed to obtain a final grade in the course.
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)
Comment: 
27/09/2022 Please note that re-sit examination autumn 2022 will be arranged as a home exam, 2 hours.
All exams must be passed to obtain a final grade in the course.
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
42 Hour(s)
Seminar groups
30 Hour(s)
Problemsolving 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.