EBA 3420 Databases
EBA 3420 Databases
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.
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.
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).
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.
- 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.
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.
.
Np spesific prerequisites is required.
| 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:
Duration: 2 Hour(s) Exam code: EBA 34202 Grading scale: ECTS Resit: Examination every semester |
All exams must be passed to get a grade in this course.
| Activity | Duration | Comment |
|---|---|---|
Teaching | 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. |
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.