Details for:

Type:
Files:
Size:

Uploaded:
By:

Seeders:
Leechers:
Info Hash:
  1. 1. Introduction/1. Turn data into information with queries.mp43.99 MiB
  2. 1. Introduction/2. What you should know.mp41.49 MiB
  3. 1. Introduction/3. Download the sample database.mp47.91 MiB
  4. 1. Introduction/4. Exploring the code challenge environment.mp44.14 MiB
  5. 10. Result Set Operators/1. Combine results with UNION.mp48.92 MiB
  6. 10. Result Set Operators/2. Return distinct rows with EXCEPT.mp412.34 MiB
  7. 10. Result Set Operators/3. Return common rows with INTERSECT.mp410.32 MiB
  8. 11. Conclusion/1. Next steps.mp42.03 MiB
  9. 2. Introduction to T-SQL Queries/1. What is Transact SQL.mp46.95 MiB
  10. 2. Introduction to T-SQL Queries/10. Solution- Query information from a database.mp417.69 MiB
  11. 2. Introduction to T-SQL Queries/2. The SQL querying environment.mp425.98 MiB
  12. 2. Introduction to T-SQL Queries/3. Return records with SELECT and FROM.mp424.15 MiB
  13. 2. Introduction to T-SQL Queries/4. Filter records with WHERE.mp415.03 MiB
  14. 2. Introduction to T-SQL Queries/5. Sort records with ORDER BY.mp49.78 MiB
  15. 2. Introduction to T-SQL Queries/6. Column aliases.mp46.38 MiB
  16. 2. Introduction to T-SQL Queries/7. Create values with constants and math.mp413.92 MiB
  17. 2. Introduction to T-SQL Queries/8. Challenge- Write a SELECT query.mp42.27 MiB
  18. 2. Introduction to T-SQL Queries/9. Solution- Write a SELECT query.mp414.37 MiB
  19. 3. Additional Filter Techniques/1. Limit results with TOP.mp413.03 MiB
  20. 3. Additional Filter Techniques/2. Remove duplicates with DISTINCT.mp47.94 MiB
  21. 3. Additional Filter Techniques/3. Comparison operators.mp49.52 MiB
  22. 3. Additional Filter Techniques/4. Understand NULL values.mp412.67 MiB
  23. 3. Additional Filter Techniques/5. Match text with LIKE and wildcards.mp411.13 MiB
  24. 3. Additional Filter Techniques/6. Challenge- Retrieve matching text strings.mp41.55 MiB
  25. 3. Additional Filter Techniques/7. Solution- Retrieve matching text strings.mp414.90 MiB
  26. 3. Additional Filter Techniques/8. Solution- Filter results from a query result.mp411.62 MiB
  27. 4. Retrieve Records from Multiple Tables/1. Table joins and relationships.mp45.59 MiB
  28. 4. Retrieve Records from Multiple Tables/2. Inner joins.mp423.47 MiB
  29. 4. Retrieve Records from Multiple Tables/3. Left right and full outer joins.mp414.98 MiB
  30. 4. Retrieve Records from Multiple Tables/4. Cross joins.mp413.17 MiB
  31. 4. Retrieve Records from Multiple Tables/5. Challenge- Return data from multiple tables.mp41.88 MiB
  32. 4. Retrieve Records from Multiple Tables/6. Solution- Return data from multiple tables.mp421.51 MiB
  33. 4. Retrieve Records from Multiple Tables/7. Solution- Join data in multiple tables.mp410.57 MiB
  34. 5. Group Records/1. Understand record grouping.mp45.88 MiB
  35. 5. Group Records/2. Use GROUP BY and COUNT.mp414.90 MiB
  36. 5. Group Records/3. Aggregate functions.mp46.18 MiB
  37. 5. Group Records/4. Explore data with SUM.mp422.85 MiB
  38. 5. Group Records/5. Filter groups with HAVING.mp410.20 MiB
  39. 5. Group Records/6. Challenge- Obtain order summaries.mp42.58 MiB
  40. 5. Group Records/7. Solution- Obtain order summaries.mp442.19 MiB
  41. 5. Group Records/8. Solution- Group rows and aggregate data.mp48.05 MiB
  42. 6. Manipulate Data with Functions/1. Use functions in T-SQL.mp47.41 MiB
  43. 6. Manipulate Data with Functions/10. Create a series of values.mp416.65 MiB
  44. 6. Manipulate Data with Functions/11. The IIF logical function.mp410.49 MiB
  45. 6. Manipulate Data with Functions/12. Write a CASE statement.mp414.80 MiB
  46. 6. Manipulate Data with Functions/13. Challenge- Use functions in a SQL query.mp41.45 MiB
  47. 6. Manipulate Data with Functions/14. Solution- Use functions in a SQL query.mp448.83 MiB
  48. 6. Manipulate Data with Functions/15. Solution- Use functions in a query.mp49.91 MiB
  49. 6. Manipulate Data with Functions/2. String functions.mp411.51 MiB
  50. 6. Manipulate Data with Functions/3. Text concatenation.mp411.01 MiB
  51. 6. Manipulate Data with Functions/4. Round with mathematical functions.mp49.70 MiB
  52. 6. Manipulate Data with Functions/5. Find the GREATEST or LEAST value.mp415.74 MiB
  53. 6. Manipulate Data with Functions/6. Work with date functions.mp418.39 MiB
  54. 6. Manipulate Data with Functions/7. FORMAT date and times.mp49.61 MiB
  55. 6. Manipulate Data with Functions/8. Group dates into buckets.mp420.21 MiB
  56. 6. Manipulate Data with Functions/9. Return random records with NEWID.mp46.98 MiB
  57. 7. Writing SQL Scripts/1. Change database context with USE.mp48.83 MiB
  58. 7. Writing SQL Scripts/2. Add comments to a script.mp410.04 MiB
  59. 7. Writing SQL Scripts/3. When to use square brackets.mp45.32 MiB
  60. 8. SQL Subqueries/1. What is a subquery.mp415.42 MiB
  61. 8. SQL Subqueries/2. Use a subquery in a HAVING clause.mp419.67 MiB
  62. 8. SQL Subqueries/3. Correlated subqueries.mp420.20 MiB
  63. 8. SQL Subqueries/4. PIVOT the result set.mp412.48 MiB
  64. 8. SQL Subqueries/5. Challenge- Write a query with a subquery.mp42.05 MiB
  65. 8. SQL Subqueries/6. Solution- Write a query with a subquery.mp430.37 MiB
  66. 8. SQL Subqueries/7. Solution- Obtain information with a subquery.mp414.46 MiB
  67. 9. Work with Variables/1. Create and use variables in a query.mp412.80 MiB
  68. 9. Work with Variables/2. Create a counter for a looping statement.mp414.70 MiB
  69. 9. Work with Variables/3. Challenge- Use variables in a query.mp41.26 MiB
  70. 9. Work with Variables/4. Solution- Use variables in a query.mp414.66 MiB
  71. Ex_Files_Querying_Microsoft_SQL_Server_2022.zip27.58 KiB