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

Buy Now Button

Day 2 Agenda:

  • Complex functions
    • Using the WITH statement
    • Window functions
    • Ranking data
    • Point in time functions
    • Using the APPLY function
  • Tips and tricks
    • Flattening data/rows to columns
    • Lead and lag functions
    • Data validation
  • 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:

Buy Now Button

Post-Conference Boot Camp