Querying Data with SQL from SQL Server | FCE94A77D024FA11B8890949848D53CE12E484CB

Querying Data with SQL from SQL Server

Name	Querying Data with T-SQL from SQL Server	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	4.7 GB
Total Files	870
Last Seen	2025-04-02 23:39
Hash	FCE94A77D024FA11B8890949848D53CE12E484CB

/.../02. Exploring the Benefits of Stored Procedures/
01. Version Check.mp4	730.6 KB
01. Version Check.vtt	0.0 KB
02. Introduction.mp4	4.6 MB
02. Introduction.vtt	3.8 KB
03. What Is a Stored Procedure.mp4	3.9 MB
03. What Is a Stored Procedure.vtt	3.6 KB
04. Comparing Data Fetching Options.mp4	8.4 MB
04. Comparing Data Fetching Options.vtt	7.3 KB
05. Primary Stored Procedure Benefits.mp4	4.0 MB
05. Primary Stored Procedure Benefits.vtt	3.4 KB
06. Demo - Creating Test Environment.mp4	17.8 MB
06. Demo - Creating Test Environment.vtt	7.7 KB
07. Demo - Minimizing Modifications.mp4	7.4 MB
07. Demo - Minimizing Modifications.vtt	3.8 KB
08. Exploring Security Benefits.mp4	3.3 MB
08. Exploring Security Benefits.vtt	3.4 KB
09. Demo - Limiting User Access.mp4	7.9 MB
09. Demo - Limiting User Access.vtt	3.8 KB
10. Exploring Performance Gains.mp4	3.2 MB
10. Exploring Performance Gains.vtt	3.5 KB
11. Demo - Execution Plan Reuse.mp4	15.2 MB
11. Demo - Execution Plan Reuse.vtt	6.3 KB
12. Disadvantages of Stored Procedures.mp4	3.9 MB
12. Disadvantages of Stored Procedures.vtt	4.0 KB
13. Summary.mp4	2.6 MB
13. Summary.vtt	2.3 KB
/.../03. Creating Our First Stored Procedure/
01. Introduction.mp4	4.2 MB
01. Introduction.vtt	3.7 KB
02. Creating Our Stored Procedure.mp4	3.1 MB
02. Creating Our Stored Procedure.vtt	2.8 KB
03. Exploring New Syntax and Executing.mp4	4.8 MB
03. Exploring New Syntax and Executing.vtt	4.3 KB
04. Naming Stored Procedures.mp4	4.0 MB
04. Naming Stored Procedures.vtt	3.8 KB
05. Demo - Creating and Executing.mp4	14.9 MB
05. Demo - Creating and Executing.vtt	7.9 KB
06. Demo - Scripting Stored Procedures.mp4	13.5 MB
06. Demo - Scripting Stored Procedures.vtt	6.8 KB
07. Exploring Parameters.mp4	3.5 MB
07. Exploring Parameters.vtt	3.6 KB
08. Demo - Adding Parameters.mp4	16.4 MB
08. Demo - Adding Parameters.vtt	8.0 KB
09. Exploring Debugger.mp4	3.2 MB
09. Exploring Debugger.vtt	2.8 KB
10. Demo - Debugging Code.mp4	13.4 MB
10. Demo - Debugging Code.vtt	7.2 KB
11. Reviewing Best Practices.mp4	4.3 MB
11. Reviewing Best Practices.vtt	4.4 KB
12. Summary.mp4	3.1 MB
12. Summary.vtt	2.6 KB
/.../04. Setting up Queries in Stored Procedures/
01. Introduction.mp4	5.2 MB
01. Introduction.vtt	4.5 KB
02. Building Queries in Stored Procedures.mp4	2.5 MB
02. Building Queries in Stored Procedures.vtt	2.7 KB
03. Reviewing Temporary Objects.mp4	4.4 MB
03. Reviewing Temporary Objects.vtt	4.2 KB
04. Creating Temporary Objects.mp4	3.6 MB
04. Creating Temporary Objects.vtt	3.2 KB
05. Demo - Adding Queries to Stored Procedures.mp4	20.8 MB
05. Demo - Adding Queries to Stored Procedures.vtt	9.2 KB
06. Demo - Using Temporary Objects.mp4	22.2 MB
06. Demo - Using Temporary Objects.vtt	10.8 KB
07. Exploring Table Valued Parameters.mp4	5.3 MB
07. Exploring Table Valued Parameters.vtt	5.2 KB
08. Demo - Table Valued Parameters.mp4	9.2 MB
08. Demo - Table Valued Parameters.vtt	4.5 KB
09. Examining Sp_executesql.mp4	5.0 MB
09. Examining Sp_executesql.vtt	4.1 KB
10. Demo - Using Sp_executesql.mp4	15.5 MB
10. Demo - Using Sp_executesql.vtt	6.5 KB
11. Implementing a Debug Flag.mp4	2.9 MB
11. Implementing a Debug Flag.vtt	3.1 KB
12. Demo - Adding a Debug Flag.mp4	9.6 MB
12. Demo - Adding a Debug Flag.vtt	4.2 KB
13. Summary.mp4	2.8 MB
13. Summary.vtt	2.6 KB
/1. Course Overview/
1. Course Overview.mp4	3.6 MB
1. Course Overview.vtt	2.5 KB
/.../5. Optimizing Stored Procedure Performance/
1. Introduction.mp4	5.4 MB
1. Introduction.vtt	5.0 KB
2. Creating a Baseline.mp4	4.3 MB
2. Creating a Baseline.vtt	3.9 KB
3. Demo - Gathering Baseline Stats.mp4	21.1 MB
3. Demo - Gathering Baseline Stats.vtt	9.5 KB
4. Busting Performance Myths.mp4	4.7 MB
4. Busting Performance Myths.vtt	3.9 KB
5. Demo - Temp Table Myth.mp4	13.6 MB
5. Demo - Temp Table Myth.vtt	5.6 KB
6. Demo - Select 1 Versus Select.mp4	12.6 MB
6. Demo - Select 1 Versus Select.vtt	5.5 KB
7. Exploring Parameter Sniffing.mp4	3.7 MB
7. Exploring Parameter Sniffing.vtt	3.6 KB
8. Demo - Parameter Sniffing.mp4	24.5 MB
8. Demo - Parameter Sniffing.vtt	10.4 KB
9. Summary.mp4	2.8 MB
9. Summary.vtt	2.6 KB
/.../6. Building Stored Procedures in the Real World/
1. Introduction.mp4	3.0 MB
1. Introduction.vtt	3.2 KB
2. Defining Stored Procedure Templates.mp4	3.2 MB
2. Defining Stored Procedure Templates.vtt	3.3 KB
3. Demo - Creating Templates.mp4	16.4 MB
3. Demo - Creating Templates.vtt	7.7 KB
4. Exploring Key Takeaways.mp4	4.0 MB
4. Exploring Key Takeaways.vtt	4.3 KB
5. Continuing the Journey.mp4	2.8 MB
5. Continuing the Journey.vtt	2.7 KB
/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/
playlist.m3u	4.1 KB
/1. Course Overview/
1. Course Overview.mp4	4.3 MB
1. Course Overview.vtt	3.1 KB
/10. Summary/
1. Summary.mp4	1.6 MB
1. Summary.vtt	0.6 KB
/.../2. Setting up the SQL Server Environment/
1. Version Check.mp4	583.9 KB
1. Version Check.vtt	0.0 KB
2. Introduction.mp4	4.5 MB
2. Introduction.vtt	2.7 KB
3. Setting up the SQL Server Environment.mp4	7.0 MB
3. Setting up the SQL Server Environment.vtt	3.4 KB
4. Creating SQL Server Databases.mp4	11.0 MB
4. Creating SQL Server Databases.vtt	8.0 KB
5. Using SQL Server Management Studio.mp4	31.8 MB
5. Using SQL Server Management Studio.vtt	14.0 KB
6. Summary and Resources.mp4	1.2 MB
6. Summary and Resources.vtt	0.8 KB
/.../3. Shaping Data in a Query/
1. Introduction.mp4	3.6 MB
1. Introduction.vtt	2.3 KB
2. The SELECT Query Syntax.mp4	1.9 MB
2. The SELECT Query Syntax.vtt	1.5 KB
3. Concatenating Values in T-SQL.mp4	10.7 MB
3. Concatenating Values in T-SQL.vtt	6.6 KB
4. Casting and Converting Data Types.mp4	18.2 MB
4. Casting and Converting Data Types.vtt	10.4 KB
5. Formatting Strings.mp4	22.1 MB
5. Formatting Strings.vtt	11.5 KB
6. Working with Characters.mp4	29.8 MB
6. Working with Characters.vtt	17.4 KB
7. Formatting Dates and Numbers.mp4	33.0 MB
7. Formatting Dates and Numbers.vtt	15.0 KB
8. Review and Resources.mp4	1.7 MB
8. Review and Resources.vtt	1.3 KB
/.../4. Querying Data from Multiple Tables Using JOINS/
1. Introduction.mp4	1.6 MB
1. Introduction.vtt	1.5 KB
2. Understanding Primary and Foreign Keys.mp4	8.5 MB
2. Understanding Primary and Foreign Keys.vtt	5.4 KB
3. Using the Inner Join.mp4	12.8 MB
3. Using the Inner Join.vtt	7.0 KB
4. Left and Right Joins.mp4	11.7 MB
4. Left and Right Joins.vtt	4.6 KB
5. Full OUTER Joins.mp4	12.2 MB
5. Full OUTER Joins.vtt	4.3 KB
6. Self Join.mp4	21.2 MB
6. Self Join.vtt	10.0 KB
7. Review and Resources.mp4	2.4 MB
7. Review and Resources.vtt	2.2 KB
/.../5. Filtering and Controlling Flow/
1. Introduction.mp4	2.4 MB
1. Introduction.vtt	2.2 KB
2. Expressions and Comparison Operators.mp4	32.2 MB
2. Expressions and Comparison Operators.vtt	11.9 KB
3. Applying T-SQL Logical Operators.mp4	21.9 MB
3. Applying T-SQL Logical Operators.vtt	10.6 KB
4. Controlling Flow with T-SQL Logic.mp4	21.9 MB
4. Controlling Flow with T-SQL Logic.vtt	13.7 KB
5. Review and Resources.mp4	2.5 MB
5. Review and Resources.vtt	2.0 KB
/.../6. Limiting the Results with T-SQL Functions/
1. Introduction.mp4	3.2 MB
1. Introduction.vtt	2.4 KB
2. Offset and Fetch.mp4	7.0 MB
2. Offset and Fetch.vtt	4.3 KB
3. TOP Functions.mp4	12.5 MB
3. TOP Functions.vtt	6.5 KB
4. Using Variables to Limit Results.mp4	10.0 MB
4. Using Variables to Limit Results.vtt	5.3 KB
5. Review and Resources.mp4	2.0 MB
5. Review and Resources.vtt	1.7 KB
/.../7. Aggregating Data in a Query/
1. Introduction.mp4	1.0 MB
1. Introduction.vtt	0.9 KB
2. Using COUNT in T-SQL.mp4	23.4 MB
2. Using COUNT in T-SQL.vtt	11.1 KB
3. Using SUM in T-SQL.mp4	10.3 MB
3. Using SUM in T-SQL.vtt	3.6 KB
4. Using AVG in T-SQL.mp4	24.3 MB
4. Using AVG in T-SQL.vtt	9.1 KB
5. Using MIN and MAX in T-SQL.mp4	24.2 MB
5. Using MIN and MAX in T-SQL.vtt	10.8 KB
6. Review and Resources.mp4	1.3 MB
6. Review and Resources.vtt	1.2 KB
/.../8. Using T-SQL Set Operators/
1. Introduction.mp4	1.1 MB
1. Introduction.vtt	1.0 KB
2. Difference between Joins and Set Operators.mp4	1.3 MB
2. Difference between Joins and Set Operators.vtt	0.9 KB
3. Union All.mp4	5.4 MB
3. Union All.vtt	2.2 KB
4. Union.mp4	3.6 MB
4. Union.vtt	1.9 KB
5. Intersect.mp4	8.2 MB
5. Intersect.vtt	3.2 KB
6. Except.mp4	11.9 MB
6. Except.vtt	5.4 KB
7. Review and Resources.mp4	3.0 MB
7. Review and Resources.vtt	2.7 KB
/.../9. Simplifying with Intermediate Tables and Common Table Expressions/
1. Introduction.mp4	1.2 MB
1. Introduction.vtt	1.2 KB
2. Using Common Table Expressions in T-SQL.mp4	24.0 MB
2. Using Common Table Expressions in T-SQL.vtt	9.6 KB
3. Using Temporary Tables in T-SQL.mp4	10.8 MB
3. Using Temporary Tables in T-SQL.vtt	4.8 KB
4. Using Cursors in T-SQL.mp4	16.1 MB
4. Using Cursors in T-SQL.vtt	7.9 KB
5. Review and Resources.mp4	1.6 MB
5. Review and Resources.vtt	1.1 KB
/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/
playlist.m3u	3.4 KB
/.../02. Getting Started with Error Handling in T-SQL/
01. Version Check.mp4	695.8 KB
01. Version Check.vtt	0.0 KB
02. Introduction.mp4	4.1 MB
02. Introduction.vtt	3.4 KB
03. Why Care About Error Handling.mp4	4.9 MB
03. Why Care About Error Handling.vtt	4.5 KB
04. Planning For Failure.mp4	7.4 MB
04. Planning For Failure.vtt	6.4 KB
05. What Do We Mean By Atomic.mp4	4.6 MB
05. What Do We Mean By Atomic.vtt	4.4 KB
06. Demo - Creating a Test Environment.mp4	20.2 MB
06. Demo - Creating a Test Environment.vtt	8.3 KB
07. Demo - Transferring Funds.mp4	17.8 MB
07. Demo - Transferring Funds.vtt	8.9 KB
08. Handling Conversion Errors.mp4	4.1 MB
08. Handling Conversion Errors.vtt	3.2 KB
09. Demo - Handling Conversion Errors.mp4	8.2 MB
09. Demo - Handling Conversion Errors.vtt	4.6 KB
10. Summary.mp4	2.1 MB
10. Summary.vtt	1.7 KB
/.../03. Exploring Transactions in SQL Server/
01. Introduction.mp4	3.6 MB
01. Introduction.vtt	3.2 KB
02. What Is the ACID Principle.mp4	4.8 MB
02. What Is the ACID Principle.vtt	5.2 KB
03. Transaction Modes in SQL Server.mp4	6.4 MB
03. Transaction Modes in SQL Server.vtt	5.6 KB
04. Demo - Transaction Modes.mp4	22.1 MB
04. Demo - Transaction Modes.vtt	9.5 KB
05. Isolation Levels.mp4	3.4 MB
05. Isolation Levels.vtt	3.2 KB
06. Demo - Isolation Levels.mp4	14.4 MB
06. Demo - Isolation Levels.vtt	6.9 KB
07. Nested Transactions.mp4	2.6 MB
07. Nested Transactions.vtt	2.8 KB
08. Demo - Nested Transactions.mp4	10.9 MB
08. Demo - Nested Transactions.vtt	5.2 KB
09. Demo - Save Points.mp4	9.0 MB
09. Demo - Save Points.vtt	4.7 KB
10. Summary.mp4	2.6 MB
10. Summary.vtt	2.3 KB
/.../04. Examining Error Handling Methods/
01. Introduction.mp4	4.5 MB
01. Introduction.vtt	4.2 KB
02. Examining an Error Message.mp4	6.6 MB
02. Examining an Error Message.vtt	7.4 KB
03. Errors Requiring Attention.mp4	3.6 MB
03. Errors Requiring Attention.vtt	3.3 KB
04. Exploring RAISERROR.mp4	3.3 MB
04. Exploring RAISERROR.vtt	3.1 KB
05. Demo - Error Message Details.mp4	18.4 MB
05. Demo - Error Message Details.vtt	8.5 KB
06. Demo - Using RAISERROR.mp4	16.8 MB
06. Demo - Using RAISERROR.vtt	8.2 KB
07. Exploring TRY..CATCH.mp4	3.6 MB
07. Exploring TRY..CATCH.vtt	3.7 KB
08. Error Handling Methods.mp4	3.4 MB
08. Error Handling Methods.vtt	3.1 KB
09. Demo - TRY..CATCH.mp4	17.3 MB
09. Demo - TRY..CATCH.vtt	6.5 KB
10. Demo - XACT_ABORT and XACT_STATE.mp4	19.3 MB
10. Demo - XACT_ABORT and XACT_STATE.vtt	6.6 KB
11. Exploring THROW.mp4	3.3 MB
11. Exploring THROW.vtt	3.4 KB
12. Demo - THROW.mp4	7.9 MB
12. Demo - THROW.vtt	4.5 KB
13. Summary.mp4	3.1 MB
13. Summary.vtt	2.4 KB
/1. Course Overview/
1. Course Overview.mp4	3.2 MB
1. Course Overview.vtt	2.1 KB
/.../5. Handling Errors in the Real World/
1. Introduction.mp4	4.3 MB
1. Introduction.vtt	3.8 KB
2. Comparing RAISERROR and THROW.mp4	4.9 MB
2. Comparing RAISERROR and THROW.vtt	4.3 KB
3. Demo - Error Handling Template.mp4	17.3 MB
3. Demo - Error Handling Template.vtt	8.2 KB
4. Demo - Actionable Message.mp4	22.0 MB
4. Demo - Actionable Message.vtt	10.1 KB
5. Demo - Enforcing Business Logic.mp4	12.5 MB
5. Demo - Enforcing Business Logic.vtt	5.7 KB
6. Demo - Row Count Mismatch.mp4	10.5 MB
6. Demo - Row Count Mismatch.vtt	5.5 KB
7. Demo - Error Table and Stored Procedure.mp4	21.3 MB
7. Demo - Error Table and Stored Procedure.vtt	9.5 KB
8. Course Summary.mp4	4.0 MB
8. Course Summary.vtt	3.5 KB
/Handling Errors in T-SQL By Jared Westover/
playlist.m3u	3.0 KB
/1. Course Overview/
1. Course Overview.mp4	4.9 MB
1. Course Overview.vtt	3.3 KB
/.../2. What Is T-SQL/
1. Version Check.mp4	499.3 KB
1. Version Check.vtt	0.0 KB
2. Module Introduction.mp4	700.2 KB
2. Module Introduction.vtt	0.7 KB
3. What Is T-SQL.mp4	5.8 MB
3. What Is T-SQL.vtt	5.1 KB
4. A Little SQL Server Architecture.mp4	8.3 MB
4. A Little SQL Server Architecture.vtt	6.9 KB
5. Tools.mp4	4.0 MB
5. Tools.vtt	3.2 KB
6. Demo - Tools.mp4	7.6 MB
6. Demo - Tools.vtt	4.6 KB
7. Module Review.mp4	2.3 MB
7. Module Review.vtt	1.9 KB
/.../3. Our First SELECT/
1. Module Introduction.mp4	863.4 KB
1. Module Introduction.vtt	0.8 KB
2. What Is a SQL Query.mp4	4.0 MB
2. What Is a SQL Query.vtt	3.8 KB
3. More Terminology.mp4	7.8 MB
3. More Terminology.vtt	6.0 KB
4. Demo - First SELECT.mp4	11.4 MB
4. Demo - First SELECT.vtt	6.4 KB
5. Module Review.mp4	1.2 MB
5. Module Review.vtt	1.1 KB
/.../4. The FROM Clause/
1. Module Introduction.mp4	573.3 KB
1. Module Introduction.vtt	0.5 KB
2. TSQL Demo Database.mp4	7.9 MB
2. TSQL Demo Database.vtt	5.5 KB
3. Demo - FROM Single Table.mp4	7.9 MB
3. Demo - FROM Single Table.vtt	3.7 KB
4. Introduction to Multiple Tables in FROM.mp4	9.6 MB
4. Introduction to Multiple Tables in FROM.vtt	5.5 KB
5. Demo - Multiple Tables.mp4	10.9 MB
5. Demo - Multiple Tables.vtt	5.9 KB
6. Module Review.mp4	1.5 MB
6. Module Review.vtt	1.5 KB
/.../5. Filtering with WHERE/
1. Module Introduction.mp4	741.5 KB
1. Module Introduction.vtt	0.8 KB
2. Understanding NULLs.mp4	2.9 MB
2. Understanding NULLs.vtt	2.9 KB
3. 3VL (Ternary) Logic.mp4	6.6 MB
3. 3VL (Ternary) Logic.vtt	5.5 KB
4. Logical Predicates and Operators.mp4	7.9 MB
4. Logical Predicates and Operators.vtt	6.8 KB
5. Filtering with WHERE.mp4	9.8 MB
5. Filtering with WHERE.vtt	5.6 KB
6. Module Review.mp4	1.3 MB
6. Module Review.vtt	1.5 KB
/6. Grouping Rows/
1. Module Introduction.mp4	704.8 KB
1. Module Introduction.vtt	0.7 KB
2. What Is Grouping Good For.mp4	27.0 MB
2. What Is Grouping Good For.vtt	4.7 KB
3. Grouping Rows.mp4	10.5 MB
3. Grouping Rows.vtt	7.5 KB
4. Group Filtering with HAVING.mp4	4.8 MB
4. Group Filtering with HAVING.vtt	3.0 KB
5. Module Review.mp4	3.7 MB
5. Module Review.vtt	2.8 KB
/.../7. Evaluating SELECT Expressions/
1. Module Introduction.mp4	757.5 KB
1. Module Introduction.vtt	0.7 KB
2. Evaluating SELECT Expressions.mp4	7.3 MB
2. Evaluating SELECT Expressions.vtt	4.8 KB
3. Dealing with NULLs.mp4	2.5 MB
3. Dealing with NULLs.vtt	2.2 KB
4. Using DISTINCT.mp4	6.3 MB
4. Using DISTINCT.vtt	3.6 KB
5. Module Review.mp4	920.5 KB
5. Module Review.vtt	1.0 KB
/.../8. Ordering and Paging/
1. Module Introduction.mp4	903.7 KB
1. Module Introduction.vtt	0.8 KB
2. Law of Order.mp4	4.9 MB
2. Law of Order.vtt	3.8 KB
3. ORDER BY.mp4	2.5 MB
3. ORDER BY.vtt	2.4 KB
4. Determinism and Tiebreakers.mp4	2.3 MB
4. Determinism and Tiebreakers.vtt	2.0 KB
5. Paging Result Sets.mp4	4.0 MB
5. Paging Result Sets.vtt	3.4 KB
6. Demo - Ordering and Paging.mp4	14.8 MB
6. Demo - Ordering and Paging.vtt	7.7 KB
7. Module Review.mp4	3.2 MB
7. Module Review.vtt	2.7 KB
/9. Wrapping Up/
1. Module Introduction.mp4	666.0 KB
1. Module Introduction.vtt	0.6 KB
2. Course Review.mp4	5.3 MB
2. Course Review.vtt	4.1 KB
3. Takeaway.mp4	2.8 MB
3. Takeaway.vtt	2.6 KB
4. Feedback.mp4	1.4 MB
4. Feedback.vtt	1.3 KB
5. Next Steps.mp4	2.0 MB
5. Next Steps.vtt	2.0 KB
6. Additional Resources and Conclusion.mp4	2.3 MB
6. Additional Resources and Conclusion.vtt	2.4 KB
/Querying Data Using T-SQL By Ami Levin/
playlist.m3u	2.3 KB
/1. Course Overview/
1. Course Overview.mp4	5.0 MB
1. Course Overview.vtt	3.4 KB
/.../2. Querying JSON with T-SQL/
1. Version Check.mp4	551.6 KB
1. Version Check.vtt	0.0 KB
2. Querying JSON in Microsoft SQL Server.mp4	7.4 MB
2. Querying JSON in Microsoft SQL Server.vtt	5.5 KB
3. What Is JSON What About JSON in SQL Server.mp4	11.5 MB
3. What Is JSON What About JSON in SQL Server.vtt	8.6 KB
4. Querying JSON Documents with T-SQL.mp4	9.1 MB
4. Querying JSON Documents with T-SQL.vtt	6.3 KB
5. Converting Data into JSON with FOR JSON PATH and AUTO.mp4	16.0 MB
5. Converting Data into JSON with FOR JSON PATH and AUTO.vtt	7.5 KB
6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.mp4	5.2 MB
6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.vtt	4.1 KB
7. Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4	12.0 MB
7. Parsing and Importing JSON with OPENROWSET and OPENJSON.vtt	9.3 KB
8. Handling Missing Properties with LAX and STRICT Mode.mp4	13.0 MB
8. Handling Missing Properties with LAX and STRICT Mode.vtt	7.5 KB
9. Takeaway.mp4	2.3 MB
9. Takeaway.vtt	2.0 KB
/.../3. Querying XML Data with T-SQL/
1. Querying XML Data in Microsoft SQL Server with T-SQL.mp4	3.4 MB
1. Querying XML Data in Microsoft SQL Server with T-SQL.vtt	2.8 KB
2. What is XML How Do I Build Good XML.mp4	12.4 MB
2. What is XML How Do I Build Good XML.vtt	8.9 KB
3. Selecting Data from XML - OPENXML and the query and value Methods.mp4	25.4 MB
3. Selecting Data from XML - OPENXML and the query and value Methods.vtt	14.8 KB
4. Getting to Know the XPath Syntax and XQuery Language.mp4	14.7 MB
4. Getting to Know the XPath Syntax and XQuery Language.vtt	11.5 KB
5. Providing Rowset Views with OPENXML and the nodes Method.mp4	15.9 MB
5. Providing Rowset Views with OPENXML and the nodes Method.vtt	9.9 KB
6. Updating XML with modify and the XML Data Modification Language.mp4	8.5 MB
6. Updating XML with modify and the XML Data Modification Language.vtt	5.8 KB
7. Filtering XML Data with Contains and Exist.mp4	8.9 MB
7. Filtering XML Data with Contains and Exist.vtt	5.3 KB
8. Takeaway.mp4	2.1 MB
8. Takeaway.vtt	2.1 KB
/.../4. Utilizing Temporal Tables/
1. Utilizing Temporal Tables.mp4	1.7 MB
1. Utilizing Temporal Tables.vtt	1.1 KB
2. Understanding Temporal or System-versioned Tables.mp4	7.3 MB
2. Understanding Temporal or System-versioned Tables.vtt	6.1 KB
3. Creating Temporal and History Tables.mp4	5.5 MB
3. Creating Temporal and History Tables.vtt	3.3 KB
4. Adding and Modifying Data in Temporal Tables.mp4	26.9 MB
4. Adding and Modifying Data in Temporal Tables.vtt	6.9 KB
5. Selecting Data from Temporal Tables at Specific Points in Time.mp4	10.0 MB
5. Selecting Data from Temporal Tables at Specific Points in Time.vtt	6.1 KB
6. Recovering Data in a Temporal Table.mp4	6.9 MB
6. Recovering Data in a Temporal Table.vtt	4.3 KB
7. Takeaway.mp4	2.1 MB
7. Takeaway.vtt	1.8 KB
/5. Final Takeaway/
1. Final Takeaway.mp4	4.3 MB
1. Final Takeaway.vtt	3.6 KB
/Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/
playlist.m3u	2.0 KB
/.../04. Modifying Data Using T-SQL Statements/
01. Modifying Data Using T-SQL Statements.mp4	1.6 MB
01. Modifying Data Using T-SQL Statements.vtt	1.2 KB
02. Modifying Records with the UPDATE Statement.mp4	4.6 MB
02. Modifying Records with the UPDATE Statement.vtt	3.3 KB
03. Using UPDATE to Modify Data in One Row.mp4	4.6 MB
03. Using UPDATE to Modify Data in One Row.vtt	2.7 KB
04. Using UPDATE to Modify Data in Multiple Rows.mp4	5.9 MB
04. Using UPDATE to Modify Data in Multiple Rows.vtt	2.6 KB
05. Retrieving Number of Affected Rows with @@Rowcount.mp4	5.9 MB
05. Retrieving Number of Affected Rows with @@Rowcount.vtt	3.4 KB
06. Modifying Data Using UPDATE with Constraints.mp4	8.3 MB
06. Modifying Data Using UPDATE with Constraints.vtt	4.8 KB
07. UPDATE Using Variables.mp4	9.2 MB
07. UPDATE Using Variables.vtt	5.0 KB
08. FROM and JOIN within an UPDATE.mp4	7.5 MB
08. FROM and JOIN within an UPDATE.vtt	3.7 KB
09. A Few More Details on UPDATE.mp4	4.6 MB
09. A Few More Details on UPDATE.vtt	2.6 KB
10. Takeaway.mp4	1.9 MB
10. Takeaway.vtt	1.8 KB
/1. Course Overview/
1. Course Overview.mp4	3.6 MB
1. Course Overview.vtt	2.2 KB
/.../2. Working with the T-SQL Data Manipulation Language/
1. Version Check.mp4	527.3 KB
1. Version Check.vtt	0.0 KB
2. Working with the T-SQL Data Manipulation Language.mp4	7.1 MB
2. Working with the T-SQL Data Manipulation Language.vtt	4.9 KB
3. Understanding and Differentiating the T-SQL Sub-languages.mp4	2.8 MB
3. Understanding and Differentiating the T-SQL Sub-languages.vtt	3.0 KB
4. What Is the T-SQL Data Manipulation Language.mp4	1.9 MB
4. What Is the T-SQL Data Manipulation Language.vtt	2.0 KB
5. The Database for This Training - StackOverflow or StackExchange.mp4	17.0 MB
5. The Database for This Training - StackOverflow or StackExchange.vtt	7.2 KB
6. What You Need to Know About SELECT for DML.mp4	19.9 MB
6. What You Need to Know About SELECT for DML.vtt	11.9 KB
7. What You Need to Know About WHERE for DML.mp4	14.9 MB
7. What You Need to Know About WHERE for DML.vtt	7.3 KB
8. Takeaway.mp4	989.8 KB
8. Takeaway.vtt	0.8 KB
/.../3. Adding Data Using T-SQL Statements/
1. Adding Data Using T-SQL Statements.mp4	1.9 MB
1. Adding Data Using T-SQL Statements.vtt	1.5 KB
2. Adding New Records with the INSERT Statement.mp4	5.7 MB
2. Adding New Records with the INSERT Statement.vtt	3.2 KB
3. An Insert Statement with Columns and Values.mp4	9.4 MB
3. An Insert Statement with Columns and Values.vtt	5.0 KB
4. An Insert Statement with All Values.mp4	4.2 MB
4. An Insert Statement with All Values.vtt	2.8 KB
5. An Insert Statement with NULL and DEFAULT.mp4	9.0 MB
5. An Insert Statement with NULL and DEFAULT.vtt	5.6 KB
6. An Insert Statement with an Identity.mp4	6.9 MB
6. An Insert Statement with an Identity.vtt	4.3 KB
7. An Insert Statement with Constraints.mp4	16.9 MB
7. An Insert Statement with Constraints.vtt	8.0 KB
8. Adding Multiple Records from a Data File with BULK INSERT.mp4	10.7 MB
8. Adding Multiple Records from a Data File with BULK INSERT.vtt	7.2 KB
9. Takeaway.mp4	1.5 MB
9. Takeaway.vtt	1.3 KB
/.../5. Removing Data Using T-SQL Statements/
1. Removing Data Using T-SQL Statements.mp4	2.0 MB
1. Removing Data Using T-SQL Statements.vtt	1.6 KB
2. Removing Records with the DELETE Statement.mp4	1.5 MB
2. Removing Records with the DELETE Statement.vtt	1.7 KB
3. Removing a Specific Record with DELETE.mp4	4.2 MB
3. Removing a Specific Record with DELETE.vtt	2.8 KB
4. Removing Multiple Records with DELETE.mp4	9.8 MB
4. Removing Multiple Records with DELETE.vtt	5.2 KB
5. Deleting Data Using JOINs.mp4	5.5 MB
5. Deleting Data Using JOINs.vtt	4.0 KB
6. Removing Data with Constraints and Cascade Deleting of Data.mp4	14.7 MB
6. Removing Data with Constraints and Cascade Deleting of Data.vtt	8.5 KB
7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp4	12.4 MB
7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.vtt	9.1 KB
8. Takeaway.mp4	2.1 MB
8. Takeaway.vtt	2.1 KB
/.../6. Maintaining Data Integrity with Transactions/
1. Maintaining Data Integrity with Transactions.mp4	4.3 MB
1. Maintaining Data Integrity with Transactions.vtt	3.8 KB
2. Transaction Properties.mp4	2.0 MB
2. Transaction Properties.vtt	2.5 KB
3. Understanding T-SQL Transactions.mp4	4.0 MB
3. Understanding T-SQL Transactions.vtt	4.6 KB
4. Creating Transactions Using BEGIN and COMMIT.mp4	16.4 MB
4. Creating Transactions Using BEGIN and COMMIT.vtt	10.6 KB
5. Querying Data Locked in a Transaction with NOLOCK.mp4	6.2 MB
5. Querying Data Locked in a Transaction with NOLOCK.vtt	4.7 KB
6. Undoing Transactions Using ROLLBACK.mp4	5.3 MB
6. Undoing Transactions Using ROLLBACK.vtt	3.8 KB
7. Partially Undoing Transactions Using Savepoints.mp4	11.2 MB
7. Partially Undoing Transactions Using Savepoints.vtt	7.5 KB
8. Distributed Transactions at a High Level.mp4	2.5 MB
8. Distributed Transactions at a High Level.vtt	2.1 KB
9. Takeaway.mp4	1.9 MB
9. Takeaway.vtt	1.9 KB
/.../7. Using Advanced T-SQL Techniques/
1. Using Advanced T-SQL Techniques.mp4	1.6 MB
1. Using Advanced T-SQL Techniques.vtt	1.1 KB
2. Using INSERT with Multiple Values.mp4	4.5 MB
2. Using INSERT with Multiple Values.vtt	3.1 KB
3. SELECT within an INSERT Statement.mp4	8.7 MB
3. SELECT within an INSERT Statement.vtt	5.4 KB
4. Using SELECT to Retrieve a Specific Field in an INSERT.mp4	7.0 MB
4. Using SELECT to Retrieve a Specific Field in an INSERT.vtt	4.2 KB
5. Retrieving Records on INSERT Using the OUTPUT Clause.mp4	13.3 MB
5. Retrieving Records on INSERT Using the OUTPUT Clause.vtt	6.7 KB
6. Utilizing MERGE to Perform Operations on a Target Table.mp4	12.6 MB
6. Utilizing MERGE to Perform Operations on a Target Table.vtt	7.4 KB
7. BULK INSERT Using a Format File.mp4	13.3 MB
7. BULK INSERT Using a Format File.vtt	6.9 KB
8. Takeaway.mp4	2.9 MB
8. Takeaway.vtt	2.6 KB
/8. Final Takeaway/
1. Final Takeaway.mp4	6.4 MB
1. Final Takeaway.vtt	5.8 KB
/T-SQL Data Manipulation Playbook By Xavier Morera/
playlist.m3u	4.6 KB
/01/demos/demos/m02/
demo-01-querying-json-documents.sql	0.4 KB
demo-02-convert-data-into-json.sql	0.5 KB
demo-03-convert-data-into-json.sql	0.3 KB
demo-04-parsing-and-importing-json.sql	0.2 KB
demo-05-parsing-and-importing-json.sql	0.5 KB
demo-06-lax-and-strict-mode.sql	0.5 KB
top-posts.json	0.3 KB
/01/demos/demos/m03/
demo-01-selecting-data-from-mxl.sql	3.8 KB
demo-02-selecting-data-from-xml.sql	0.5 KB
demo-03-providing-rowset-view-with-openmxl.sql	1.3 KB
demo-04-providing-rowset-view-with-nodes.sql	1.2 KB
demo-05-modifying-xml-data.sql	1.0 KB
demo-06-working-with-xpath-query-syntax.sql	0.5 KB
demo-07-filtering-data-using-contains-and-exist.sql	0.4 KB
posts.xml	3.3 KB
/01/demos/demos/m04/
demo-01-creating-temporal-tables.sql	0.7 KB
demo-02-modifying-data-in-temporal-tables.sql	1.7 KB
demo-03-selecting-data-from-temporal-tables.sql	0.4 KB
demo-04-recovering-a-temporal-table.sql	0.6 KB
/02/
creating-measures-with-aggregation-functions-slides.pdf	1.0 MB
exploring-the-benefits-of-stored-procedures-slides.pdf	442.9 KB
getting-started-with-error-handling-in-t-sql-slides.pdf	1.1 MB
querying-json-with-t-sql-slides.pdf	2.0 MB
setting-up-the-sql-server-environment-slides.pdf	1.8 MB
what-is-t-sql-slides.pdf	1.0 MB
working-with-the-t-sql-data-manipulation-language-slides.pdf	2.4 MB
/02/demos/
Module 2 - What is TSQL - Code and Links.sql	1.3 KB
SELECT.txt	3.0 KB
WHERE.txt	1.2 KB
/02/demos/m2-demos/
01_Creating_Demo_Environment.sql	6.1 KB
02_Modify_Sales_Report.sql	0.5 KB
02_Transferring_Funds.sql	2.5 KB
03_Handling_Conversion_Errors.sql	1.0 KB
03_Limiting_User_Access.sql	0.7 KB
04_Execution_Plan_Reuse.sql	3.4 KB
/03/
adding-data-using-t-sql-statements-slides.pdf	1.4 MB
creating-our-first-stored-procedure-slides.pdf	214.8 KB
exploring-transactions-in-sql-server-slides.pdf	714.0 KB
our-first-select-slides.pdf	677.3 KB
querying-xml-data-with-t-sql-slides.pdf	1.7 MB
ranking-data-with-rank-and-partition-slides.pdf	151.3 KB
shaping-data-in-a-query-slides.pdf	1.6 MB
/03/demos/
INSERT.txt	10.5 KB
Module 3 -Our First SELECT - Code and Links.sql	1.6 KB
/03/demos/m3-demos/
01_Creating_and_Executing_Stored_Procedures.sql	1.4 KB
01_Transaction_Modes.sql	2.4 KB
02_Isolation_Levels_Read.sql	0.7 KB
02_Isolation_Levels_Update.sql	0.9 KB
02_Using_Parameters.sql	1.7 KB
03_Nested_Transactions.sql	1.4 KB
03_Using_Debugger_Part1.sql	0.3 KB
03_Using_Debugger_Part2.sql	0.5 KB
04_Save_Points.sql	1.0 KB
/04/
aggregating-and-summarizing-data-with-functions-slides.pdf	237.9 KB
examining-error-handling-methods-slides.pdf	799.8 KB
modifying-data-using-t-sql-statements-slides.pdf	1.1 MB
querying-data-from-multiple-tables-using-joins-slides.pdf	1.3 MB
setting-up-queries-in-stored-procedures-slides.pdf	227.5 KB
the-from-clause-slides.pdf	538.3 KB
utilizing-temporal-tables-slides.pdf	1.1 MB
/04/demos/
Module 4 - FROM Multi Sources - Code and Links.sql	0.7 KB
Module 4 - FROM Single Source - Code and Links.sql	1.0 KB
Module 4 - TSQL Demo DB.sql	2.9 KB
UPDATE.txt	2.9 KB
/04/demos/m4-demos/
01_Adding_Sales_People.sql	1.5 KB
01_Expand_ABCCompany_Database.sql	330.8 KB
01_SQL_Errors.sql	1.4 KB
02_Temporary_Objects.sql	2.7 KB
02_Using_RAISERROR.sql	1.6 KB
03_TRY_CATCH.sql	4.0 KB
03_Table_Valued_Parameters.sql	1.0 KB
04_Sp_executesql.sql	2.9 KB
04_XACT_ABORT_XACT_STATE.sql	4.5 KB
05_Debug_Flag.sql	1.8 KB
05_Using_THROW.sql	0.7 KB
/05/demos/
DELETE.txt	7.4 KB
Module 5 - Filtering with WHERE - Code and Links.sql	1.5 KB
/05/demos/m5-demos/
01_Baseline_Statistics.sql	2.8 KB
01_Basic_Template.sql	2.2 KB
02_Actionable_Message.sql	2.8 KB
02_Temp_Table_Plan_Reuse.sql	4.7 KB
03_Enforce_Business_Logic.sql	1.5 KB
03_Select_1_Versus_Select_Star.sql	2.3 KB
04_Parameter_Sniffing.sql	3.0 KB
04_Row_Count_Mismatch.sql	1.5 KB
05_Error_Table.sql	3.7 KB
/05/
filtering-and-controlling-flow-slides.pdf	1.8 MB
filtering-with-where-slides.pdf	659.5 KB
final-takeaway-slides.pdf	162.2 KB
handling-errors-in-the-real-world-slides.pdf	430.1 KB
optimizing-stored-procedure-performance-slides.pdf	269.2 KB
removing-data-using-t-sql-statements-slides.pdf	808.9 KB
substituting-a-table-reference-with-a-rowset-function-slides.pptx	548.3 KB
/06/
building-stored-procedures-in-the-real-world-slides.pdf	179.3 KB
grouping-rows-slides.pdf	1.0 MB
limiting-the-results-with-t-sql-functions-slides.pdf	739.8 KB
maintaining-data-integrity-with-transactions-slides.pdf	1.5 MB
query-data-with-inline-queries-and-scalar-functions-slides.pdf	1.6 MB
/06/demos/
Module 6 - GROUP BY - Code and Links.sql	0.9 KB
Module 6 - HAVING - Code and Links.sql	0.7 KB
TRANSACTION.txt	3.3 KB
/06/demos/m6-demos/
01_UpdateInsertProcedure_Template.sql	0.8 KB
/07/
aggregating-data-in-a-query-slides.pdf	301.4 KB
evaluating-select-expressions-slides.pdf	446.4 KB
query-data-with-static-value-functions-slides.pdf	292.2 KB
using-advanced-t-sql-techniques-slides.pdf	1.2 MB
/07/demos/
Advanced.txt	7.5 KB
Module 7 - All-at-once - Code and Links.sql	0.8 KB
Module 7 - DISTINCT - Code and Links.sql	0.9 KB
/08/demos/
Module 8 - ORDER BY and Paging - Code and Links.sql	1.3 KB
/08/
final-takeaway-slides.pdf	409.0 KB
implementing-if-then-logic-slides.pdf	191.5 KB
ordering-and-paging-slides.pdf	689.3 KB
using-t-sql-set-operators-slides.pdf	1.2 MB
/09/
combining-queries-with-coalesce-slides.pdf	227.4 KB
simplifying-with-intermediate-tables-and-common-table-expressions-slides.pdf	794.5 KB
wrapping-up-slides.pdf	1.5 MB
/09/demos/
Module 9 - Wrapping Up - Links.sql	0.4 KB
/1. Course Overview/
1. Course Overview.mp4	4.5 MB
1. Course Overview.vtt	2.2 KB
/.../10. Calculating Values Using String Functions/
1. Calculating Values Using String Functions.mp4	8.3 MB
1. Calculating Values Using String Functions.vtt	6.0 KB
2. Formatting Strings with Stuff and Replace.mp4	10.6 MB
2. Formatting Strings with Stuff and Replace.vtt	5.8 KB
3. Cutting out the Product Attributes.mp4	9.6 MB
3. Cutting out the Product Attributes.vtt	5.7 KB
4. Pivoting the Attributes.mp4	10.6 MB
4. Pivoting the Attributes.vtt	3.9 KB
5. Analysing Sales Using Product Attributes.mp4	11.1 MB
5. Analysing Sales Using Product Attributes.vtt	5.5 KB
/10/
calculating-values-using-string-functions-slides.pdf	227.4 KB
summary-slides.pdf	1.0 MB
/.../11. Calculating Values Using Numeric Scalar Functions/
1. Calculating Values Using Numeric Scalar Functions.mp4	11.0 MB
1. Calculating Values Using Numeric Scalar Functions.vtt	5.0 KB
2. The Round Function.mp4	8.9 MB
2. The Round Function.vtt	4.7 KB
3. Creating A B Customer Tags with Modulus.mp4	12.6 MB
3. Creating A B Customer Tags with Modulus.vtt	5.8 KB
4. Creating Alternating Customer A B Tags.mp4	4.2 MB
4. Creating Alternating Customer A B Tags.vtt	1.8 KB
/11/
calculating-values-using-numeric-scalar-functions-slides.pdf	655.8 KB
/.../2. Creating Measures with Aggregation Functions/
1. Creating Measures with Aggregation Functions.mp4	8.3 MB
1. Creating Measures with Aggregation Functions.vtt	5.3 KB
2. A Tour of the Data.mp4	7.0 MB
2. A Tour of the Data.vtt	3.7 KB
3. Creating an Aggregation Query.mp4	7.0 MB
3. Creating an Aggregation Query.vtt	4.2 KB
4. Querying Unique Lists of Values.mp4	8.5 MB
4. Querying Unique Lists of Values.vtt	4.3 KB
5. Querying Aggregations in Lists.mp4	14.6 MB
5. Querying Aggregations in Lists.vtt	8.6 KB
/.../3. Ranking Data with RANK and PARTITION/
1. Ranking Data with Rank and Partition.mp4	11.2 MB
1. Ranking Data with Rank and Partition.vtt	7.2 KB
2. The Rank Function.mp4	8.7 MB
2. The Rank Function.vtt	5.1 KB
3. The Dense Rank Function.mp4	14.7 MB
3. The Dense Rank Function.vtt	7.1 KB
4. The NTILE Function.mp4	6.8 MB
4. The NTILE Function.vtt	4.2 KB
/.../4. Aggregating and Summarizing Data with Functions/
1. Aggregating and Summarizing Data with Functions.mp4	8.5 MB
1. Aggregating and Summarizing Data with Functions.vtt	5.9 KB
2. The Percent Rank Function.mp4	13.6 MB
2. The Percent Rank Function.vtt	5.2 KB
3. First and Last Value.mp4	12.4 MB
3. First and Last Value.vtt	8.1 KB
/.../5. Substituting a Table Reference with a ROWSET Function/
1. Substituting a Table Reference with a ROWSET Function.mp4	13.7 MB
1. Substituting a Table Reference with a ROWSET Function.vtt	7.8 KB
2. OPENROWSET Queries.mp4	10.0 MB
2. OPENROWSET Queries.vtt	5.8 KB
/.../6. Query Data with Inline Queries and Scalar Functions/
1. Query Data with Inline Queries and Scalar Functions.mp4	5.7 MB
1. Query Data with Inline Queries and Scalar Functions.vtt	4.9 KB
2. Searching for Strings with the LIKE Function.mp4	4.2 MB
2. Searching for Strings with the LIKE Function.vtt	3.9 KB
3. LIKE Function Demo.mp4	11.2 MB
3. LIKE Function Demo.vtt	5.0 KB
4. Creating Statements with Simple Scalar Functions.mp4	10.2 MB
4. Creating Statements with Simple Scalar Functions.vtt	5.3 KB
5. Formatting Functions.mp4	7.2 MB
5. Formatting Functions.vtt	4.4 KB
6. Inline View Queries and Subqueries.mp4	16.6 MB
6. Inline View Queries and Subqueries.vtt	8.0 KB
7. The Subquery.mp4	6.8 MB
7. The Subquery.vtt	3.5 KB
/.../7. Query Data with Static Value Functions/
1. Query Data with Static Value Functions.mp4	10.5 MB
1. Query Data with Static Value Functions.vtt	5.4 KB
2. Monthly Rolling Sales with GETDATE.mp4	9.5 MB
2. Monthly Rolling Sales with GETDATE.vtt	5.7 KB
/.../8. Implementing IF Then Logic/
1. Implementing IF Then Logic.mp4	3.7 MB
1. Implementing IF Then Logic.vtt	3.2 KB
2. Product Groups.mp4	15.9 MB
2. Product Groups.vtt	7.4 KB
3. Product Gender.mp4	15.4 MB
3. Product Gender.vtt	8.4 KB
4. Intelligent Measures.mp4	7.8 MB
4. Intelligent Measures.vtt	3.4 KB
/.../9. Combining Queries with COALESCE/
1. Combining Queries with COALESCE.mp4	13.9 MB
1. Combining Queries with COALESCE.vtt	7.5 KB
2. Adding the COALESCE Function to a Query.mp4	11.3 MB
2. Adding the COALESCE Function to a Query.vtt	4.0 KB
3. Joining Multiple Queries with COALESCE.mp4	5.7 MB
3. Joining Multiple Queries with COALESCE.vtt	2.8 KB
/.../Queries Reports Charts Data Files/
Combining and Filtering Data with T-SQL Final Report.sql	3.9 KB
DataTableExample.html	69.8 KB
M3 - Calling a User Defined Function.sql	0.6 KB
M3 - Casting and Converting Data Types 2.sql	1.5 KB
M3 - Casting and Converting Data Types.sql	0.5 KB
M3 - Casting and Converting in T-SQL.sql	0.9 KB
M3 - Character Functions.sql	0.7 KB
M3 - Concatenation sample.sql	3.0 KB
M3 - Datepart.sql	3.3 KB
M3 - Employee tenure with DATE - CASE.sql	3.4 KB
M3 - Formatting Character Functions.sql	1.8 KB
M3 - Formatting Dates and Numerical Values.sql	0.1 KB
M3 - Formatting String - PatIndex.sql	1.1 KB
M3 - Formatting Strings - Adding Concatenation.sql	0.8 KB
M3 - Formatting Strings - Characters 2.sql	0.8 KB
M3 - Formatting Strings - Characters.sql	0.6 KB
M3 - Formatting Strings - REPLACE.sql	0.5 KB
M3 - Formatting Strings - SUBSTRINGS.sql	1.0 KB
M3 - Formatting Strings - Simplifying with temps and UDFs.sql	1.5 KB
M3 - Formatting Strings - TRIM.sql	0.5 KB
M3 - Formatting Strings - UPPER and LOWER.sql	0.5 KB
M3 - Formatting Strings 2.sql	0.2 KB
M3 - Formatting Strings.sql	6.3 KB
M3 - Formatting numeric values and ordering.sql	0.7 KB
M3 - Numeric Order of Operations.sql	0.4 KB
M3 - Order Details Case When Example for due date.sql	1.8 KB
M3 - REGEX.sql	0.6 KB
M3 - User Defined Functions OrderAmountPurchased.sql	1.7 KB
M3 - User Defined Functions Proper.sql	1.3 KB
M3 - User Defined Functions ProperWithCharacters.sql	3.7 KB
M3 - Working with Numbers.sql	1.0 KB
M4 - Analyzing with FULL OUTER Join.sql	0.7 KB
M4 - FULL OUTER Join.sql	0.6 KB
M4 - Formatted FULL OUTER Join.sql	1.4 KB
M4 - Formatted Inner Joins.sql	0.5 KB
M4 - Inner Joins Formatted Report.sql	0.5 KB
M4 - Inner Joins.sql	1.0 KB
M4 - JOIN.sql	0.7 KB
M4 - Joining from multiple databases.sql	0.2 KB
M4 - LEFT JOIN.sql	0.5 KB
M4 - RIGHT JOIN.sql	1.4 KB
M4 - RIGHT Joins.sql	0.5 KB
M4 - Self Joins 3.sql	0.2 KB
M4 - Self Joins example 2.sql	0.2 KB
M4 - Self Joins.sql	0.3 KB
M5 - Comparison operators and NULL.sql	1.0 KB
M5 - Controlling Flow IsNumeric and GOTO.sql	0.5 KB
M5 - Controlling Flow with IF.sql	2.6 KB
M5 - Controlling Flow with WHILE-BREAK-CONTINUE-GOTO.sql	0.8 KB
M5 - Filtering Query Results.sql	0.7 KB
M5 - Filtering for NULL 1.sql	0.2 KB
M5 - Filtering for NULL 2.sql	0.5 KB
M5 - Filtering the table examples.sql	0.9 KB
M5 - Filtering using IN and NOT IN.sql	0.4 KB
M5 - Filtering with Logical Operators.sql	2.4 KB
M5 - Filtering with Strings.sql	1.9 KB
M5 - LIKE and NOT LIKE filtering.sql	0.6 KB
M5 - Logical Operators.sql	0.8 KB
M5 - Logical and Logical Operators.sql	4.5 KB
M5 - Using quantifiers to filter.sql	0.8 KB
M6 - FETCH NEXT.sql	1.0 KB
M6 - TOP Functions.sql	2.2 KB
M7 - Products COUNT query 2.sql	0.4 KB
M7 - Products COUNT query.sql	0.8 KB
M7 - Using AVG in T-SQL 1.sql	0.6 KB
M7 - Using AVG in T-SQL 2.sql	0.9 KB
M7 - Using COUNT in T-SQL.sql	1.3 KB
M7 - Using MIN MAX in T-SQL.sql	0.5 KB
M7 - Using SUM in T-SQL.sql	0.6 KB
M7-Average Sold Products with variables.rpt	6.7 KB
M7-Company Sales with Min Max and Avg.rpt	8.1 KB
M7-Products and the number of times ordered.rpt	3.7 KB
M7-Products number of times ordered and number of products sold.rpt	4.9 KB
M8 - Except.sql	0.8 KB
M8 - Intercect.sql	0.6 KB
M8 - Union All.sql	1.0 KB
M8 - Union.sql	0.5 KB
M9 - CTE Report.rpt	2.0 KB
M9 - Common Table Expressions.sql	2.9 KB
M9 - Cursors with TMP Table for updating.sql	0.9 KB
M9 - Temprorary Tables 2.sql	1.9 KB
M9 - Temprorary Tables.sql	1.5 KB
M9 - Using Cursors in T-SQL.sql	0.5 KB
SQL Server 2019 Editions Datasheet.pdf	151.0 KB
SQL Server Data Type Conversion Chart.png	44.8 KB
suppliers and products.rpt	5.0 KB
/.../Queries Reports Charts Data Files/Data Files/
NorthwindObjectsAndData.sql	1.4 MB
WideWorldImporters-Standard.bak	590.6 MB
/T-SQL Functions Playbook By Andrew McSwiggan/
TSFP_2021.bak	577.9 MB
playlist.m3u	3.4 KB
/database-backup/
comments.csv	0.3 KB
tsql-dml-script.sql	237.6 MB
tsql-dml.bak	34.4 MB
/demos/data/
tsql-xjt.bak	307.4 MB
tsql-xml-json-backup.sql	389.2 MB
/demos/m02/
demo-01-querying-json-documents.sql	0.4 KB
demo-02-convert-data-into-json.sql	0.5 KB
demo-03-convert-data-into-json.sql	0.3 KB
demo-04-parsing-and-importing-json.sql	0.2 KB
demo-05-parsing-and-importing-json.sql	0.5 KB
demo-06-lax-and-strict-mode.sql	0.5 KB
top-posts.json	0.3 KB
/demos/m03/
demo-01-selecting-data-from-mxl.sql	3.8 KB
demo-02-selecting-data-from-xml.sql	0.5 KB
demo-03-providing-rowset-view-with-openmxl.sql	1.3 KB
demo-04-providing-rowset-view-with-nodes.sql	1.2 KB
demo-05-modifying-xml-data.sql	1.0 KB
demo-06-working-with-xpath-query-syntax.sql	0.5 KB
demo-07-filtering-data-using-contains-and-exist.sql	0.4 KB
posts.xml	3.3 KB
/demos/m04/
demo-01-creating-temporal-tables.sql	0.7 KB
demo-02-modifying-data-in-temporal-tables.sql	1.7 KB
demo-03-selecting-data-from-temporal-tables.sql	0.4 KB
demo-04-recovering-a-temporal-table.sql	0.6 KB
/initial-setup/
Instructions.txt	0.8 KB
Total files 870