Introduction
  • Introduction
  • Is this your first session?
  • Resources
Objective 13: Combine database
  • UNION and UNION ALL
  • Intercept and Except
  • UNION, UNION ALL, INTERSECT and EXCEPT
  • CASE statement
  • CASE
  • IsNull and Coalesce
  • IsNull and Coalesce
  • MERGE statement - in theory
  • Let's Build our MERGE statement
  • Let's expand our MERGE statement
  • Merge with additional columns
  • MERGE
  • Summary
Objective 11 - Create and alter stored procedures (simple statements)
  • Let's create our first procedure
  • Ask for a specific employee
  • Creating procedures
  • Exercise with IF
  • Multiple arguments
  • While
  • Return
  • While and Return
  • Summary
Objective 18a - Implement try/catch/throw
  • Procedure Exercise
  • TRY/CATCH
  • THROW and RAISERROR
  • PRINT
  • Try/catch/throw
  • Summary
End of Session 4!
  • BONUS - Recap, Look ahead and Voucher Code
  • Well done!