1. T-SQL Beginner Level Intro

2. Omissions and Becoming Advanced

3. SQL Server 2016 and R

5. T-SQL Temporary Tables

7. Select Into Variable

8. Column Partitioning

9. Calculating Age from DOB

10. Date Format Conversion

11. Flood One Column Into Another

12. Building data up by columns

13. Looping

15. Difference between putting criteria in “And” in a table join, and putting criteria in “Where”

16. Using In ()

17. Union and Union to Table

18. Like

19. Case

20. If Then Else

21. Creating Steps to Next Rows

22. Manual Transposing

23. SSIS email

24. SSIS Dynamic Filename Output

25. CTEs (Common Table Expressions)

27. In-Line Select

28. Into new_table

29. Where and Order By

30. Group By

31. Union [All]

32. Top N [Percent]

33. Logical Operators: And, Or, Not, In, Like, Between, Greater Than Less Than, Exists

34. Order By

35. Having

36. Correlated Subqueries

37. Inner Joins, Outer Joins

38. Table and Column Aliasing

39. Return, WaitFor, GoTo

40. Cross Joins, Self Joins

41. Cross-Server Queries

42. Derived Tables

165. Randomly link to a pick-list

 

 

 

 

 

 

 

Advertisements