Aaron Cheng

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 […]

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).

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 […]

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 […]

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  […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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. […]

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 […]

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 […]