Querying Data with T-SQL from SQL Server

1. T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/WideWorldImporters-Standard.bak 576.73 MB
2. T-SQL Functions Playbook By Andrew McSwiggan/TSFP_2021.bak 564.38 MB
3. T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xml-json-backup.sql 380.11 MB
4. T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xjt.bak 300.16 MB
5. T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml-script.sql 232.05 MB
6. T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml.bak 33.59 MB
7. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.mp4 32.22 MB
8. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.mp4 31.41 MB
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 31.02 MB
10. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.mp4 29.08 MB
11. Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp4 26.33 MB
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 26.31 MB
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 24.76 MB
14. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp4 23.90 MB
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 23.69 MB
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 23.60 MB
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 23.41 MB
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 22.86 MB
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 21.65 MB
20. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.mp4 21.62 MB
21. Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/04. Demo - Transaction Modes.mp4 21.59 MB
22. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/4. Demo - Actionable Message.mp4 21.46 MB
23. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/3. Applying T-SQL Logical Operators.mp4 21.39 MB
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 21.36 MB
25. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/7. Demo - Error Table and Stored Procedure.mp4 20.79 MB
26. Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/6. Self Join.mp4 20.74 MB
27. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.mp4 20.56 MB
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 20.36 MB
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 19.71 MB
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 19.39 MB
31. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/10. Demo - XACT_ABORT and XACT_STATE.mp4 18.87 MB
32. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/05. Demo - Error Message Details.mp4 17.96 MB
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 17.80 MB
34. Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/07. Demo - Transferring Funds.mp4 17.38 MB
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 17.35 MB
36. Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/3. Demo - Error Handling Template.mp4 16.87 MB
37. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/09. Demo - TRY..CATCH.mp4 16.86 MB
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 16.58 MB
39. T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/7. An Insert Statement with Constraints.mp4 16.47 MB
40. Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/06. Demo - Using RAISERROR.mp4 16.38 MB
41. T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/6. Inline View Queries and Subqueries.mp4 16.25 MB
42. T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/4. Creating Transactions Using BEGIN and COMMIT.mp4 16.03 MB
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 16.02 MB
44. Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.mp4 15.98 MB
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 15.73 MB
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 15.67 MB
47. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/2. Product Groups.mp4 15.53 MB
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 15.50 MB
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 15.17 MB
50. T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/3. Product Gender.mp4 15.05 MB