589689.xyz

Querying Data with T-SQL from SQL Server

  • 收录时间:2023-08-22 11:35:48
  • 文件大小:4GB
  • 下载次数:1
  • 最近下载:2023-08-22 11:35:48
  • 磁力链接:
立即下载 复制链接

文件列表

  1. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/WideWorldImporters-Standard.bak 563MB
  2. T-SQL Functions Playbook By Andrew McSwiggan/TSFP_2021.bak 551MB
  3. T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xml-json-backup.sql 371MB
  4. T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xjt.bak 293MB
  5. T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml-script.sql 227MB
  6. T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml.bak 33MB
  7. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.mp4 31MB
  8. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.mp4 31MB
  9. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/5. Using SQL Server Management Studio.mp4 30MB
  10. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.mp4 28MB
  11. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp4 26MB
  12. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/4. Adding and Modifying Data in Temporal Tables.mp4 26MB
  13. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/3. Selecting Data from XML - OPENXML and the query and value Methods.mp4 24MB
  14. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp4 23MB
  15. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/4. Using AVG in T-SQL.mp4 23MB
  16. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/5. Using MIN and MAX in T-SQL.mp4 23MB
  17. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/2. Using Common Table Expressions in T-SQL.mp4 23MB
  18. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/2. Using COUNT in T-SQL.mp4 22MB
  19. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.mp4 21MB
  20. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.mp4 21MB
  21. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/04. Demo - Transaction Modes.mp4 21MB
  22. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/4. Demo - Actionable Message.mp4 21MB
  23. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/3. Applying T-SQL Logical Operators.mp4 21MB
  24. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/4. Controlling Flow with T-SQL Logic.mp4 21MB
  25. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/7. Demo - Error Table and Stored Procedure.mp4 20MB
  26. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/6. Self Join.mp4 20MB
  27. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.mp4 20MB
  28. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/05. Demo - Adding Queries to Stored Procedures.mp4 20MB
  29. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/06. Demo - Creating a Test Environment.mp4 19MB
  30. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/6. What You Need to Know About SELECT for DML.mp4 19MB
  31. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/10. Demo - XACT_ABORT and XACT_STATE.mp4 18MB
  32. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/05. Demo - Error Message Details.mp4 18MB
  33. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/4. Casting and Converting Data Types.mp4 17MB
  34. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/07. Demo - Transferring Funds.mp4 17MB
  35. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.mp4 17MB
  36. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/3. Demo - Error Handling Template.mp4 16MB
  37. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/09. Demo - TRY..CATCH.mp4 16MB
  38. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/5. The Database for This Training - StackOverflow or StackExchange.mp4 16MB
  39. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/7. An Insert Statement with Constraints.mp4 16MB
  40. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/06. Demo - Using RAISERROR.mp4 16MB
  41. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/6. Inline View Queries and Subqueries.mp4 16MB
  42. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/4. Creating Transactions Using BEGIN and COMMIT.mp4 16MB
  43. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/3. Demo - Creating Templates.mp4 16MB
  44. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.mp4 16MB
  45. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/4. Using Cursors in T-SQL.mp4 15MB
  46. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/5. Converting Data into JSON with FOR JSON PATH and AUTO.mp4 15MB
  47. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/2. Product Groups.mp4 15MB
  48. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/5. Providing Rowset Views with OPENXML and the nodes Method.mp4 15MB
  49. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/10. Demo - Using Sp_executesql.mp4 15MB
  50. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/3. Product Gender.mp4 15MB
  51. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/11. Demo - Execution Plan Reuse.mp4 14MB
  52. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/05. Demo - Creating and Executing.mp4 14MB
  53. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/7. What You Need to Know About WHERE for DML.mp4 14MB
  54. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/6. Demo - Ordering and Paging.mp4 14MB
  55. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/6. Removing Data with Constraints and Cascade Deleting of Data.mp4 14MB
  56. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/4. Getting to Know the XPath Syntax and XQuery Language.mp4 14MB
  57. T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/3. The Dense Rank Function.mp4 14MB
  58. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/5. Querying Aggregations in Lists.mp4 14MB
  59. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/06. Demo - Isolation Levels.mp4 14MB
  60. T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/1. Combining Queries with COALESCE.mp4 13MB
  61. T-SQL Functions Playbook By Andrew McSwiggan/5. Substituting a Table Reference with a ROWSET Function/1. Substituting a Table Reference with a ROWSET Function.mp4 13MB
  62. T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/2. The Percent Rank Function.mp4 13MB
  63. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/5. Demo - Temp Table Myth.mp4 13MB
  64. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/06. Demo - Scripting Stored Procedures.mp4 13MB
  65. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/10. Demo - Debugging Code.mp4 13MB
  66. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/5. Retrieving Records on INSERT Using the OUTPUT Clause.mp4 13MB
  67. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/7. BULK INSERT Using a Format File.mp4 13MB
  68. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/8. Handling Missing Properties with LAX and STRICT Mode.mp4 12MB
  69. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/3. Using the Inner Join.mp4 12MB
  70. T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/3. Creating A B Customer Tags with Modulus.mp4 12MB
  71. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/6. Demo - Select 1 Versus Select.mp4 12MB
  72. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/6. Utilizing MERGE to Perform Operations on a Target Table.mp4 12MB
  73. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/5. Demo - Enforcing Business Logic.mp4 12MB
  74. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/3. TOP Functions.mp4 12MB
  75. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/2. What is XML How Do I Build Good XML.mp4 12MB
  76. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp4 12MB
  77. T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/3. First and Last Value.mp4 12MB
  78. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/5. Full OUTER Joins.mp4 12MB
  79. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/7. Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4 11MB
  80. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/6. Except.mp4 11MB
  81. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/4. Left and Right Joins.mp4 11MB
  82. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/3. What Is JSON What About JSON in SQL Server.mp4 11MB
  83. Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/4. Demo - First SELECT.mp4 11MB
  84. T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/2. Adding the COALESCE Function to a Query.mp4 11MB
  85. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/3. LIKE Function Demo.mp4 11MB
  86. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/7. Partially Undoing Transactions Using Savepoints.mp4 11MB
  87. T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/1. Ranking Data with Rank and Partition.mp4 11MB
  88. T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/5. Analysing Sales Using Product Attributes.mp4 11MB
  89. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/4. Creating SQL Server Databases.mp4 10MB
  90. T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/1. Calculating Values Using Numeric Scalar Functions.mp4 10MB
  91. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/5. Demo - Multiple Tables.mp4 10MB
  92. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/08. Demo - Nested Transactions.mp4 10MB
  93. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/3. Using Temporary Tables in T-SQL.mp4 10MB
  94. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/3. Concatenating Values in T-SQL.mp4 10MB
  95. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/8. Adding Multiple Records from a Data File with BULK INSERT.mp4 10MB
  96. T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/4. Pivoting the Attributes.mp4 10MB
  97. T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/2. Formatting Strings with Stuff and Replace.mp4 10MB
  98. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/3. Grouping Rows.mp4 10MB
  99. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/6. Demo - Row Count Mismatch.mp4 10MB
  100. T-SQL Functions Playbook By Andrew McSwiggan/7. Query Data with Static Value Functions/1. Query Data with Static Value Functions.mp4 10MB
  101. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/3. Using SUM in T-SQL.mp4 10MB
  102. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/4. Creating Statements with Simple Scalar Functions.mp4 10MB
  103. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/5. Selecting Data from Temporal Tables at Specific Points in Time.mp4 10MB
  104. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/4. Using Variables to Limit Results.mp4 10MB
  105. T-SQL Functions Playbook By Andrew McSwiggan/5. Substituting a Table Reference with a ROWSET Function/2. OPENROWSET Queries.mp4 10MB
  106. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/4. Removing Multiple Records with DELETE.mp4 9MB
  107. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/5. Filtering with WHERE.mp4 9MB
  108. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/4. Introduction to Multiple Tables in FROM.mp4 9MB
  109. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/12. Demo - Adding a Debug Flag.mp4 9MB
  110. T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/3. Cutting out the Product Attributes.mp4 9MB
  111. T-SQL Functions Playbook By Andrew McSwiggan/7. Query Data with Static Value Functions/2. Monthly Rolling Sales with GETDATE.mp4 9MB
  112. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/3. An Insert Statement with Columns and Values.mp4 9MB
  113. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/07. UPDATE Using Variables.mp4 9MB
  114. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/08. Demo - Table Valued Parameters.mp4 9MB
  115. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/4. Querying JSON Documents with T-SQL.mp4 9MB
  116. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/09. Demo - Save Points.mp4 9MB
  117. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/5. An Insert Statement with NULL and DEFAULT.mp4 9MB
  118. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/7. Filtering XML Data with Contains and Exist.mp4 8MB
  119. T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/2. The Round Function.mp4 8MB
  120. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/3. SELECT within an INSERT Statement.mp4 8MB
  121. T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/2. The Rank Function.mp4 8MB
  122. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/6. Updating XML with modify and the XML Data Modification Language.mp4 8MB
  123. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/4. Querying Unique Lists of Values.mp4 8MB
  124. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/2. Understanding Primary and Foreign Keys.mp4 8MB
  125. T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/1. Aggregating and Summarizing Data with Functions.mp4 8MB
  126. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/04. Comparing Data Fetching Options.mp4 8MB
  127. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/06. Modifying Data Using UPDATE with Constraints.mp4 8MB
  128. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/1. Creating Measures with Aggregation Functions.mp4 8MB
  129. T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/1. Calculating Values Using String Functions.mp4 8MB
  130. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/4. A Little SQL Server Architecture.mp4 8MB
  131. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/5. Intersect.mp4 8MB
  132. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/09. Demo - Handling Conversion Errors.mp4 8MB
  133. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/12. Demo - THROW.mp4 8MB
  134. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/09. Demo - Limiting User Access.mp4 8MB
  135. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/2. TSQL Demo Database.mp4 8MB
  136. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/4. Logical Predicates and Operators.mp4 8MB
  137. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/3. Demo - FROM Single Table.mp4 8MB
  138. Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/3. More Terminology.mp4 7MB
  139. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/4. Intelligent Measures.mp4 7MB
  140. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/6. Demo - Tools.mp4 7MB
  141. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/08. FROM and JOIN within an UPDATE.mp4 7MB
  142. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/04. Planning For Failure.mp4 7MB
  143. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/2. Querying JSON in Microsoft SQL Server.mp4 7MB
  144. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/07. Demo - Minimizing Modifications.mp4 7MB
  145. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/2. Understanding Temporal or System-versioned Tables.mp4 7MB
  146. Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/2. Evaluating SELECT Expressions.mp4 7MB
  147. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/5. Formatting Functions.mp4 7MB
  148. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/2. Working with the T-SQL Data Manipulation Language.mp4 7MB
  149. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/3. Setting up the SQL Server Environment.mp4 7MB
  150. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/3. Creating an Aggregation Query.mp4 7MB
  151. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/4. Using SELECT to Retrieve a Specific Field in an INSERT.mp4 7MB
  152. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/2. A Tour of the Data.mp4 7MB
  153. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/2. Offset and Fetch.mp4 7MB
  154. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/6. Recovering Data in a Temporal Table.mp4 7MB
  155. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/6. An Insert Statement with an Identity.mp4 7MB
  156. T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/4. The NTILE Function.mp4 6MB
  157. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/7. The Subquery.mp4 6MB
  158. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/02. Examining an Error Message.mp4 6MB
  159. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/3. 3VL (Ternary) Logic.mp4 6MB
  160. T-SQL Data Manipulation Playbook By Xavier Morera/8. Final Takeaway/1. Final Takeaway.mp4 6MB
  161. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/03. Transaction Modes in SQL Server.mp4 6MB
  162. Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/4. Using DISTINCT.mp4 6MB
  163. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/5. Querying Data Locked in a Transaction with NOLOCK.mp4 6MB
  164. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/05. Retrieving Number of Affected Rows with @@Rowcount.mp4 6MB
  165. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/04. Using UPDATE to Modify Data in Multiple Rows.mp4 6MB
  166. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/3. What Is T-SQL.mp4 5MB
  167. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/1. Query Data with Inline Queries and Scalar Functions.mp4 5MB
  168. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/2. Adding New Records with the INSERT Statement.mp4 5MB
  169. T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/3. Joining Multiple Queries with COALESCE.mp4 5MB
  170. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/5. Deleting Data Using JOINs.mp4 5MB
  171. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/3. Creating Temporal and History Tables.mp4 5MB
  172. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/3. Union All.mp4 5MB
  173. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/1. Introduction.mp4 5MB
  174. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/2. Course Review.mp4 5MB
  175. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/6. Undoing Transactions Using ROLLBACK.mp4 5MB
  176. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/07. Exploring Table Valued Parameters.mp4 5MB
  177. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.mp4 5MB
  178. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/01. Introduction.mp4 5MB
  179. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/1. Course Overview/1. Course Overview.mp4 5MB
  180. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/09. Examining Sp_executesql.mp4 5MB
  181. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/03. Why Care About Error Handling.mp4 5MB
  182. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/2. Comparing RAISERROR and THROW.mp4 5MB
  183. Querying Data Using T-SQL By Ami Levin/1. Course Overview/1. Course Overview.mp4 5MB
  184. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/2. Law of Order.mp4 5MB
  185. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/4. Group Filtering with HAVING.mp4 5MB
  186. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/03. Exploring New Syntax and Executing.mp4 5MB
  187. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/02. What Is the ACID Principle.mp4 5MB
  188. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/4. Busting Performance Myths.mp4 4MB
  189. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/02. Introduction.mp4 4MB
  190. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/03. Using UPDATE to Modify Data in One Row.mp4 4MB
  191. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/09. A Few More Details on UPDATE.mp4 4MB
  192. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/02. Modifying Records with the UPDATE Statement.mp4 4MB
  193. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/05. What Do We Mean By Atomic.mp4 4MB
  194. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/01. Introduction.mp4 4MB
  195. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/2. Introduction.mp4 4MB
  196. T-SQL Functions Playbook By Andrew McSwiggan/1. Course Overview/1. Course Overview.mp4 4MB
  197. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/2. Using INSERT with Multiple Values.mp4 4MB
  198. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/03. Reviewing Temporary Objects.mp4 4MB
  199. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/1. Introduction.mp4 4MB
  200. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/2. Creating a Baseline.mp4 4MB
  201. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/1. Maintaining Data Integrity with Transactions.mp4 4MB
  202. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/11. Reviewing Best Practices.mp4 4MB
  203. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/5. Final Takeaway/1. Final Takeaway.mp4 4MB
  204. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/1. Course Overview/1. Course Overview.mp4 4MB
  205. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/01. Introduction.mp4 4MB
  206. T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/4. Creating Alternating Customer A B Tags.mp4 4MB
  207. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/4. An Insert Statement with All Values.mp4 4MB
  208. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/3. Removing a Specific Record with DELETE.mp4 4MB
  209. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/2. Searching for Strings with the LIKE Function.mp4 4MB
  210. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/02. Introduction.mp4 4MB
  211. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/08. Handling Conversion Errors.mp4 4MB
  212. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/5. Paging Result Sets.mp4 4MB
  213. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/04. Naming Stored Procedures.mp4 4MB
  214. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/5. Tools.mp4 4MB
  215. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/4. Exploring Key Takeaways.mp4 4MB
  216. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/05. Primary Stored Procedure Benefits.mp4 4MB
  217. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/3. Understanding T-SQL Transactions.mp4 4MB
  218. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/8. Course Summary.mp4 4MB
  219. Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/2. What Is a SQL Query.mp4 4MB
  220. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/03. What Is a Stored Procedure.mp4 4MB
  221. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/12. Disadvantages of Stored Procedures.mp4 4MB
  222. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/7. Exploring Parameter Sniffing.mp4 4MB
  223. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/5. Module Review.mp4 4MB
  224. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/1. Implementing IF Then Logic.mp4 4MB
  225. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/1. Introduction.mp4 3MB
  226. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/04. Creating Temporary Objects.mp4 3MB
  227. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.mp4 3MB
  228. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/03. Errors Requiring Attention.mp4 3MB
  229. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/01. Introduction.mp4 3MB
  230. T-SQL Data Manipulation Playbook By Xavier Morera/1. Course Overview/1. Course Overview.mp4 3MB
  231. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/07. Exploring TRY..CATCH.mp4 3MB
  232. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/4. Union.mp4 3MB
  233. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/07. Exploring Parameters.mp4 3MB
  234. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/08. Error Handling Methods.mp4 3MB
  235. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/1. Querying XML Data in Microsoft SQL Server with T-SQL.mp4 3MB
  236. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/05. Isolation Levels.mp4 3MB
  237. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/08. Exploring Security Benefits.mp4 3MB
  238. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/11. Exploring THROW.mp4 3MB
  239. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/04. Exploring RAISERROR.mp4 3MB
  240. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/1. Introduction.mp4 3MB
  241. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/2. Defining Stored Procedure Templates.mp4 3MB
  242. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/10. Exploring Performance Gains.mp4 3MB
  243. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/7. Module Review.mp4 3MB
  244. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/09. Exploring Debugger.mp4 3MB
  245. Handling Errors in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.mp4 3MB
  246. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/13. Summary.mp4 3MB
  247. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/02. Creating Our Stored Procedure.mp4 3MB
  248. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/12. Summary.mp4 3MB
  249. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/1. Introduction.mp4 3MB
  250. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/7. Review and Resources.mp4 3MB
  251. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/11. Implementing a Debug Flag.mp4 3MB
  252. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/8. Takeaway.mp4 3MB
  253. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/2. Understanding NULLs.mp4 3MB
  254. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/3. Understanding and Differentiating the T-SQL Sub-languages.mp4 3MB
  255. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/3. Takeaway.mp4 3MB
  256. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/13. Summary.mp4 3MB
  257. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/5. Continuing the Journey.mp4 3MB
  258. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/9. Summary.mp4 3MB
  259. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/10. Summary.mp4 3MB
  260. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/07. Nested Transactions.mp4 2MB
  261. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/13. Summary.mp4 2MB
  262. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/5. Review and Resources.mp4 2MB
  263. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/02. Building Queries in Stored Procedures.mp4 2MB
  264. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/3. ORDER BY.mp4 2MB
  265. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/8. Distributed Transactions at a High Level.mp4 2MB
  266. Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/3. Dealing with NULLs.mp4 2MB
  267. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/7. Review and Resources.mp4 2MB
  268. T-SQL Functions Playbook By Andrew McSwiggan/02/working-with-the-t-sql-data-manipulation-language-slides.pdf 2MB
  269. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/1. Introduction.mp4 2MB
  270. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/4. Determinism and Tiebreakers.mp4 2MB
  271. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/6. Additional Resources and Conclusion.mp4 2MB
  272. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/7. Module Review.mp4 2MB
  273. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/9. Takeaway.mp4 2MB
  274. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/8. Takeaway.mp4 2MB
  275. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/10. Summary.mp4 2MB
  276. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/8. Takeaway.mp4 2MB
  277. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/7. Takeaway.mp4 2MB
  278. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/5. Review and Resources.mp4 2MB
  279. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/2. Transaction Properties.mp4 2MB
  280. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/5. Next Steps.mp4 2MB
  281. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/1. Removing Data Using T-SQL Statements.mp4 2MB
  282. T-SQL Functions Playbook By Andrew McSwiggan/02/querying-json-with-t-sql-slides.pdf 2MB
  283. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/1. Adding Data Using T-SQL Statements.mp4 2MB
  284. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/2. The SELECT Query Syntax.mp4 2MB
  285. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/4. What Is the T-SQL Data Manipulation Language.mp4 2MB
  286. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/9. Takeaway.mp4 2MB
  287. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/10. Takeaway.mp4 2MB
  288. T-SQL Functions Playbook By Andrew McSwiggan/02/setting-up-the-sql-server-environment-slides.pdf 2MB
  289. T-SQL Functions Playbook By Andrew McSwiggan/05/filtering-and-controlling-flow-slides.pdf 2MB
  290. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/1. Utilizing Temporal Tables.mp4 2MB
  291. T-SQL Functions Playbook By Andrew McSwiggan/03/querying-xml-data-with-t-sql-slides.pdf 2MB
  292. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/8. Review and Resources.mp4 2MB
  293. T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/1. Using Advanced T-SQL Techniques.mp4 2MB
  294. T-SQL Functions Playbook By Andrew McSwiggan/06/query-data-with-inline-queries-and-scalar-functions-slides.pdf 2MB
  295. T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/01. Modifying Data Using T-SQL Statements.mp4 2MB
  296. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/5. Review and Resources.mp4 2MB
  297. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/1. Introduction.mp4 2MB
  298. T-SQL Functions Playbook By Andrew McSwiggan/03/shaping-data-in-a-query-slides.pdf 1MB
  299. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/10. Summary/1. Summary.mp4 1MB
  300. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/2. Removing Records with the DELETE Statement.mp4 1MB
  301. T-SQL Functions Playbook By Andrew McSwiggan/09/wrapping-up-slides.pdf 1MB
  302. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/6. Module Review.mp4 1MB
  303. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/9. Takeaway.mp4 1MB
  304. T-SQL Functions Playbook By Andrew McSwiggan/06/maintaining-data-integrity-with-transactions-slides.pdf 1MB
  305. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/NorthwindObjectsAndData.sql 1MB
  306. T-SQL Functions Playbook By Andrew McSwiggan/03/adding-data-using-t-sql-statements-slides.pdf 1MB
  307. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/4. Feedback.mp4 1MB
  308. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/6. Module Review.mp4 1MB
  309. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/6. Review and Resources.mp4 1MB
  310. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/2. Difference between Joins and Set Operators.mp4 1MB
  311. T-SQL Functions Playbook By Andrew McSwiggan/04/querying-data-from-multiple-tables-using-joins-slides.pdf 1MB
  312. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/6. Summary and Resources.mp4 1MB
  313. Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/5. Module Review.mp4 1MB
  314. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/1. Introduction.mp4 1MB
  315. T-SQL Functions Playbook By Andrew McSwiggan/08/using-t-sql-set-operators-slides.pdf 1MB
  316. T-SQL Functions Playbook By Andrew McSwiggan/07/using-advanced-t-sql-techniques-slides.pdf 1MB
  317. T-SQL Functions Playbook By Andrew McSwiggan/04/modifying-data-using-t-sql-statements-slides.pdf 1MB
  318. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/1. Introduction.mp4 1MB
  319. T-SQL Functions Playbook By Andrew McSwiggan/02/getting-started-with-error-handling-in-t-sql-slides.pdf 1MB
  320. T-SQL Functions Playbook By Andrew McSwiggan/04/utilizing-temporal-tables-slides.pdf 1MB
  321. T-SQL Functions Playbook By Andrew McSwiggan/06/grouping-rows-slides.pdf 1024KB
  322. T-SQL Functions Playbook By Andrew McSwiggan/02/creating-measures-with-aggregation-functions-slides.pdf 1001KB
  323. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/1. Introduction.mp4 993KB
  324. T-SQL Functions Playbook By Andrew McSwiggan/02/what-is-t-sql-slides.pdf 987KB
  325. T-SQL Functions Playbook By Andrew McSwiggan/10/summary-slides.pdf 981KB
  326. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/8. Takeaway.mp4 967KB
  327. Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/5. Module Review.mp4 899KB
  328. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/1. Module Introduction.mp4 883KB
  329. Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/1. Module Introduction.mp4 843KB
  330. T-SQL Functions Playbook By Andrew McSwiggan/05/removing-data-using-t-sql-statements-slides.pdf 790KB
  331. T-SQL Functions Playbook By Andrew McSwiggan/04/examining-error-handling-methods-slides.pdf 781KB
  332. T-SQL Functions Playbook By Andrew McSwiggan/09/simplifying-with-intermediate-tables-and-common-table-expressions-slides.pdf 776KB
  333. Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/1. Module Introduction.mp4 740KB
  334. Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/1. Module Introduction.mp4 724KB
  335. T-SQL Functions Playbook By Andrew McSwiggan/06/limiting-the-results-with-t-sql-functions-slides.pdf 722KB
  336. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/01. Version Check.mp4 713KB
  337. T-SQL Functions Playbook By Andrew McSwiggan/03/exploring-transactions-in-sql-server-slides.pdf 697KB
  338. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/1. Module Introduction.mp4 688KB
  339. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/2. Module Introduction.mp4 684KB
  340. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/01. Version Check.mp4 680KB
  341. T-SQL Functions Playbook By Andrew McSwiggan/08/ordering-and-paging-slides.pdf 673KB
  342. T-SQL Functions Playbook By Andrew McSwiggan/03/our-first-select-slides.pdf 661KB
  343. Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/1. Module Introduction.mp4 650KB
  344. T-SQL Functions Playbook By Andrew McSwiggan/05/filtering-with-where-slides.pdf 644KB
  345. T-SQL Functions Playbook By Andrew McSwiggan/11/calculating-values-using-numeric-scalar-functions-slides.pdf 640KB
  346. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/1. Version Check.mp4 570KB
  347. Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/1. Module Introduction.mp4 560KB
  348. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/1. Version Check.mp4 539KB
  349. T-SQL Functions Playbook By Andrew McSwiggan/05/substituting-a-table-reference-with-a-rowset-function-slides.pptx 535KB
  350. T-SQL Functions Playbook By Andrew McSwiggan/04/the-from-clause-slides.pdf 526KB
  351. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/1. Version Check.mp4 515KB
  352. Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/1. Version Check.mp4 488KB
  353. T-SQL Functions Playbook By Andrew McSwiggan/07/evaluating-select-expressions-slides.pdf 436KB
  354. T-SQL Functions Playbook By Andrew McSwiggan/02/exploring-the-benefits-of-stored-procedures-slides.pdf 433KB
  355. T-SQL Functions Playbook By Andrew McSwiggan/05/handling-errors-in-the-real-world-slides.pdf 420KB
  356. T-SQL Functions Playbook By Andrew McSwiggan/08/final-takeaway-slides.pdf 399KB
  357. T-SQL Functions Playbook By Andrew McSwiggan/04/demos/m4-demos/01_Expand_ABCCompany_Database.sql 323KB
  358. T-SQL Functions Playbook By Andrew McSwiggan/07/aggregating-data-in-a-query-slides.pdf 294KB
  359. T-SQL Functions Playbook By Andrew McSwiggan/07/query-data-with-static-value-functions-slides.pdf 285KB
  360. T-SQL Functions Playbook By Andrew McSwiggan/05/optimizing-stored-procedure-performance-slides.pdf 263KB
  361. T-SQL Functions Playbook By Andrew McSwiggan/04/aggregating-and-summarizing-data-with-functions-slides.pdf 232KB
  362. T-SQL Functions Playbook By Andrew McSwiggan/04/setting-up-queries-in-stored-procedures-slides.pdf 222KB
  363. T-SQL Functions Playbook By Andrew McSwiggan/09/combining-queries-with-coalesce-slides.pdf 222KB
  364. T-SQL Functions Playbook By Andrew McSwiggan/10/calculating-values-using-string-functions-slides.pdf 222KB
  365. T-SQL Functions Playbook By Andrew McSwiggan/03/creating-our-first-stored-procedure-slides.pdf 210KB
  366. T-SQL Functions Playbook By Andrew McSwiggan/08/implementing-if-then-logic-slides.pdf 187KB
  367. T-SQL Functions Playbook By Andrew McSwiggan/06/building-stored-procedures-in-the-real-world-slides.pdf 175KB
  368. T-SQL Functions Playbook By Andrew McSwiggan/05/final-takeaway-slides.pdf 158KB
  369. T-SQL Functions Playbook By Andrew McSwiggan/03/ranking-data-with-rank-and-partition-slides.pdf 148KB
  370. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/SQL Server 2019 Editions Datasheet.pdf 147KB
  371. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/DataTableExample.html 68KB
  372. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/SQL Server Data Type Conversion Chart.png 44KB
  373. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.vtt 17KB
  374. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.vtt 15KB
  375. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/3. Selecting Data from XML - OPENXML and the query and value Methods.vtt 14KB
  376. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/5. Using SQL Server Management Studio.vtt 14KB
  377. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/4. Controlling Flow with T-SQL Logic.vtt 13KB
  378. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.vtt 12KB
  379. T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/6. What You Need to Know About SELECT for DML.vtt 12KB
  380. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.vtt 11KB
  381. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/4. Getting to Know the XPath Syntax and XQuery Language.vtt 11KB
  382. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/2. Using COUNT in T-SQL.vtt 11KB
  383. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.vtt 11KB
  384. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/5. Using MIN and MAX in T-SQL.vtt 11KB
  385. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/4. Creating Transactions Using BEGIN and COMMIT.vtt 10KB
  386. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/3. Applying T-SQL Logical Operators.vtt 10KB
  387. T-SQL Functions Playbook By Andrew McSwiggan/03/demos/INSERT.txt 10KB
  388. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/4. Casting and Converting Data Types.vtt 10KB
  389. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.vtt 10KB
  390. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/4. Demo - Actionable Message.vtt 10KB
  391. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/6. Self Join.vtt 10KB
  392. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/5. Providing Rowset Views with OPENXML and the nodes Method.vtt 10KB
  393. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/2. Using Common Table Expressions in T-SQL.vtt 9KB
  394. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.vtt 9KB
  395. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/04. Demo - Transaction Modes.vtt 9KB
  396. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/7. Demo - Error Table and Stored Procedure.vtt 9KB
  397. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/7. Parsing and Importing JSON with OPENROWSET and OPENJSON.vtt 9KB
  398. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/05. Demo - Adding Queries to Stored Procedures.vtt 9KB
  399. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/4. Using AVG in T-SQL.vtt 9KB
  400. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.vtt 9KB
  401. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/2. What is XML How Do I Build Good XML.vtt 9KB
  402. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/07. Demo - Transferring Funds.vtt 9KB
  403. T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/5. Querying Aggregations in Lists.vtt 8KB
  404. Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/3. What Is JSON What About JSON in SQL Server.vtt 8KB
  405. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/05. Demo - Error Message Details.vtt 8KB
  406. T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/6. Removing Data with Constraints and Cascade Deleting of Data.vtt 8KB
  407. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/3. Product Gender.vtt 8KB
  408. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/06. Demo - Creating a Test Environment.vtt 8KB
  409. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/06. Demo - Using RAISERROR.vtt 8KB
  410. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/3. Demo - Error Handling Template.vtt 8KB
  411. T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/3. First and Last Value.vtt 8KB
  412. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/M7-Company Sales with Min Max and Avg.rpt 8KB
  413. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/4. Creating SQL Server Databases.vtt 8KB
  414. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.vtt 8KB
  415. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/7. An Insert Statement with Constraints.vtt 8KB
  416. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/6. Inline View Queries and Subqueries.vtt 8KB
  417. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/4. Using Cursors in T-SQL.vtt 8KB
  418. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/05. Demo - Creating and Executing.vtt 8KB
  419. T-SQL Functions Playbook By Andrew McSwiggan/5. Substituting a Table Reference with a ROWSET Function/1. Substituting a Table Reference with a ROWSET Function.vtt 8KB
  420. Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/6. Demo - Ordering and Paging.vtt 8KB
  421. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.vtt 8KB
  422. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/3. Demo - Creating Templates.vtt 7KB
  423. T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/1. Combining Queries with COALESCE.vtt 7KB
  424. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/3. Grouping Rows.vtt 7KB
  425. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/7. Partially Undoing Transactions Using Savepoints.vtt 7KB