Credits: 6

Schedule: 13.09.2019 - 22.10.2019

Teacher in charge (valid 01.08.2018-31.07.2020): 

Visiting teacher Kevin Craig

Contact information for the course (applies in this implementation): Lecturer: Yong Liu <yong.liu@aalto.f>
Course assistant: Fan Wenjie <>

Teaching Period (valid 01.08.2018-31.07.2020): 

I period Autumn, III Spring (2018-2019) Otaniemi campus

I Autumn (2019-2020) Otaniemi campus

V period intensive course 2019-2020

Learning Outcomes (valid 01.08.2018-31.07.2020): 

The student taking this course learns about data management using database language – MySQL. Students are expected to become skillful with manipulating different kinds of business data for different types of business analytics. Data manipulation and data management skills are necessary prerequisites for being able to use business analytics.

Content (valid 01.08.2018-31.07.2020): 

This course provides students with a comprehensive overview of MySQL. Core MySQL commands, skills and examples of applying MySQL to really-life business analytics are the key content. A number of databases are provided as the materials to practice the database language and skills. Hands-on sessions provide the opportunity to practice MySQL with the assistance of lecturer.

Assessment Methods and Criteria (valid 01.08.2018-31.07.2020): 

50% Exam
50% Assignment

Elaboration of the evaluation criteria and methods, and acquainting students with the evaluation (applies in this implementation): 

Exam: 50%

Big assignment: 50%

One must pass the exam in order to get a grade.

The big assignment will be interesting but also challenging. 

Workload (valid 01.08.2018-31.07.2020): 

Lectures & excercises 38 h
Independent work 119 h
Exam 3 h presence

Details on calculating the workload (applies in this implementation): 

Exercises can be mostly done during hands-on sessions especially at the first stage of the course. It may demand a few extra hours to do exercises after class at the later stage of the course.

Big assignment demands lots of time and critical thinking - it is a good training for having a analytical mind.

Study Material (valid 01.08.2018-31.07.2020): 

Key course materials will be offered by the lecturer.

Details on the course materials (applies in this implementation): 

Course materials, including lecture slides, database files and exercise materials, will be available at MyCourse.

Course Homepage (valid 01.08.2018-31.07.2020):

Prerequisites (valid 01.08.2018-31.07.2020): 

No prerequisite for participating in the course.
Students with no programming background can attend the course.

Grading Scale (valid 01.08.2018-31.07.2020): 


Registration for Courses (valid 01.08.2018-31.07.2020): 

Via WebOodi. A maximum of 70 participants will be admitted to the course.

Further Information (valid 01.08.2018-31.07.2020): 

A maximum of 70 participants will be admitted to the course.
1. Aalto ISM MSc students (i.e. who have graduated as B.Sc.)
2. Aalto Analytics and Data Science minor students
3. Master's Programme in ICT Innovation (EIT digital) and Master's programme in Information Networks students
4. Other Aalto MSc students
5. Aalto ISM BSc students
6. All other students

Exam will be organized on Friday 29 May. Exact time will be informed later. There will be a lunch pause between the lectures.


Registration and further information