-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 10 months ago
I will hold an additional office hour on Friday, 12:30 pm to 1:30 pm.
Note the location is Alter 604F (a breakout room).
Please drop by if you have any questions about SQL queries, or Assignment […] -
Aaron Cheng's profile was updated 5 years, 10 months ago
-
Aaron Cheng's profile was updated 5 years, 10 months ago
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 10 months ago
Submission deadlines for ICA #2.2 and Assignment #2 are extended.
See the following NEW due dates and times:
ICA #2.2: Wednesday, 9/26/18, 6:50 pm.
Assignment #2: Friday, 9/28/18, 3:00 pm (before the class).
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 10 months ago
Class Schedule:
Monday (9/24) ICA #2.2 – Working with SQL, part 1 (Retrieving information from the database)
Wednesday (9/26) Creating and updating the database (SQL CREATE, DROP […] -
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
SQL advanced queries are the most difficult ones in this course.
If you want to master SQL, you need to pay more attention, take more efforts, and do more practices.
I attached the SQL queries examples […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Here are the instructions: Assignment #2 – SQL Part 1.
And here is the answer sheet: [Answer Sheet].
Due date: Wednesday, 9/26/2018, 11:59 pm.
Complete and submit the answer sheet as a Word […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
There is a bonus credit assignment about creating schemas. It is optional. This is worth an additional 30% toward your Assignment #1 grade, if you choose to do it. Here are the instructions: Bonus Credit […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Below is the agenda for Week 4.
Monday (9/17):
Getting Data out of a Database
Notes: Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL powerpoint […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
As Assignment 1 is due next Monday, 9/17, here are some additional resources to get help:
1. I hold regular office hours on Mondays and Wednesdays between 3:50 and 4:50 pm, in Speakman 201F. If you have a quick […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around September 19, 2018.
(1) If you’re using your own computer (Windows or Mac), you’ll need to […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Here are the instructions for Assignment#1: ER Modeling.
Use ERDPlus to complete the assignment.
You must submit a single Microsoft Word or PDF document (if you send multiple files, you will not get cre […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Dear all,
Below is the agenda for Week 3.
Monday (9/10):
Relational Data Modelling and ERD
ICA #1.2: Creating an entity relationship diagram (ERD)
Notes: In ICA #1.2, we will use […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Dear all,
Hope you had a great weekend and labor day!
Below is the agenda for Week 2.
Wednesday (9/5):
Relational Data Modelling and ERD
ICA (In-Class Activity) #1.1: Identifying entities and […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Starting from next Friday, September 7, we will learn how to create Entity Relationship diagrams (ERDs) to model databases.
To create ERDs, we will use ERDPlus, a free tool that is quite easy to use. […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 11 months ago
Please take a couple of minutes to complete this optional survey: MIS 2502 Survey: Get to know your background by August 28 (the day before the 2nd class). This is for me to know a bit about you so that I can […]
-
Aaron Cheng wrote a new post on the site MIS 2502 Data Analytics (Fall 2018) 5 years, 12 months ago
Dear students,
Welcome to MIS2502 Data Analytics! This site will host the coursework for Section 003, by Aaron Zhi Cheng.
Please note that we will use this site to post up-to-date materials such as […]
-
Aaron Cheng's profile was updated 6 years, 5 months ago
-
Aaron Cheng changed their profile picture 6 years, 5 months ago
-
Aaron Cheng's profile was updated 6 years, 5 months ago
- Load More