Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore missing T-SQL querying features for handling NULLs and data analysis in this conference talk from PASS Data Community Summit. Delve into ISO/IEC SQL standard features not implemented in SQL Server, focusing on NULL-related functionalities and data analysis techniques like window functions and row pattern recognition. Learn practical workarounds for T-SQL, covering topics such as distinct predicates, index usage, set operators, NULL sorting, scaling, last non-null values, null treatment clauses, unique row numbers, and window functions. Gain insights from expert Itzik Ben-Gan as he demonstrates these concepts with real-world examples and source code.
