Virtual: SQL for Data Analysts – Advanced (Day 2)

Day 2 Agenda:

  • Complex functions
    • Using the WITH statement
    • Window functions
    • Ranking data
    • Point in time functions
    • Using the APPLY function
  • Deploying SQL queries in your tool
    • Web Intelligence
    • Crystal Reports
    • InfoBurst
    • Tableau
    • Power BI
  • Other database systems
    • Compare/contrast RDBMS’s
    • Syntactical differences

 

View Full Agenda:

Post-Conference Boot Camp