This session will discuss and demonstrate some advanced techniques for managing and analyzing data. Additionally, we will go into detail on working with JSON data within SQL server.

Topics

• CASE statements and uses
  https://learn.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver16 
• CAST
  https://learn.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-ver16 
• COALESCE
  https://learn.microsoft.com/en-us/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-ver16
• CROSS and OUTER APPLY https://learn.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver16
• CTE
  https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16
  • Multi CTE
  • RECURSION
• CURSORs
  https://learn.microsoft.com/en-us/sql/t-sql/language-elements/declare-cursor-transact-sql?view=sql-server-ver16
• PIVOT
  https://learn.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16
• UNION vs UNION all
  https://learn.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-ver16 
• DIACRITICS
  Working with special characters SQL_Latin1_General_CP1253_CI_AI
• RANDOM strings
• JSON data
  https://en.wikipedia.org/wiki/JSON
• OPENJSON
  https://learn.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql?view=sql-server-ver16

• SARGable queries
  https://www.sqlshack.com/how-to-use-sargable-expressions-in-t-sql-queries-performance-advantages-and-examples/ 

SELECT * FROM stu WHERE [ln] LIKE '%smith%'

Vs

SELECT * FROM stu WHERE [ln] LIKE 'smith%'