Credits: 6

Schedule: 10.01.2018 - 13.02.2018

Teacher in charge (valid 01.08.2018-31.07.2020): 

Liu Yong

Teaching Period (valid 01.08.2018-31.07.2020): 

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

I Autumn (2019-2020) Otaniemi campus

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

Workload (valid 01.08.2018-31.07.2020): 

Lectures = 12 h
Hands-on sessions = 12 h
Preparation for lectures = 12 h
Assignment and exercises = 121 h
Exam 3 h presence
Total 160 h

Study Material (valid 01.08.2018-31.07.2020): 

Key course materials will be offered by the lecturer.
Course book: Pratt, P.J. and Last, M.Z. (2005). A guide to MySQL, Thomson. It is not compulsory to read the course book.

Course Homepage (valid 01.08.2018-31.07.2020): 

https://mycourses.aalto.fi/course/search.php?search=37E01600

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): 

0-5

Registration for Courses (valid 01.08.2018-31.07.2020): 

Via WebOodi. A maximum of 70 participants will be admitted to the course. Given an insufficient amount of PCs available in the computer lab, participants are encouraged to bring their own laptop for the hands-on sessions.

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

Description