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
