In Class Exercises
Please try using this code for joining two names (first name last name) into one cell:
=CONCATENATE(‘Source 2′!B2, ” “, ‘Source 2′!C2)
Please find answer keys for the MySQL in Assignment here. By the way, grades for this assignment were uploaded.
Please drop by my office if you still have ANY problems with writing MySQL queries to get out data/info. I am available for you guys most of the time even after office hours.
MySQL is very important and useful so I want to make sure all of you understand the basic principles.
Today we will be discussion extraction, transformation and loading of data from operational database to a data mart and then to a data cube,
after the lecture we will spend about 30 minutes on a group discussion on ETL: finding factors that have an effect on Amazon book sales.
The group discussion file is here.