1. EdCallahan.com
  2. SQL Training
  3. Lesson files

SQL Training Lessons

 

  1. Create Table
  2. DDL
  3. Functions
  4. Where
  5. NULLS
  6. Joins
  7. Performance
  8. Many-To-Many
  9. Many-To-Many 2
  10. Subqueries
  11. Correlated Subqueries
  12. Window Function
  13. Set Functions
  14. Aggregate Query
  15. Update and Delete
  16. Deadlocks pt 1
  17. Deadlocks pt 2
  18. Deadlock Event Monitor
  19. Security
  20. Roles
  21. Variables and Logic Flow
  22. Cursors and DynamicSQL
  23. Stored Procedures
  24. Nested Transactions
  25. Stored Procedures pt 2
  26. fnSplitString
  27. Stored Procedures pt 3
  28. Triggers
  29. SQL Injection Attacks
  30. Backup and Restore pt 1
  31. Backup and Restore pt 2
  32. Backup and Restore pt 3
  33. Log File Size
  34. Index Fragmentation
  35. Enable Agent