Omfattning: 6

Tidtabel: 13.09.2019 - 22.10.2019

Ansvarslärare (är i kraft 01.08.2018-31.07.2020): 

Liu Yong

Kontaktuppgifter till kursens personal (gäller denna kursomgång): Lecturer: Yong Liu <yong.liu@aalto.f>
Course assistant: Fan Wenjie <wenjie.fan@aalto.fi>

Undervisningsperiod (är i kraft 01.08.2018-31.07.2020): 

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

I Autumn (2019-2020) Otaniemi campus

Lärandemål (är i kraft 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.

Innehåll (är i kraft 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.

Metoder, arbetssätt och bedömningsgrunder (är i kraft 01.08.2018-31.07.2020): 

50% Exam
50% Assignment

Närmare information om bedömningsgrunderna och -metoderna och om hur den studerande kan ta del av bedömningen (gäller denna kursomgång): 

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. 




Arbetsmängd (är i kraft 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

Preciserad belastningsberäkning (gäller denna kursomgång): 

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.

Studiematerial (är i kraft 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.

Närmare information om kursmaterial (gäller denna kursomgång): 

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

Kursens webbplats (är i kraft 01.08.2018-31.07.2020): 

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

Förkunskaper (är i kraft 01.08.2018-31.07.2020): 

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

Bedömningsskala (är i kraft 01.08.2018-31.07.2020): 

0-5

Anmälning (är i kraft 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.

Tilläggsinformation (är i kraft 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

Beskrivning

Anmälning och tillläggsinformation