MIS2502.003 - Spring 2023

We will work on an ICA in class today.  I will also reference the current slide deck on SQL.

See you in class!

-Shafer

Hello all!

I’ll start class today by returning your ICA to you and discussing some of the answers I saw there.

Then we’ll begin the “SQL Advanced” slide deck.

On Wednesday we will work on ICA #3 and you will need MySQL Workbench for that.

-Shafer

Hello all,

In class today we will continue to learn more about the SQL language. Following along with workbench will be very advantageous.

We will pick up with our exploration of SQL aggregate functions (MAX, MIN, AVG, SUM, TOTAL)

Please also recall that Assignment 1 (announced this past Friday) is due Monday 2/6, at 11:59 PM.

-Shafer

Hello all,

In class today we will continue to learn more about the SQL language.  Following along with workbench will be very advantageous.

Please also recall that Assignment 1 (announced this past Friday) is due Monday 2/6, at 11:59 PM.

-Shafer

 

In class on 1/27 I will go over to some of the student work I received for ICA #1.  

I will then:

1. Announce your first assignment.
2. Begin the SQL Part 1 lecture material

See you in class.

-Shafer

If you are stuck installing MySQL Workbench … there are senior MIS students at the MIS Helpdesk For Coding who can help you.

To get help from them, please see the following:

https://community.mis.temple.edu/coding-help-desk/ 

Hello everyone,

I’ll start our next class with a *very* quick summary of the slides we didn’t get through last time.  I will not go over each of those remaining slides in detail, but I encourage you to do so and reach out to me with any questions! 

Most of our time will be spent working on the in-class activity.  I think this is a more effective way to learn the material (e.g. we learn best by doing, not by watching PowerPoint slides!)

Please come to class with MySQL Workbench installed and have your laptops out and ready to go when class begins.

-Shafer

 

Hello everyone,

Welcome to week #2.  🙂

I will start class with a quick overview of what to expect this week, and then present the material on “Relational Data Modeling”

-Shafer

Hello everyone,

Here are some notes from last time… things that you should be doing outside of class:

1. Getting MySQL Work Bench installed.
2. Watching the LinkedInLearning video “Learn SQL Programming” with Scott Simpson

In class today I will present to you “The Information Architecture of an Organization” 

See the class schedule for the power point slides.

-Shafer

Hello everyone!

Here’s what we will do today (day 1!)

• Introductions and roll call
• Course intro
• Presentation: “The things you can do with data”

-Shafer

Additional note: Your database credentials can be found here on the MIS Community site. See the MIS Community Gradebook.