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%'