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.
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 […]
Aaron Cheng wrote a new post, Setting up MySQL Workbench Before Week 4 (the week of 9/17), on the site MIS 2502 Data Analytics (Fall 2018) 1 year 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, Assignment #1: ER Modeling [Due Monday, 9/17/18 at 11:59 pm], on the site MIS 2502 Data Analytics (Fall 2018) 1 year 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 […]
Below is the agenda for Week 3.
Relational Data Modelling and ERD
ICA #1.2: Creating an entity relationship diagram (ERD)
Notes: In ICA #1.2, we will use […]
Hope you had a great weekend and labor day!
Below is the agenda for Week 2.
Relational Data Modelling and ERD
ICA (In-Class Activity) #1.1: Identifying entities and […]
Aaron Cheng wrote a new post, Using ERDPlus to Creat Entity Relationship Diagrams (ERD), on the site MIS 2502 Data Analytics (Fall 2018) 1 year 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. […]
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 […]
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 […]
You can post a welcome message about your class as the first post. Include your picture.
You can make this post ‘sticky’ if you want it to stay at the top. To make a post sticky:
Go to the Dashboard, click on […]
How to get this template
If you are viewing this site on the URL:http://community.mis.temple.edu/coursetemplate, then you are looking at the results of our course template. To use this course template, do the […]
Jetpack is a collection of widgets created by the people who run WordPress.com. It includes widgets for:
Social sharing (so you can have the LinkedIn and Facebook like […]
- Load More