Linkedin - Querying Microsoft SQL Server 2022

1. 6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp4 48.83 MB
2. 5. Group Records/7. Solution- Obtain order summaries.mp4 42.19 MB
3. 8. SQL Subqueries/6. Solution- Write a query with a subquery.mp4 30.37 MB
4. 2. Introduction to T-SQL Queries/2. The SQL querying environment.mp4 25.98 MB
5. 2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp4 24.15 MB
6. 4. Retrieve Records from Multiple Tables/2. Inner joins.mp4 23.47 MB
7. 5. Group Records/4. Explore data with SUM.mp4 22.85 MB
8. 4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp4 21.51 MB
9. 6. Manipulate Data with Functions/8. Group dates into buckets.mp4 20.21 MB
10. 8. SQL Subqueries/3. Correlated subqueries.mp4 20.20 MB
11. 8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp4 19.67 MB
12. 6. Manipulate Data with Functions/6. Work with date functions.mp4 18.39 MB
13. 2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp4 17.69 MB
14. 6. Manipulate Data with Functions/10. Create a series of values.mp4 16.65 MB
15. 6. Manipulate Data with Functions/5. Find the GREATEST or LEAST value.mp4 15.74 MB
16. 8. SQL Subqueries/1. What is a subquery.mp4 15.42 MB
17. 2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp4 15.03 MB
18. 4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp4 14.98 MB
19. 5. Group Records/2. Use GROUP BY and COUNT.mp4 14.90 MB
20. 3. Additional Filter Techniques/7. Solution- Retrieve matching text strings.mp4 14.90 MB
21. 6. Manipulate Data with Functions/12. Write a CASE statement.mp4 14.80 MB
22. 9. Work with Variables/2. Create a counter for a looping statement.mp4 14.70 MB
23. 9. Work with Variables/4. Solution- Use variables in a query.mp4 14.66 MB
24. 8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp4 14.46 MB
25. 2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp4 14.37 MB
26. 2. Introduction to T-SQL Queries/7. Create values with constants and math.mp4 13.92 MB
27. 4. Retrieve Records from Multiple Tables/4. Cross joins.mp4 13.17 MB
28. 3. Additional Filter Techniques/1. Limit results with TOP.mp4 13.03 MB
29. 9. Work with Variables/1. Create and use variables in a query.mp4 12.80 MB
30. 3. Additional Filter Techniques/4. Understand NULL values.mp4 12.67 MB
31. 8. SQL Subqueries/4. PIVOT the result set.mp4 12.48 MB
32. 10. Result Set Operators/2. Return distinct rows with EXCEPT.mp4 12.34 MB
33. 3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp4 11.62 MB
34. 6. Manipulate Data with Functions/2. String functions.mp4 11.51 MB
35. 3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp4 11.13 MB
36. 6. Manipulate Data with Functions/3. Text concatenation.mp4 11.01 MB
37. 4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp4 10.57 MB
38. 6. Manipulate Data with Functions/11. The IIF logical function.mp4 10.49 MB
39. 10. Result Set Operators/3. Return common rows with INTERSECT.mp4 10.32 MB
40. 5. Group Records/5. Filter groups with HAVING.mp4 10.20 MB
41. 7. Writing SQL Scripts/2. Add comments to a script.mp4 10.04 MB
42. 6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp4 9.91 MB
43. 2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp4 9.78 MB
44. 6. Manipulate Data with Functions/4. Round with mathematical functions.mp4 9.70 MB
45. 6. Manipulate Data with Functions/7. FORMAT date and times.mp4 9.61 MB
46. 3. Additional Filter Techniques/3. Comparison operators.mp4 9.52 MB
47. 10. Result Set Operators/1. Combine results with UNION.mp4 8.92 MB
48. 7. Writing SQL Scripts/1. Change database context with USE.mp4 8.83 MB
49. 5. Group Records/8. Solution- Group rows and aggregate data.mp4 8.05 MB
50. 3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp4 7.94 MB