Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Production Reporting vs Reporting Instance
  • Permissions and access for the Reporting Instance - roles and SACR (reference the form)
  • Locating the Reporting Instance
  • Public query versus private query
  • Viewing public and private queries
  • Planning a query.  What user information is needed? 
  • What is a student?
  • Basic records in CS - ACAD_PROG, ACAD_PLAN, STDNT_CAR_TERM, CLASS_TBL_SE_VW (STDNT_ENRL and CLASS_TBL).
  • Table key structure.
  • Effective dating.
  • Joining tables.
  • Selection criteria.

Intermediate Topics 

  • Prompts - Mandatory and optional.
  • Outer joins.
  • Subqueries (Exists vs Does not Exist)

Advanced Topics