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: 09.09.2020 - 14.10.2020
Teacher in charge (valid 01.08.2020-31.07.2022): Yong Liu
Teacher in charge (applies in this implementation): Yong Liu
Contact information for the course (valid 17.08.2020-21.12.2112):
Lecturer: Yong Liu
- Email: yong.liu@aalto.fi
Course Assistant 1: Wenjie Fang
- Email: wenjie.fan@aalto.fi
Course Assistant 2: Yanqing Lin
- Email: yanqing.lin@aalto.fi
CEFR level (applies in this implementation):
Language of instruction and studies (valid 01.08.2020-31.07.2022):
Teaching language: English
Languages of study attainment: English
CONTENT, ASSESSMENT AND WORKLOAD
Content
Valid 01.08.2020-31.07.2022:
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 01.08.2020-31.07.2022:
In academic year 2020-2021:
Assignment 100%
In academic year 2021-2022
Exam: 50%
Big assignment: 50%
Autumn 2020
Assignments: 100%
Applies in this implementation:
Given that it is difficult to have physical examination this year, we will have only one big assignment for the course.
Workload
Valid 01.08.2020-31.07.2022:
12*2 hours lecture = 24 hours
preparation for lectures = 20 hours
assignment and exercises = 116 hours
Applies in this implementation:
Online lectures = 6*2hours
Online hands-on sessions = 6*2hours.
DETAILS
Study Material
Valid 01.08.2020-31.07.2022:
Course book: Pratt, P.J. & Last, M.Z. (2006). A guide to MySQL, Thomson.
Applies in this implementation:
Course materials, including both lecture slides and hands-on session materials, are sufficient. Reading course book is optional for those who are interested.
Substitutes for Courses
Valid 01.08.2020-31.07.2022:
37E01600 Data Resources Management
Prerequisites
Valid 01.08.2020-31.07.2022:
Students with no programming background can attend the course.
Registration for Courses
Valid 01.08.2020-31.07.2022:
maximum 90 students will be elected to the course.
Priority is given in following order:
1. Students with ISM major
2. Exchange and CEMS students
3. Students with ISM minor
4. Other Aalto students
5. Other studentsApplies in this implementation:
FURTHER INFORMATION
Further Information
Valid 01.08.2020-31.07.2022:
Priority is given in following order:
1. Students with ISM major
2. Exchange and CEMS students
3. Students with ISM minor
4. Other Aalto students
5. Other studentsApplies in this implementation:
Details on the schedule
Applies in this implementation:
Lecture time:
Start date End date Date During 09.09.20 14.10.20 WED 08:30-10:00 Please note: the lecture will start at 08:30sharp!
Hands-on sessionStart date End date Date During 09.09.20 14.10.20 WED 10:15-12:00 Please note:
1. We will have two course assistants help you online during the hands-on sessions, when you have questions.
2. If you have any problem during the hands-on seession, it would be easier if you could share your screen (MySQL interface) with lectuer or course assistant. Please make sure you know how to properly share screen using Zoom.
- Teacher: Liu Yong