Please note! Course description is confirmed for two academic years, which means that in general, e.g. Learning outcomes, assessment methods and key content stays unchanged. However, via course syllabus, it is possible to specify or change the course execution in each realization of the course, such as how the contact sessions are organized, assessment methods weighted or materials used.

LEARNING OUTCOMES

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.

Credits: 6

Schedule: 15.09.2021 - 20.10.2021

Teacher in charge (valid for whole curriculum period):

Teacher in charge (applies in this implementation): Yong Liu

Contact information for the course (applies in this implementation):

CEFR level (valid for whole curriculum period):

Language of instruction and studies (applies in this implementation):

Teaching language: English. Languages of study attainment: English

CONTENT, ASSESSMENT AND WORKLOAD

Content
  • valid for whole curriculum period:

    This course provides students with a comprehensive overview of MySQL. MySQL commands, 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 for whole curriculum period:

    In academic year 2020-2021: Assignment 100% In academic year 2021-2022: 100% Assignments

Workload
  • valid for whole curriculum period:

    12*2 hours lecture = 24 hours

    preparation for lectures = 20 hours

    assignment and exercises = 116 hours

DETAILS

Study Material
  • valid for whole curriculum period:

    Course book: Pratt, P.J. & Last, M.Z. (2006). A guide to MySQL, Thomson.

Substitutes for Courses
Prerequisites

FURTHER INFORMATION

Further Information
  • valid for whole curriculum period:

    Maximum 200 student is admitted to the course.

    Priority is given to:

    1. BSc students majoring in ISM

    2. Exchange students and CEMS students

    3. Other Aalto students


    Teaching Period:

    2020-2021 Autumn I

    2021-2022 Autumn I


    Course Homepage: https://mycourses.aalto.fi/course/search.php?search=ISM-C2002


    Registration for Courses: In the academic year 2021-2022, registration for courses will take place on Sisu (sisu.aalto.fi) instead of WebOodi.