Recording from February 11th, 2016 Session

Document created by ia24214 on Jul 27, 2016
Version 1Show Document
  • View in full screen mode

Hello all,

 

Here's the link that contains the Recording Session from February 11th, 2016.

 

https://sas.elluminate.com/mr.jnlp?suid=M.AC15CACDA30EB121B3DE5F5153573C&sid=2011010

 

Summary of ASR Group Meeting Feb 11, 2016:

 

Bill Vilberg from University of Miami presented a simple SQL query that can be utilize to show specific courses (i.e. Accounting) in a specific semester/term.

 

SQL Query:

select cm.COURSE_ID

from course_main cm

where cm.COURSE_ID like 'ACC%20161';

 

The above query can be manipulated to only show courses with specific items such as Course Banners:

select cm.COURSE_ID

from course_main cm

where cm.COURSE_ID like 'ACC%20161'

and banner_url is not null;

 

Additional queries that were covered today can be found in: https://www.dropbox.com/s/yl9nhmilcpzcbzu/ASRvilberg.docx?dl=0

 

They also provided us with a helpful query to generate a Course Tool Report here: http://pastebin.com/09xGe0Cx

Attachments

    Outcomes