Laajuus: 6

Aikataulu: 10.01.2018 - 13.02.2018

Vastuuopettaja (voimassa 01.08.2018-31.07.2020): 

Liu Yong

Opetusperiodi (voimassa 01.08.2018-31.07.2020): 

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

I Autumn (2019-2020) Otaniemi campus

Osaamistavoitteet (voimassa 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.

Sisältö (voimassa 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.

Toteutus, työmuodot ja arvosteluperusteet (voimassa 01.08.2018-31.07.2020): 

50% Exam
50% Assignment

Työmäärä toteutustavoittain (voimassa 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

Oppimateriaali (voimassa 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.

Kurssin kotisivu (voimassa 01.08.2018-31.07.2020): 

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

Esitiedot (voimassa 01.08.2018-31.07.2020): 

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

Arvosteluasteikko (voimassa 01.08.2018-31.07.2020): 

0-5

Ilmoittautuminen (voimassa 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.

Lisätietoja (voimassa 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

Opintojakson kuvaus