Training agenda
  1. The use of scheduling functions
    • Window function OVER()
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()
    • NTILE(n)
  2. Non-standard data grouping
    • ROLLUP
    • CUBE
    • GROUPING SETS
  3. Glossaries, sums, differences and set products
    • UNION
    • UNION ALL
    • EXCEPT
    • INTERSECT
  4. Selected functions
    • Text
    • Date and time
    • Mathematical
    • Converting
  5. The use of several sources and data combining
    • Subqueries
    • CTE (Common Table Expression) queries
    • The use of views
    • Temporary tables
  6. Creating parameterised stored procedures
  7. Downloading, sending data
    • data import
    • BULK INSERT
    • Sending SQL commands from VBA code in Excel (ADO Recordset)
  8. Performing an operation in a loop
  9. Navigating through records
    • FETCH, OFFSET
    • LAG, LEAD
  10. Data transformation (PIVOT / UNPIVOT)
  11. Recursive CTE
  12. Incremental sum