Скачать или смотреть Introduction to Microsoft SQL (T-SQL) 7 - The WHERE clause

In the seventh video of this new series, we will look at the third clause of the SELECT statement, namely the WHERE clause.
Want more? My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
If a table contains 1,000 rows, do you have to get all 1,000 rows each time? What if you only wanted a subset of these rows? The WHERE clause allows you to apply a condition, which allows you to only retrieve part of the table. However, how do you use a WHERE clause which includes a string? And what if you wanted to look for only part of a string? We'll see how to do this in this video.
----
Download the data from here: https://rebrand.ly/SQLServerData