download скачать Free download скачать : Pluralsight - Querying Data with T-SQL from SQL Server
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:2.37 GB

Files Included :

01  Version Check.mp4 (713.44 KB)
MP4
02  Introduction.mp4 (4.41 MB)
MP4
03  What Is a Stored Procedure.mp4 (3.74 MB)
MP4
04  Comparing Data Fetching Options.mp4 (8 MB)
MP4
05  Primary Stored Procedure Benefits.mp4 (3.82 MB)
MP4
06  Demo - Creating Test Environment.mp4 (16.95 MB)
MP4
07  Demo - Minimizing Modifications.mp4 (7.03 MB)
MP4
08  Exploring Security Benefits.mp4 (3.17 MB)
MP4
09  Demo - Limiting User Access.mp4 (7.54 MB)
MP4
10  Exploring Performance Gains.mp4 (3.06 MB)
MP4
11  Demo - Execution Plan Reuse.mp4 (14.45 MB)
MP4
12  Disadvantages of Stored Procedures.mp4 (3.67 MB)
MP4
13  Summary.mp4 (2.45 MB)
MP4
01  Introduction.mp4 (4.04 MB)
MP4
02  Creating Our Stored Procedure.mp4 (2.96 MB)
MP4
03  Exploring New Syntax and Executing.mp4 (4.58 MB)
MP4
04  Naming Stored Procedures.mp4 (3.86 MB)
MP4
05  Demo - Creating and Executing.mp4 (14.24 MB)
MP4
06  Demo - Scripting Stored Procedures.mp4 (12.91 MB)
MP4
07  Exploring Parameters.mp4 (3.31 MB)
MP4
08  Demo - Adding Parameters.mp4 (15.6 MB)
MP4
09  Exploring Debugger.mp4 (3.03 MB)
MP4
10  Demo - Debugging Code.mp4 (12.81 MB)
MP4
11  Reviewing Best Practices.mp4 (4.08 MB)
MP4
12  Summary.mp4 (2.91 MB)
MP4
01  Introduction.mp4 (4.94 MB)
MP4
02  Building Queries in Stored Procedures.mp4 (2.41 MB)
MP4
03  Reviewing Temporary Objects.mp4 (4.21 MB)
MP4
04  Creating Temporary Objects.mp4 (3.46 MB)
MP4
05  Demo - Adding Queries to Stored Procedures.mp4 (19.88 MB)
MP4
06  Demo - Using Temporary Objects.mp4 (21.15 MB)
MP4
07  Exploring Table Valued Parameters.mp4 (5.03 MB)
MP4
08  Demo - Table Valued Parameters.mp4 (8.73 MB)
MP4
09  Examining Sp executesql.mp4 (4.72 MB)
MP4
10  Demo - Using Sp executesql.mp4 (14.82 MB)
MP4
11  Implementing a Debug Flag.mp4 (2.8 MB)
MP4
12  Demo - Adding a Debug Flag.mp4 (9.16 MB)
MP4
13  Summary.mp4 (2.69 MB)
MP4
1  Course Overview.mp4 (3.45 MB)
MP4
1  Introduction.mp4 (5.11 MB)
MP4
2  Creating a Baseline.mp4 (4.1 MB)
MP4
3  Demo - Gathering Baseline Stats.mp4 (20.07 MB)
MP4
4  Busting Performance Myths.mp4 (4.45 MB)
MP4
5  Demo - Temp Table Myth.mp4 (12.95 MB)
MP4
6  Demo - Select 1 Versus Select.mp4 (12.05 MB)
MP4
7  Exploring Parameter Sniffing.mp4 (3.55 MB)
MP4
8  Demo - Parameter Sniffing.mp4 (23.34 MB)
MP4
9  Summary.mp4 (2.64 MB)
MP4
1  Introduction.mp4 (2.9 MB)
MP4
2  Defining Stored Procedure Templates.mp4 (3.06 MB)
MP4
3  Demo - Creating Templates.mp4 (15.64 MB)
MP4
4  Exploring Key Takeaways.mp4 (3.83 MB)
MP4
5  Continuing the Journey.mp4 (2.68 MB)
MP4
1  Course Overview.mp4 (4.07 MB)
MP4
1  Summary.mp4 (1.48 MB)
MP4
1  Version Check.mp4 (570.23 KB)
MP4
2  Introduction.mp4 (4.27 MB)
MP4
3  Setting up the SQL Server Environment.mp4 (6.72 MB)
MP4
4  Creating SQL Server Databases.mp4 (10.48 MB)
MP4
5  Using SQL Server Management Studio.mp4 (30.29 MB)
MP4
6  Summary and Resources.mp4 (1.18 MB)
MP4
1  Introduction.mp4 (3.47 MB)
MP4
2  The SELECT Query Syntax.mp4 (1.82 MB)
MP4
3  Concatenating Values in T-SQL.mp4 (10.25 MB)
MP4
4  Casting and Converting Data Types.mp4 (17.38 MB)
MP4
5  Formatting Strings.mp4 (21.11 MB)
MP4
6  Working with Characters.mp4 (28.4 MB)
MP4
7  Formatting Dates and Numbers.mp4 (31.47 MB)
MP4
8  Review and Resources.mp4 (1.58 MB)
MP4
1  Introduction.mp4 (1.51 MB)
MP4
2  Understanding Primary and Foreign Keys.mp4 (8.09 MB)
MP4
3  Using the Inner Join.mp4 (12.25 MB)
MP4
4  Left and Right Joins.mp4 (11.15 MB)
MP4
5  Full OUTER Joins.mp4 (11.66 MB)
MP4
6  Self Join.mp4 (20.26 MB)
MP4
7  Review and Resources.mp4 (2.3 MB)
MP4
1  Introduction.mp4 (2.25 MB)
MP4
2  Expressions and Comparison Operators.mp4 (30.68 MB)
MP4
3  Applying T-SQL Logical Operators.mp4 (20.89 MB)
MP4
4  Controlling Flow with T-SQL Logic.mp4 (20.86 MB)
MP4
5  Review and Resources.mp4 (2.43 MB)
MP4
1  Introduction.mp4 (3.07 MB)
MP4
2  Offset and Fetch.mp4 (6.66 MB)
MP4
3  TOP Functions.mp4 (11.91 MB)
MP4
4  Using Variables to Limit Results.mp4 (9.52 MB)
MP4
5  Review and Resources.mp4 (1.94 MB)
MP4
1  Introduction.mp4 (993.25 KB)
MP4
2  Using COUNT in T-SQL.mp4 (22.33 MB)
MP4
3  Using SUM in T-SQL.mp4 (9.79 MB)
MP4
4  Using AVG in T-SQL.mp4 (23.14 MB)
MP4
5  Using MIN and MAX in T-SQL.mp4 (23.04 MB)
MP4
6  Review and Resources.mp4 (1.24 MB)
MP4
1  Introduction.mp4 (1.06 MB)
MP4
2  Difference between Joins and Set Operators.mp4 (1.22 MB)
MP4
3  Union All.mp4 (5.13 MB)
MP4
4  Union.mp4 (3.4 MB)
MP4
5  Intersect.mp4 (7.83 MB)
MP4
6  Except.mp4 (11.36 MB)
MP4
7  Review and Resources.mp4 (2.87 MB)
MP4
1  Introduction.mp4 (1.14 MB)
MP4
2  Using Common Table Expressions in T-SQL.mp4 (22.86 MB)
MP4
3  Using Temporary Tables in T-SQL.mp4 (10.28 MB)
MP4
4  Using Cursors in T-SQL.mp4 (15.36 MB)
MP4
5  Review and Resources.mp4 (1.53 MB)
MP4
01  Version Check.mp4 (679.5 KB)
MP4
02  Introduction.mp4 (3.9 MB)
MP4
03  Why Care About Error Handling.mp4 (4.71 MB)
MP4
04  Planning For Failure.mp4 (7.06 MB)
MP4
05  What Do We Mean By Atomic.mp4 (4.36 MB)
MP4
06  Demo - Creating a Test Environment.mp4 (19.25 MB)
MP4
07  Demo - Transferring Funds.mp4 (16.98 MB)
MP4
08  Handling Conversion Errors.mp4 (3.88 MB)
MP4
09  Demo - Handling Conversion Errors.mp4 (7.82 MB)
MP4
10  Summary.mp4 (2.03 MB)
MP4
01  Introduction.mp4 (3.42 MB)
MP4
02  What Is the ACID Principle.mp4 (4.57 MB)
MP4
03  Transaction Modes in SQL Server.mp4 (6.1 MB)
MP4
04  Demo - Transaction Modes.mp4 (21.08 MB)
MP4
05  Isolation Levels.mp4 (3.22 MB)
MP4
06  Demo - Isolation Levels.mp4 (13.72 MB)
MP4
07  Nested Transactions.mp4 (2.47 MB)
MP4
08  Demo - Nested Transactions.mp4 (10.42 MB)
MP4
09  Demo - Save Points.mp4 (8.62 MB)
MP4
10  Summary.mp4 (2.51 MB)
MP4
01  Introduction.mp4 (4.31 MB)
MP4
02  Examining an Error Message.mp4 (6.26 MB)
MP4
03  Errors Requiring Attention.mp4 (3.43 MB)
MP4
04  Exploring RAISERROR.mp4 (3.13 MB)
MP4
05  Demo - Error Message Details.mp4 (17.54 MB)
MP4
06  Demo - Using RAISERROR.mp4 (15.99 MB)
MP4
07  Exploring TRY  CATCH.mp4 (3.41 MB)
MP4
08  Error Handling Methods.mp4 (3.29 MB)
MP4
09  Demo - TRY  CATCH.mp4 (16.46 MB)
MP4
10  Demo - XACT ABORT and XACT STATE.mp4 (18.43 MB)
MP4
11  Exploring THROW.mp4 (3.17 MB)
MP4
12  Demo - THROW.mp4 (7.55 MB)
MP4
13  Summary.mp4 (3 MB)
MP4
1  Course Overview.mp4 (3.03 MB)
MP4
1  Introduction.mp4 (4.1 MB)
MP4
2  Comparing RAISERROR and THROW.mp4 (4.71 MB)
MP4
3  Demo - Error Handling Template.mp4 (16.47 MB)
MP4
4  Demo - Actionable Message.mp4 (20.95 MB)
MP4
5  Demo - Enforcing Business Logic.mp4 (11.95 MB)
MP4
6  Demo - Row Count Mismatch.mp4 (10.03 MB)
MP4
7  Demo - Error Table and Stored Procedure.mp4 (20.31 MB)
MP4
8  Course Summary.mp4 (3.8 MB)
MP4
1  Course Overview.mp4 (4.68 MB)
MP4
1  Version Check.mp4 (487.6 KB)
MP4
2  Module Introduction.mp4 (683.81 KB)
MP4
3  What Is T-SQL.mp4 (5.49 MB)
MP4
4  A Little SQL Server Architecture.mp4 (7.87 MB)
MP4
5  Tools.mp4 (3.86 MB)
MP4
6  Demo - Tools.mp4 (7.27 MB)
MP4
7  Module Review.mp4 (2.18 MB)
MP4
1  Module Introduction.mp4 (843.13 KB)
MP4
2  What Is a SQL Query.mp4 (3.8 MB)
MP4
3  More Terminology.mp4 (7.44 MB)
MP4
4  Demo - First SELECT.mp4 (10.84 MB)
MP4
5  Module Review.mp4 (1.17 MB)
MP4
1  Module Introduction.mp4 (559.83 KB)
MP4
2  TSQL Demo Database.mp4 (7.52 MB)
MP4
3  Demo - FROM Single Table.mp4 (7.51 MB)
MP4
4  Introduction to Multiple Tables in FROM.mp4 (9.19 MB)
MP4
5  Demo - Multiple Tables.mp4 (10.44 MB)
MP4
6  Module Review.mp4 (1.45 MB)
MP4
1  Module Introduction.mp4 (724.12 KB)
MP4
2  Understanding NULLs.mp4 (2.75 MB)
MP4
3  3VL (Ternary) Logic.mp4 (6.26 MB)
MP4
4  Logical Predicates and Operators.mp4 (7.51 MB)
MP4
5  Filtering with WHERE.mp4 (9.31 MB)
MP4
6  Module Review.mp4 (1.26 MB)
MP4
1  Module Introduction.mp4 (688.27 KB)
MP4
2  What Is Grouping Good For.mp4 (25.72 MB)
MP4
3  Grouping Rows.mp4 (10.06 MB)
MP4
4  Group Filtering with HAVING.mp4 (4.6 MB)
MP4
5  Module Review.mp4 (3.54 MB)
MP4
1  Module Introduction.mp4 (739.77 KB)
MP4
2  Evaluating SELECT Expressions.mp4 (6.94 MB)
MP4
3  Dealing with NULLs.mp4 (2.34 MB)
MP4
4  Using DISTINCT.mp4 (6.05 MB)
MP4
5  Module Review.mp4 (898.91 KB)
MP4
1  Module Introduction.mp4 (882.54 KB)
MP4
2  Law of Order.mp4 (4.63 MB)
MP4
3  ORDER BY.mp4 (2.41 MB)
MP4
4  Determinism and Tiebreakers.mp4 (2.23 MB)
MP4
5  Paging Result Sets.mp4 (3.86 MB)
MP4
6  Demo - Ordering and Paging.mp4 (14.14 MB)
MP4
7  Module Review.mp4 (3.06 MB)
MP4
1  Module Introduction.mp4 (650.42 KB)
MP4
2  Course Review.mp4 (5.09 MB)
MP4
3  Takeaway.mp4 (2.7 MB)
MP4
4  Feedback.mp4 (1.33 MB)
MP4
5  Next Steps.mp4 (1.89 MB)
MP4
6  Additional Resources and Conclusion.mp4 (2.19 MB)
MP4
1  Course Overview.mp4 (4.73 MB)
MP4
1  Version Check.mp4 (538.63 KB)
MP4
2  Querying JSON in Microsoft SQL Server.mp4 (7.04 MB)
MP4
3  What Is JSON What About JSON in SQL Server.mp4 (10.94 MB)
MP4
4  Querying JSON Documents with T-SQL.mp4 (8.64 MB)
MP4
5  Converting Data into JSON with FOR JSON PATH and AUTO.mp4 (15.3 MB)
MP4
6  Using SQL JSON Functions - JSON VALUE, JSON QUERY, JSON MODIFY, and IS JSON.mp4 (4.96 MB)
MP4
7  Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4 (11.41 MB)
MP4
8  Handling Missing Properties with LAX and STRICT Mode.mp4 (12.37 MB)
MP4
9  Takeaway.mp4 (2.15 MB)
MP4
1  Querying XML Data in Microsoft SQL Server with T-SQL.mp4 (3.29 MB)
MP4
2  What is XML How Do I Build Good XML.mp4 (11.86 MB)
MP4
3  Selecting Data from XML - OPENXML and the query and value Methods.mp4 (24.19 MB)
MP4
4  Getting to Know the XPath Syntax and XQuery Language.mp4 (14.01 MB)
MP4
5  Providing Rowset Views with OPENXML and the nodes Method.mp4 (15.14 MB)
MP4
6  Updating XML with modify and the XML Data Modification Language.mp4 (8.13 MB)
MP4
7  Filtering XML Data with Contains and Exist.mp4 (8.46 MB)
MP4
8  Takeaway.mp4 (2.03 MB)
MP4
1  Utilizing Temporal Tables.mp4 (1.65 MB)
MP4
2  Understanding Temporal or System-versioned Tables.mp4 (6.94 MB)
MP4
3  Creating Temporal and History Tables.mp4 (5.23 MB)
MP4
4  Adding and Modifying Data in Temporal Tables.mp4 (25.69 MB)
MP4
5  Selecting Data from Temporal Tables at Specific Points in Time.mp4 (9.55 MB)
MP4
6  Recovering Data in a Temporal Table.mp4 (6.6 MB)
MP4
7  Takeaway.mp4 (2.01 MB)
MP4
1  Final Takeaway.mp4 (4.07 MB)
MP4
01  Modifying Data Using T-SQL Statements.mp4 (1.54 MB)
MP4
02  Modifying Records with the UPDATE Statement.mp4 (4.38 MB)
MP4
03  Using UPDATE to Modify Data in One Row.mp4 (4.4 MB)
MP4
04  Using UPDATE to Modify Data in Multiple Rows.mp4 (5.59 MB)
MP4
05  Retrieving Number of Affected Rows with @@Rowcount.mp4 (5.62 MB)
MP4
06  Modifying Data Using UPDATE with Constraints.mp4 (7.96 MB)
MP4
07  UPDATE Using Variables.mp4 (8.76 MB)
MP4
08  FROM and JOIN within an UPDATE.mp4 (7.16 MB)
MP4
09  A Few More Details on UPDATE.mp4 (4.4 MB)
MP4
10  Takeaway.mp4 (1.77 MB)
MP4
1  Course Overview.mp4 (3.41 MB)
MP4
1  Version Check.mp4 (514.93 KB)
MP4
2  Working with the T-SQL Data Manipulation Language.mp4 (6.81 MB)
MP4
3  Understanding and Differentiating the T-SQL Sub-languages.mp4 (2.71 MB)
MP4
4  What Is the T-SQL Data Manipulation Language.mp4 (1.81 MB)
MP4
5  The Database for This Training - StackOverflow or StackExchange.mp4 (16.19 MB)
MP4
6  What You Need to Know About SELECT for DML.mp4 (18.94 MB)
MP4
7  What You Need to Know About WHERE for DML.mp4 (14.24 MB)
MP4
8  Takeaway.mp4 (966.55 KB)
MP4
1  Adding Data Using T-SQL Statements.mp4 (1.84 MB)
MP4
2  Adding New Records with the INSERT Statement.mp4 (5.46 MB)
MP4
3  An Insert Statement with Columns and Values.mp4 (8.93 MB)
MP4
4  An Insert Statement with All Values.mp4 (4 MB)
MP4
5  An Insert Statement with NULL and DEFAULT.mp4 (8.56 MB)
MP4
6  An Insert Statement with an Identity.mp4 (6.57 MB)
MP4
7  An Insert Statement with Constraints.mp4 (16.09 MB)
MP4
8  Adding Multiple Records from a Data File with BULK INSERT.mp4 (10.19 MB)
MP4
9  Takeaway.mp4 (1.4 MB)
MP4
1  Removing Data Using T-SQL Statements.mp4 (1.87 MB)
MP4
2  Removing Records with the DELETE Statement.mp4 (1.46 MB)
MP4
3  Removing a Specific Record with DELETE.mp4 (3.99 MB)
MP4
4  Removing Multiple Records with DELETE.mp4 (9.36 MB)
MP4
5  Deleting Data Using JOINs.mp4 (5.27 MB)
MP4
6  Removing Data with Constraints and Cascade Deleting of Data.mp4 (14.01 MB)
MP4
7  Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp4 (11.81 MB)
MP4
8  Takeaway.mp4 (2.04 MB)
MP4
1  Maintaining Data Integrity with Transactions.mp4 (4.09 MB)
MP4
2  Transaction Properties.mp4 (1.94 MB)
MP4
3  Understanding T-SQL Transactions.mp4 (3.82 MB)
MP4
4  Creating Transactions Using BEGIN and COMMIT.mp4 (15.66 MB)
MP4
5  Querying Data Locked in a Transaction with NOLOCK.mp4 (5.88 MB)
MP4
6  Undoing Transactions Using ROLLBACK.mp4 (5.05 MB)
MP4
7  Partially Undoing Transactions Using Savepoints.mp4 (10.65 MB)
MP4
8  Distributed Transactions at a High Level.mp4 (2.37 MB)
MP4
9  Takeaway.mp4 (1.81 MB)
MP4
1  Using Advanced T-SQL Techniques.mp4 (1.55 MB)
MP4
2  Using INSERT with Multiple Values.mp4 (4.26 MB)
MP4
3  SELECT within an INSERT Statement.mp4 (8.3 MB)
MP4
4  Using SELECT to Retrieve a Specific Field in an INSERT.mp4 (6.7 MB)
MP4
5  Retrieving Records on INSERT Using the OUTPUT Clause.mp4 (12.67 MB)
MP4
6  Utilizing MERGE to Perform Operations on a Target Table.mp4 (12.04 MB)
MP4
7  BULK INSERT Using a Format File.mp4 (12.64 MB)
MP4
8  Takeaway.mp4 (2.8 MB)
MP4
1  Final Takeaway.mp4 (6.14 MB)
MP4
1  Course Overview.mp4 (4.27 MB)
MP4
1  Calculating Values Using String Functions.mp4 (7.91 MB)
MP4
2  Formatting Strings with Stuff and Replace.mp4 (10.08 MB)
MP4
3  Cutting out the Product Attributes.mp4 (9.12 MB)
MP4
4  Pivoting the Attributes.mp4 (10.13 MB)
MP4
5  Analysing Sales Using Product Attributes.mp4 (10.59 MB)
MP4
1  Calculating Values Using Numeric Scalar Functions.mp4 (10.47 MB)
MP4
2  The Round Function.mp4 (8.44 MB)
MP4
3  Creating A B Customer Tags with Modulus.mp4 (12.06 MB)
MP4
4  Creating Alternating Customer A B Tags.mp4 (4.01 MB)
MP4
1  Creating Measures with Aggregation Functions.mp4 (7.93 MB)
MP4
2  A Tour of the Data.mp4 (6.67 MB)
MP4
3  Creating an Aggregation Query.mp4 (6.71 MB)
MP4
4  Querying Unique Lists of Values.mp4 (8.1 MB)
MP4
5  Querying Aggregations in Lists.mp4 (13.94 MB)
MP4
1  Ranking Data with Rank and Partition.mp4 (10.65 MB)
MP4
2  The Rank Function.mp4 (8.28 MB)
MP4
3  The Dense Rank Function.mp4 (13.99 MB)
MP4
4  The NTILE Function.mp4 (6.5 MB)
MP4
1  Aggregating and Summarizing Data with Functions.mp4 (8.06 MB)
MP4
2  The Percent Rank Function.mp4 (12.97 MB)
MP4
3  First and Last Value.mp4 (11.79 MB)
MP4
1  Substituting a Table Reference with a ROWSET Function.mp4 (13.02 MB)
MP4
2  OPENROWSET Queries.mp4 (9.5 MB)
MP4
1  Query Data with Inline Queries and Scalar Functions.mp4 (5.48 MB)
MP4
2  Searching for Strings with the LIKE Function.mp4 (3.98 MB)
MP4
3  LIKE Function Demo.mp4 (10.66 MB)
MP4
4  Creating Statements with Simple Scalar Functions.mp4 (9.68 MB)
MP4
5  Formatting Functions.mp4 (6.85 MB)
MP4
6  Inline View Queries and Subqueries.mp4 (15.87 MB)
MP4
7  The Subquery.mp4 (6.45 MB)
MP4
1  Query Data with Static Value Functions.mp4 (10.02 MB)
MP4
2  Monthly Rolling Sales with GETDATE.mp4 (9.04 MB)
MP4
1  Implementing IF Then Logic.mp4 (3.52 MB)
MP4
2  Product Groups.mp4 (15.17 MB)
MP4
3  Product Gender.mp4 (14.7 MB)
MP4
4  Intelligent Measures.mp4 (7.4 MB)
MP4
1  Combining Queries with COALESCE.mp4 (13.28 MB)
MP4
2  Adding the COALESCE Function to a Query.mp4 (10.81 MB)
MP4
3  Joining Multiple Queries with COALESCE.mp4 (5.45 MB)
MP4

 https://rapidgator.net/file/f7243389a975548b539792291622a339/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z01
https://rapidgator.net/file/4b7ba0041a5cc660deddf6cb3d69273d/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z02
https://rapidgator.net/file/ace91063299d98d4f92417aec9eeff86/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.zip

 https://ddownload.com/4onqnqzl47gz/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z01
https://ddownload.com/eno9bbzaxyha/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z02
https://ddownload.com/z4u5oa1zz0as/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.zip

 https://nitroflare.com/view/E7DCC0C80084D0F/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z01
https://nitroflare.com/view/E95DC508CC65C60/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.z02
https://nitroflare.com/view/64BD3F258A9A1E7/Pluralsight_-_Querying_Data_with_T-SQL_from_SQL_Server.zip