Schedule: 13.09.2019 - 22.10.2019
Teacher in charge (valid 01.08.2018-31.07.2020):
Contact information for the course (applies in this implementation): Lecturer: Yong Liu <email@example.com>
Course assistant: Fan Wenjie <firstname.lastname@example.org>
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):
Elaboration of the evaluation criteria and methods, and acquainting students with the evaluation (applies in this implementation):
Big assignment: 50%
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
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.
Course book: Pratt, P.J. and Last, M.Z. (2005). A guide to MySQL, Thomson. It is not compulsory to read the course book.
Details on the course materials (applies in this implementation):
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. 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
- Teacher: Yong Liu