Combining and Filtering Data with T-SQL 2019
Data silos are killing productivity across organisations, yet most analysts still struggle with complex T-SQL joins and filtering operations. Master the essential techniques for combining datasets efficiently and filtering results with precision using SQL Server 2019’s latest capabilities.
AIU.ac Verdict: Excellent for database professionals who need to level up their T-SQL querying skills beyond basic SELECT statements. However, complete SQL beginners might find the pace challenging without foundational knowledge of database concepts.
What This Course Covers
You’ll dive deep into advanced JOIN operations including INNER, OUTER, CROSS, and self-joins, learning when and why to use each type for optimal performance. The course covers subqueries, common table expressions (CTEs), and window functions for complex data filtering scenarios.
Practical modules focus on real-world challenges like handling NULL values, implementing conditional logic with CASE statements, and optimising query performance through proper indexing strategies. You’ll also explore SQL Server 2019’s enhanced features for data filtering, including improved batch mode processing and intelligent query processing capabilities.
Who Is This Course For?
Ideal for:
- Database Analysts: Working with multiple data sources who need to create complex reports and need reliable techniques for joining disparate datasets
- Business Intelligence Developers: Building ETL processes and data warehouses who require advanced filtering techniques for data transformation pipelines
- Software Developers: Working with SQL Server applications who want to write more efficient queries and reduce database load through better filtering strategies
May not suit:
- Complete SQL Beginners: Those without basic understanding of SELECT statements, WHERE clauses, and fundamental database concepts will struggle with the advanced techniques
- Non-SQL Server Users: Professionals working exclusively with MySQL, PostgreSQL, or Oracle databases, as the course focuses specifically on SQL Server 2019 features and syntax
Frequently Asked Questions
How long does Combining and Filtering Data with T-SQL 2019 take?
The course runs for 3 hours and 26 minutes of expert-led video content, typically completed over 1-2 weeks with hands-on practice.
Do I need SQL Server installed to follow along?
Pluralsight provides hands-on labs and sandboxes, so you can practice without installing SQL Server locally, though having access helps for additional practice.
What SQL knowledge do I need before starting?
You should be comfortable with basic SELECT statements, WHERE clauses, and understand fundamental database concepts like tables and relationships.
Will this work with older SQL Server versions?
Most techniques apply to SQL Server 2016+, but some advanced features and optimisations are specific to SQL Server 2019 and later versions.
Course by Tamara Pattinson on Pluralsight. Duration: 3h 26m. Last verified by AIU.ac: March 2026.
