Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

CASE and IIF: Turning Rules into Columns

Lesson 7 of 22 Lab 🔒 Locked

Lessons in this course

  1. T-SQL Query Anatomy: Schemas, TOP and Logical OrderLabFree
  2. INNER vs LEFT JOIN and the ON-versus-WHERE TrapLab Locked
  3. LEFT JOIN + GROUP BY: COUNT, ISNULL and Honest AveragesLab Locked
  4. Three-Table Joins and the Row-Multiplication TrapLab Locked
  5. Variables: DECLARE, SET and SELECT AssignmentLab Locked
  6. Dates in T-SQL: DATEADD, DATEDIFF and EOMONTHLab Locked
  7. CASE and IIF: Turning Rules into ColumnsLab Locked
  8. Subqueries: Scalar, EXISTS and the NOT IN NULL TrapLab Locked
  9. CTE Basics: Name a Step, Use It TwiceLab Locked
  10. ROW_NUMBER in a CTE: Latest per Group and Running TotalsLab Locked
  11. Recursive CTEs: Exploding a Bill of MaterialsLab Locked
  12. Recursive CTEs as Generators: A Calendar of DaysLab Locked
  13. IF...ELSE and BEGIN...END: Control FlowLab Locked
  14. WHILE Loops, BREAK, CONTINUE and @@ROWCOUNTLab Locked
  15. Stored Procedures: Parameters, Defaults and EXECLab Locked
  16. OUTPUT Parameters and RETURN CodesLab Locked
  17. Temp Tables and Table Variables: A Staging ScriptLab Locked
  18. Transactions: BEGIN TRAN, COMMIT, ROLLBACK and @@TRANCOUNTLab Locked
  19. TRY...CATCH, XACT_STATE and Atomic StatementsLab Locked
  20. The OUTPUT Clause: inserted, deleted and Audit TrailsLab Locked
  21. MERGE: Insert, Update and Delete in One StatementLab Locked
  22. Final Project: A Robust Nightly Stock Sync ProcedureLab Locked