-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all, please see the link to class capture today.
LINK.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all,
We will be having our second exam on Monday June 17th. Please mark the date! If you have not come to class today, please review the class capture about ETL procedure (merging tables and standardizing […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all,
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 […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all,
Please see assignment 4 here. It is due by June 15, Friday. Please hand in a printed copy, or a hand-written one (legible!)
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all, please watch the class capture here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
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 […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi All,
Please find slides for MySQL 1 here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please see class capture today here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please download the lecture notes here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please see link here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi all,
Please see the assignment here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please see the exercise here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi, Please find the lecture notes (slides) for MySQL 2 here.
I will try to post lecture notes before class.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Please find the answer here.
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
use moviedb;
select * from actor;
select * from actor where actor.first_name=’Ed’;
select * from film;
select count(*) from film where rating=’PG-13′;
select length from film where […]
-
Kevin Yili Hong wrote a new post on the site Course Blog on Data Analytics 12 years, 4 months ago
Hi here is the exam study guide you can refer to when reviewing for the first exam.
Please bring up any questions you have.
Download here.
We also have some sample exam questions, that you may want […]
-
Kevin Yili Hong commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site Course Blog on Data Analytics 12 years, 4 months ago
Nicole you are actually getting into the idea of “sets” in the query, the correct way to do it is follows:
SELECT * FROM `order` WHERE order_id IN (101,102, 103); so it is an “IN” clause. Please try different […]
- Load More