OPIM 5272 Business Process Modeling and Data Management

Course Title: OPIM 5272 Business Process Modeling and Data Management
Type: Required course
Term/Time: Spring 2017 / Wednesdays 1:00 - 4:00 pm
Instructor: Xinxin Li
Teaching Assistant: There was a TA hosting office hours to answers students' questions before each exam, but I didn't meet this TA, so I don't know who he/she was.
Overall Rating: 4 out of 5 stars
Knowledge/Skills Gained: Teamwork, SQL, Visio, ER Diagram, Business Process, etc.
Summary: The instructor's teaching style was very clear and straightforward. The course basically contained two parts--business process modeling and SQL. The first half was about business process modeling, and students would learn how to use Visio to draw E-R diagram for a business process. The second half was all about fundamental SQL. It wasn't an easy subject. Students lost points easily if not paying careful attention to details.

========================================================================

If you already have working experience with SQL, the second half of this class would be pretty easy for you. However, if you, like me, have zero exposure to business process and SQL prior to this class, you would learn a lot from this course via challenges. I highly recommend students without any related experience spend a decent amount of time studying this subject. This is not an easy A class unless you already have SQL experience before.

Although this course was challenging to me, I learned a lot from this class! Honestly speaking, I am not a big SQL fan, so I actually enjoyed the first half of the course more than the second half. Nonetheless, I was fortunate in a great team, so we had fun with our project. You can take a look our project proposal to have a sense about what kind of projects you will do for this class.

SQL was a little challenging for me because I was totally new to this coding language. One of my friends said that SQL's logic was more similar to a computer than a human. I don't know whether or not this statement is true given that SQL has been widely used in many industries for many years. However, compared to R and Python, I did feel that I had difficulties to understand SQL's coding logic. Therefore, I spent a great amount of time studying SQL.

In summary, if you don't have any experience in business process modeling or SQL, this subject will be challenging. Yet you will learn a lot from this course if you study hard. The instructor's teaching style is very clear and straightforward. If you don't understand anything, just ask the instructor.

PS. If you install the required SQL software on a Mac laptop for this class, it works for general functions for the most of time. Unfortunately, Mac doesn't support SQL in some tiny functions. For the sake of time efficiency, when you need to run any SQL code, run it on a laptop with Windows environment. This is especially important when you need to do the group project together.

Comments

Popular Posts