Recording from February 11th, 2016 Session

Version 1

    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