Filename | Size |
| 01 - Introduction/01 - Turn data into information with queries.mp4 | 5.4 MB |
| 01 - Introduction/01 - Turn data into information with queries.srt | 1.9 KB |
| 01 - Introduction/02 - What you should know.mp4 | 1013.3 KB |
| 01 - Introduction/02 - What you should know.srt | 1.3 KB |
| 01 - Introduction/03 - Download the sample database.mp4 | 5.5 MB |
| 02 - Introduction to T-SQL Queries/01 - What is Transact SQL.mp4 | 3.9 MB |
| 02 - Introduction to T-SQL Queries/02 - The SQL querying environment.mp4 | 15.5 MB |
| 02 - Introduction to T-SQL Queries/03 - Return records with SELECT and FROM.mp4 | 17 MB |
| 02 - Introduction to T-SQL Queries/04 - Filter records with WHERE.mp4 | 12.9 MB |
| 02 - Introduction to T-SQL Queries/05 - Sort records with ORDER BY.mp4 | 6.5 MB |
| 02 - Introduction to T-SQL Queries/06 - Column aliases.mp4 | 5.4 MB |
| 02 - Introduction to T-SQL Queries/07 - Create values with constants.mp4 | 9.4 MB |
| 03 - Additional Filter Techniques/01 - Limit results with TOP.mp4 | 9.8 MB |
| 03 - Additional Filter Techniques/02 - Remove duplicates with DISTINCT.mp4 | 7.2 MB |
| 03 - Additional Filter Techniques/03 - Comparison operators.mp4 | 7.9 MB |
| 03 - Additional Filter Techniques/04 - Understand NULL values.mp4 | 10.4 MB |
| 03 - Additional Filter Techniques/05 - Match text with LIKE and wildcards.mp4 | 9.3 MB |
| 04 - Retrieve Records from Multiple Tables/01 - Table joins and relationships.mp4 | 4.5 MB |
| 04 - Retrieve Records from Multiple Tables/02 - Inner joins.mp4 | 19.7 MB |
| 04 - Retrieve Records from Multiple Tables/03 - Left, right, and full outer joins.mp4 | 11.8 MB |
| 04 - Retrieve Records from Multiple Tables/04 - Cross joins.mp4 | 10.4 MB |
| 05 - Grouping Records/01 - Understand record grouping.mp4 | 4.2 MB |
| 05 - Grouping Records/02 - Use GROUP BY and COUNT.mp4 | 12.2 MB |
| 05 - Grouping Records/03 - Aggregate functions.mp4 | 3.5 MB |
| 05 - Grouping Records/04 - Explore data with SUM.mp4 | 19.6 MB |
| 05 - Grouping Records/04 - Explore data with SUM.srt | 12.3 KB |
| 05 - Grouping Records/05 - Filter groups with HAVING.mp4 | 8.1 MB |
| 06 - Manipulate Data with Functions/01 - Use functions in T-SQL.mp4 | 5.5 MB |
| 06 - Manipulate Data with Functions/02 - String functions.mp4 | 8.8 MB |
| 06 - Manipulate Data with Functions/03 - Text concatenation.mp4 | 9 MB |
| 06 - Manipulate Data with Functions/04 - Round with mathematical functions.mp4 | 7.1 MB |
| 06 - Manipulate Data with Functions/05 - Work with date functions.mp4 | 12.4 MB |
| 06 - Manipulate Data with Functions/06 - FORMAT date and times.mp4 | 7.1 MB |
| 06 - Manipulate Data with Functions/07 - Return random records with NEWID.mp4 | 5.2 MB |
| 06 - Manipulate Data with Functions/08 - The IIF logical function.mp4 | 7.7 MB |
| 07 - Writing SQL Scripts/01 - Change database context with USE.mp4 | 5.8 MB |
| 07 - Writing SQL Scripts/02 - Add comments to a script.mp4 | 7.3 MB |
| 07 - Writing SQL Scripts/03 - When to use square brackets.mp4 | 3.7 MB |
| 07 - Writing SQL Scripts/03 - When to use square brackets.srt | 2.7 KB |
| 08 - SQL Subqueries/01 - What is a subquery.mp4 | 10.8 MB |
| 08 - SQL Subqueries/02 - Use a subquery in a WHERE clause.mp4 | 13.2 MB |
| 08 - SQL Subqueries/03 - Correlated subqueries.mp4 | 13.8 MB |
| 08 - SQL Subqueries/04 - PIVOT the result set.mp4 | 9.7 MB |
| 09 - Work with Variables/01 - Create and use variables in a query.mp4 | 10 MB |
| 09 - Work with Variables/02 - Create a counter for a looping statement.mp4 | 8.6 MB |
| 10 - Result Set Operators/01 - Combine results with UNION.mp4 | 6.3 MB |
| 10 - Result Set Operators/02 - Return distinct rows with EXCEPT.mp4 | 9.6 MB |
| 10 - Result Set Operators/03 - Return common rows with INTERSECT.mp4 | 9.3 MB |
| 11 - Conclusion/01 - Next steps.mp4 | 1.9 MB |
| 11 - Conclusion/01 - Next steps.srt | 3 KB |