Torrent Downloads » Other » [ DevCourseWeb com ] PluralSight - Learning Path - Querying Data with T-SQL from SQL Server
Other
[ DevCourseWeb com ] PluralSight - Learning Path - Querying Data with T-SQL from SQL Server
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 4.40 GB) (Files: 872)
Get Bonus Downloads Here.url
~Get Your Files Here !
Bonus Resources.txt
Capturing Logic with Stored Procedures in T-SQL By Jared Westover
02. Exploring the Benefits of Stored Procedures
01. Version Check.mp4
01. Version Check.vtt
02. Introduction.mp4
02. Introduction.vtt
03. What Is a Stored Procedure.mp4
03. What Is a Stored Procedure.vtt
04. Comparing Data Fetching Options.mp4
04. Comparing Data Fetching Options.vtt
05. Primary Stored Procedure Benefits.mp4
05. Primary Stored Procedure Benefits.vtt
06. Demo - Creating Test Environment.mp4
06. Demo - Creating Test Environment.vtt
07. Demo - Minimizing Modifications.mp4
07. Demo - Minimizing Modifications.vtt
08. Exploring Security Benefits.mp4
08. Exploring Security Benefits.vtt
09. Demo - Limiting User Access.mp4
09. Demo - Limiting User Access.vtt
10. Exploring Performance Gains.mp4
10. Exploring Performance Gains.vtt
11. Demo - Execution Plan Reuse.mp4
11. Demo - Execution Plan Reuse.vtt
12. Disadvantages of Stored Procedures.mp4
12. Disadvantages of Stored Procedures.vtt
13. Summary.mp4
13. Summary.vtt
03. Creating Our First Stored Procedure
01. Introduction.mp4
01. Introduction.vtt
02. Creating Our Stored Procedure.mp4
02. Creating Our Stored Procedure.vtt
03. Exploring New Syntax and Executing.mp4
03. Exploring New Syntax and Executing.vtt
04. Naming Stored Procedures.mp4
04. Naming Stored Procedures.vtt
05. Demo - Creating and Executing.mp4
05. Demo - Creating and Executing.vtt
06. Demo - Scripting Stored Procedures.mp4
06. Demo - Scripting Stored Procedures.vtt
07. Exploring Parameters.mp4
07. Exploring Parameters.vtt
08. Demo - Adding Parameters.mp4
08. Demo - Adding Parameters.vtt
09. Exploring Debugger.mp4
09. Exploring Debugger.vtt
10. Demo - Debugging Code.mp4
10. Demo - Debugging Code.vtt
11. Reviewing Best Practices.mp4
11. Reviewing Best Practices.vtt
12. Summary.mp4
12. Summary.vtt
04. Setting up Queries in Stored Procedures
01. Introduction.mp4
01. Introduction.vtt
02. Building Queries in Stored Procedures.mp4
02. Building Queries in Stored Procedures.vtt
03. Reviewing Temporary Objects.mp4
03. Reviewing Temporary Objects.vtt
04. Creating Temporary Objects.mp4
04. Creating Temporary Objects.vtt
05. Demo - Adding Queries to Stored Procedures.mp4
05. Demo - Adding Queries to Stored Procedures.vtt
06. Demo - Using Temporary Objects.mp4
06. Demo - Using Temporary Objects.vtt
07. Exploring Table Valued Parameters.mp4
07. Exploring Table Valued Parameters.vtt
08. Demo - Table Valued Parameters.mp4
08. Demo - Table Valued Parameters.vtt
09. Examining Sp_executesql.mp4
09. Examining Sp_executesql.vtt
10. Demo - Using Sp_executesql.mp4
10. Demo - Using Sp_executesql.vtt
11. Implementing a Debug Flag.mp4
11. Implementing a Debug Flag.vtt
12. Demo - Adding a Debug Flag.mp4
12. Demo - Adding a Debug Flag.vtt
13. Summary.mp4
13. Summary.vtt
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
5. Optimizing Stored Procedure Performance
1. Introduction.mp4
1. Introduction.vtt
2. Creating a Baseline.mp4
2. Creating a Baseline.vtt
3. Demo - Gathering Baseline Stats.mp4
3. Demo - Gathering Baseline Stats.vtt
4. Busting Performance Myths.mp4
4. Busting Performance Myths.vtt
5. Demo - Temp Table Myth.mp4
5. Demo - Temp Table Myth.vtt
6. Demo - Select 1 Versus Select.mp4
6. Demo - Select 1 Versus Select.vtt
7. Exploring Parameter Sniffing.mp4
7. Exploring Parameter Sniffing.vtt
8. Demo - Parameter Sniffing.mp4
8. Demo - Parameter Sniffing.vtt
9. Summary.mp4
9. Summary.vtt
6. Building Stored Procedures in the Real World
1. Introduction.mp4
1. Introduction.vtt
2. Defining Stored Procedure Templates.mp4
2. Defining Stored Procedure Templates.vtt
3. Demo - Creating Templates.mp4
3. Demo - Creating Templates.vtt
4. Exploring Key Takeaways.mp4
4. Exploring Key Takeaways.vtt
5. Continuing the Journey.mp4
5. Continuing the Journey.vtt
playlist.m3u
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
10. Summary
1. Summary.mp4
1. Summary.vtt
2. Setting up the SQL Server Environment
1. Version Check.mp4
1. Version Check.vtt
2. Introduction.mp4
2. Introduction.vtt
3. Setting up the SQL Server Environment.mp4
3. Setting up the SQL Server Environment.vtt
4. Creating SQL Server Databases.mp4
4. Creating SQL Server Databases.vtt
5. Using SQL Server Management Studio.mp4
5. Using SQL Server Management Studio.vtt
6. Summary and Resources.mp4
6. Summary and Resources.vtt
3. Shaping Data in a Query
1. Introduction.mp4
1. Introduction.vtt
2. The SELECT Query Syntax.mp4
2. The SELECT Query Syntax.vtt
3. Concatenating Values in T-SQL.mp4
3. Concatenating Values in T-SQL.vtt
4. Casting and Converting Data Types.mp4
4. Casting and Converting Data Types.vtt
5. Formatting Strings.mp4
5. Formatting Strings.vtt
6. Working with Characters.mp4
6. Working with Characters.vtt
7. Formatting Dates and Numbers.mp4
7. Formatting Dates and Numbers.vtt
8. Review and Resources.mp4
8. Review and Resources.vtt
4. Querying Data from Multiple Tables Using JOINS
1. Introduction.mp4
1. Introduction.vtt
2. Understanding Primary and Foreign Keys.mp4
2. Understanding Primary and Foreign Keys.vtt
3. Using the Inner Join.mp4
3. Using the Inner Join.vtt
4. Left and Right Joins.mp4
4. Left and Right Joins.vtt
5. Full OUTER Joins.mp4
5. Full OUTER Joins.vtt
6. Self Join.mp4
6. Self Join.vtt
7. Review and Resources.mp4
7. Review and Resources.vtt
5. Filtering and Controlling Flow
1. Introduction.mp4
1. Introduction.vtt
2. Expressions and Comparison Operators.mp4
2. Expressions and Comparison Operators.vtt
3. Applying T-SQL Logical Operators.mp4
3. Applying T-SQL Logical Operators.vtt
4. Controlling Flow with T-SQL Logic.mp4
4. Controlling Flow with T-SQL Logic.vtt
5. Review and Resources.mp4
5. Review and Resources.vtt
6. Limiting the Results with T-SQL Functions
1. Introduction.mp4
1. Introduction.vtt
2. Offset and Fetch.mp4
2. Offset and Fetch.vtt
3. TOP Functions.mp4
3. TOP Functions.vtt
4. Using Variables to Limit Results.mp4
4. Using Variables to Limit Results.vtt
5. Review and Resources.mp4
5. Review and Resources.vtt
7. Aggregating Data in a Query
1. Introduction.mp4
1. Introduction.vtt
2. Using COUNT in T-SQL.mp4
2. Using COUNT in T-SQL.vtt
3. Using SUM in T-SQL.mp4
3. Using SUM in T-SQL.vtt
4. Using AVG in T-SQL.mp4
4. Using AVG in T-SQL.vtt
5. Using MIN and MAX in T-SQL.mp4
5. Using MIN and MAX in T-SQL.vtt
6. Review and Resources.mp4
6. Review and Resources.vtt
8. Using T-SQL Set Operators
1. Introduction.mp4
1. Introduction.vtt
2. Difference between Joins and Set Operators.mp4
2. Difference between Joins and Set Operators.vtt
3. Union All.mp4
3. Union All.vtt
4. Union.mp4
4. Union.vtt
5. Intersect.mp4
5. Intersect.vtt
6. Except.mp4
6. Except.vtt
7. Review and Resources.mp4
7. Review and Resources.vtt
9. Simplifying with Intermediate Tables and Common Table Expressions
1. Introduction.mp4
1. Introduction.vtt
2. Using Common Table Expressions in T-SQL.mp4
2. Using Common Table Expressions in T-SQL.vtt
3. Using Temporary Tables in T-SQL.mp4
3. Using Temporary Tables in T-SQL.vtt
4. Using Cursors in T-SQL.mp4
4. Using Cursors in T-SQL.vtt
5. Review and Resources.mp4
5. Review and Resources.vtt
playlist.m3u
Handling Errors in T-SQL By Jared Westover
02. Getting Started with Error Handling in T-SQL
01. Version Check.mp4
01. Version Check.vtt
02. Introduction.mp4
02. Introduction.vtt
03. Why Care About Error Handling.mp4
03. Why Care About Error Handling.vtt
04. Planning For Failure.mp4
04. Planning For Failure.vtt
05. What Do We Mean By Atomic.mp4
05. What Do We Mean By Atomic.vtt
06. Demo - Creating a Test Environment.mp4
06. Demo - Creating a Test Environment.vtt
07. Demo - Transferring Funds.mp4
07. Demo - Transferring Funds.vtt
08. Handling Conversion Errors.mp4
08. Handling Conversion Errors.vtt
09. Demo - Handling Conversion Errors.mp4
09. Demo - Handling Conversion Errors.vtt
10. Summary.mp4
10. Summary.vtt
03. Exploring Transactions in SQL Server
01. Introduction.mp4
01. Introduction.vtt
02. What Is the ACID Principle.mp4
02. What Is the ACID Principle.vtt
03. Transaction Modes in SQL Server.mp4
03. Transaction Modes in SQL Server.vtt
04. Demo - Transaction Modes.mp4
04. Demo - Transaction Modes.vtt
05. Isolation Levels.mp4
05. Isolation Levels.vtt
06. Demo - Isolation Levels.mp4
06. Demo - Isolation Levels.vtt
07. Nested Transactions.mp4
07. Nested Transactions.vtt
08. Demo - Nested Transactions.mp4
08. Demo - Nested Transactions.vtt
09. Demo - Save Points.mp4
09. Demo - Save Points.vtt
10. Summary.mp4
10. Summary.vtt
04. Examining Error Handling Methods
01. Introduction.mp4
01. Introduction.vtt
02. Examining an Error Message.mp4
02. Examining an Error Message.vtt
03. Errors Requiring Attention.mp4
03. Errors Requiring Attention.vtt
04. Exploring RAISERROR.mp4
04. Exploring RAISERROR.vtt
05. Demo - Error Message Details.mp4
05. Demo - Error Message Details.vtt
06. Demo - Using RAISERROR.mp4
06. Demo - Using RAISERROR.vtt
07. Exploring TRY..CATCH.mp4
07. Exploring TRY..CATCH.vtt
08. Error Handling Methods.mp4
08. Error Handling Methods.vtt
09. Demo - TRY..CATCH.mp4
09. Demo - TRY..CATCH.vtt
10. Demo - XACT_ABORT and XACT_STATE.mp4
10. Demo - XACT_ABORT and XACT_STATE.vtt
11. Exploring THROW.mp4
11. Exploring THROW.vtt
12. Demo - THROW.mp4
12. Demo - THROW.vtt
13. Summary.mp4
13. Summary.vtt
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
5. Handling Errors in the Real World
1. Introduction.mp4
1. Introduction.vtt
2. Comparing RAISERROR and THROW.mp4
2. Comparing RAISERROR and THROW.vtt
3. Demo - Error Handling Template.mp4
3. Demo - Error Handling Template.vtt
4. Demo - Actionable Message.mp4
4. Demo - Actionable Message.vtt
5. Demo - Enforcing Business Logic.mp4
5. Demo - Enforcing Business Logic.vtt
6. Demo - Row Count Mismatch.mp4
6. Demo - Row Count Mismatch.vtt
7. Demo - Error Table and Stored Procedure.mp4
7. Demo - Error Table and Stored Procedure.vtt
8. Course Summary.mp4
8. Course Summary.vtt
playlist.m3u
Querying Data Using T-SQL By Ami Levin
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
2. What Is T-SQL
1. Version Check.mp4
1. Version Check.vtt
2. Module Introduction.mp4
2. Module Introduction.vtt
3. What Is T-SQL.mp4
3. What Is T-SQL.vtt
4. A Little SQL Server Architecture.mp4
4. A Little SQL Server Architecture.vtt
5. Tools.mp4
5. Tools.vtt
6. Demo - Tools.mp4
6. Demo - Tools.vtt
7. Module Review.mp4
7. Module Review.vtt
3. Our First SELECT
1. Module Introduction.mp4
1. Module Introduction.vtt
2. What Is a SQL Query.mp4
2. What Is a SQL Query.vtt
3. More Terminology.mp4
3. More Terminology.vtt
4. Demo - First SELECT.mp4
4. Demo - First SELECT.vtt
5. Module Review.mp4
5. Module Review.vtt
4. The FROM Clause
1. Module Introduction.mp4
1. Module Introduction.vtt
2. TSQL Demo Database.mp4
2. TSQL Demo Database.vtt
3. Demo - FROM Single Table.mp4
3. Demo - FROM Single Table.vtt
4. Introduction to Multiple Tables in FROM.mp4
4. Introduction to Multiple Tables in FROM.vtt
5. Demo - Multiple Tables.mp4
5. Demo - Multiple Tables.vtt
6. Module Review.mp4
6. Module Review.vtt
5. Filtering with WHERE
1. Module Introduction.mp4
1. Module Introduction.vtt
2. Understanding NULLs.mp4
2. Understanding NULLs.vtt
3. 3VL (Ternary) Logic.mp4
3. 3VL (Ternary) Logic.vtt
4. Logical Predicates and Operators.mp4
4. Logical Predicates and Operators.vtt
5. Filtering with WHERE.mp4
5. Filtering with WHERE.vtt
6. Module Review.mp4
6. Module Review.vtt
6. Grouping Rows
1. Module Introduction.mp4
1. Module Introduction.vtt
2. What Is Grouping Good For.mp4
2. What Is Grouping Good For.vtt
3. Grouping Rows.mp4
3. Grouping Rows.vtt
4. Group Filtering with HAVING.mp4
4. Group Filtering with HAVING.vtt
5. Module Review.mp4
5. Module Review.vtt
7. Evaluating SELECT Expressions
1. Module Introduction.mp4
1. Module Introduction.vtt
2. Evaluating SELECT Expressions.mp4
2. Evaluating SELECT Expressions.vtt
3. Dealing with NULLs.mp4
3. Dealing with NULLs.vtt
4. Using DISTINCT.mp4
4. Using DISTINCT.vtt
5. Module Review.mp4
5. Module Review.vtt
8. Ordering and Paging
1. Module Introduction.mp4
1. Module Introduction.vtt
2. Law of Order.mp4
2. Law of Order.vtt
3. ORDER BY.mp4
3. ORDER BY.vtt
4. Determinism and Tiebreakers.mp4
4. Determinism and Tiebreakers.vtt
5. Paging Result Sets.mp4
5. Paging Result Sets.vtt
6. Demo - Ordering and Paging.mp4
6. Demo - Ordering and Paging.vtt
7. Module Review.mp4
7. Module Review.vtt
9. Wrapping Up
1. Module Introduction.mp4
1. Module Introduction.vtt
2. Course Review.mp4
2. Course Review.vtt
3. Takeaway.mp4
3. Takeaway.vtt
4. Feedback.mp4
4. Feedback.vtt
5. Next Steps.mp4
5. Next Steps.vtt
6. Additional Resources and Conclusion.mp4
6. Additional Resources and Conclusion.vtt
playlist.m3u
Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
2. Querying JSON with T-SQL
1. Version Check.mp4
1. Version Check.vtt
2. Querying JSON in Microsoft SQL Server.mp4
2. Querying JSON in Microsoft SQL Server.vtt
3. What Is JSON What About JSON in SQL Server.mp4
3. What Is JSON What About JSON in SQL Server.vtt
4. Querying JSON Documents with T-SQL.mp4
4. Querying JSON Documents with T-SQL.vtt
5. Converting Data into JSON with FOR JSON PATH and AUTO.mp4
5. Converting Data into JSON with FOR JSON PATH and AUTO.vtt
6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.mp4
6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.vtt
7. Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4
7. Parsing and Importing JSON with OPENROWSET and OPENJSON.vtt
8. Handling Missing Properties with LAX and STRICT Mode.mp4
8. Handling Missing Properties with LAX and STRICT Mode.vtt
9. Takeaway.mp4
9. Takeaway.vtt
3. Querying XML Data with T-SQL
1. Querying XML Data in Microsoft SQL Server with T-SQL.mp4
1. Querying XML Data in Microsoft SQL Server with T-SQL.vtt
2. What is XML How Do I Build Good XML.mp4
2. What is XML How Do I Build Good XML.vtt
3. Selecting Data from XML - OPENXML and the query and value Methods.mp4
3. Selecting Data from XML - OPENXML and the query and value Methods.vtt
4. Getting to Know the XPath Syntax and XQuery Language.mp4
4. Getting to Know the XPath Syntax and XQuery Language.vtt
5. Providing Rowset Views with OPENXML and the nodes Method.mp4
5. Providing Rowset Views with OPENXML and the nodes Method.vtt
6. Updating XML with modify and the XML Data Modification Language.mp4
6. Updating XML with modify and the XML Data Modification Language.vtt
7. Filtering XML Data with Contains and Exist.mp4
7. Filtering XML Data with Contains and Exist.vtt
8. Takeaway.mp4
8. Takeaway.vtt
4. Utilizing Temporal Tables
1. Utilizing Temporal Tables.mp4
1. Utilizing Temporal Tables.vtt
2. Understanding Temporal or System-versioned Tables.mp4
2. Understanding Temporal or System-versioned Tables.vtt
3. Creating Temporal and History Tables.mp4
3. Creating Temporal and History Tables.vtt
4. Adding and Modifying Data in Temporal Tables.mp4
4. Adding and Modifying Data in Temporal Tables.vtt
5. Selecting Data from Temporal Tables at Specific Points in Time.mp4
5. Selecting Data from Temporal Tables at Specific Points in Time.vtt
6. Recovering Data in a Temporal Table.mp4
6. Recovering Data in a Temporal Table.vtt
7. Takeaway.mp4
7. Takeaway.vtt
5. Final Takeaway
1. Final Takeaway.mp4
1. Final Takeaway.vtt
playlist.m3u
T-SQL Data Manipulation Playbook By Xavier Morera
04. Modifying Data Using T-SQL Statements
01. Modifying Data Using T-SQL Statements.mp4
01. Modifying Data Using T-SQL Statements.vtt
02. Modifying Records with the UPDATE Statement.mp4
02. Modifying Records with the UPDATE Statement.vtt
03. Using UPDATE to Modify Data in One Row.mp4
03. Using UPDATE to Modify Data in One Row.vtt
04. Using UPDATE to Modify Data in Multiple Rows.mp4
04. Using UPDATE to Modify Data in Multiple Rows.vtt
05. Retrieving Number of Affected Rows with @@Rowcount.mp4
05. Retrieving Number of Affected Rows with @@Rowcount.vtt
06. Modifying Data Using UPDATE with Constraints.mp4
06. Modifying Data Using UPDATE with Constraints.vtt
07. UPDATE Using Variables.mp4
07. UPDATE Using Variables.vtt
08. FROM and JOIN within an UPDATE.mp4
08. FROM and JOIN within an UPDATE.vtt
09. A Few More Details on UPDATE.mp4
09. A Few More Details on UPDATE.vtt
10. Takeaway.mp4
10. Takeaway.vtt
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
2. Working with the T-SQL Data Manipulation Language
1. Version Check.mp4
1. Version Check.vtt
2. Working with the T-SQL Data Manipulation Language.mp4
2. Working with the T-SQL Data Manipulation Language.vtt
3. Understanding and Differentiating the T-SQL Sub-languages.mp4
3. Understanding and Differentiating the T-SQL Sub-languages.vtt
4. What Is the T-SQL Data Manipulation Language.mp4
4. What Is the T-SQL Data Manipulation Language.vtt
5. The Database for This Training - StackOverflow or StackExchange.mp4
5. The Database for This Training - StackOverflow or StackExchange.vtt
6. What You Need to Know About SELECT for DML.mp4
6. What You Need to Know About SELECT for DML.vtt
7. What You Need to Know About WHERE for DML.mp4
7. What You Need to Know About WHERE for DML.vtt
8. Takeaway.mp4
8. Takeaway.vtt
3. Adding Data Using T-SQL Statements
1. Adding Data Using T-SQL Statements.mp4
1. Adding Data Using T-SQL Statements.vtt
2. Adding New Records with the INSERT Statement.mp4
2. Adding New Records with the INSERT Statement.vtt
3. An Insert Statement with Columns and Values.mp4
3. An Insert Statement with Columns and Values.vtt
4. An Insert Statement with All Values.mp4
4. An Insert Statement with All Values.vtt
5. An Insert Statement with NULL and DEFAULT.mp4
5. An Insert Statement with NULL and DEFAULT.vtt
6. An Insert Statement with an Identity.mp4
6. An Insert Statement with an Identity.vtt
7. An Insert Statement with Constraints.mp4
7. An Insert Statement with Constraints.vtt
8. Adding Multiple Records from a Data File with BULK INSERT.mp4
8. Adding Multiple Records from a Data File with BULK INSERT.vtt
9. Takeaway.mp4
9. Takeaway.vtt
5. Removing Data Using T-SQL Statements
1. Removing Data Using T-SQL Statements.mp4
1. Removing Data Using T-SQL Statements.vtt
2. Removing Records with the DELETE Statement.mp4
2. Removing Records with the DELETE Statement.vtt
3. Removing a Specific Record with DELETE.mp4
3. Removing a Specific Record with DELETE.vtt
4. Removing Multiple Records with DELETE.mp4
4. Removing Multiple Records with DELETE.vtt
5. Deleting Data Using JOINs.mp4
5. Deleting Data Using JOINs.vtt
6. Removing Data with Constraints and Cascade Deleting of Data.mp4
6. Removing Data with Constraints and Cascade Deleting of Data.vtt
7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp4
7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.vtt
8. Takeaway.mp4
8. Takeaway.vtt
6. Maintaining Data Integrity with Transactions
1. Maintaining Data Integrity with Transactions.mp4
1. Maintaining Data Integrity with Transactions.vtt
2. Transaction Properties.mp4
2. Transaction Properties.vtt
3. Understanding T-SQL Transactions.mp4
3. Understanding T-SQL Transactions.vtt
4. Creating Transactions Using BEGIN and COMMIT.mp4
4. Creating Transactions Using BEGIN and COMMIT.vtt
5. Querying Data Locked in a Transaction with NOLOCK.mp4
5. Querying Data Locked in a Transaction with NOLOCK.vtt
6. Undoing Transactions Using ROLLBACK.mp4
6. Undoing Transactions Using ROLLBACK.vtt
7. Partially Undoing Transactions Using Savepoints.mp4
7. Partially Undoing Transactions Using Savepoints.vtt
8. Distributed Transactions at a High Level.mp4
8. Distributed Transactions at a High Level.vtt
9. Takeaway.mp4
9. Takeaway.vtt
7. Using Advanced T-SQL Techniques
1. Using Advanced T-SQL Techniques.mp4
1. Using Advanced T-SQL Techniques.vtt
2. Using INSERT with Multiple Values.mp4
2. Using INSERT with Multiple Values.vtt
3. SELECT within an INSERT Statement.mp4
3. SELECT within an INSERT Statement.vtt
4. Using SELECT to Retrieve a Specific Field in an INSERT.mp4
4. Using SELECT to Retrieve a Specific Field in an INSERT.vtt
5. Retrieving Records on INSERT Using the OUTPUT Clause.mp4
5. Retrieving Records on INSERT Using the OUTPUT Clause.vtt
6. Utilizing MERGE to Perform Operations on a Target Table.mp4
6. Utilizing MERGE to Perform Operations on a Target Table.vtt
7. BULK INSERT Using a Format File.mp4
7. BULK INSERT Using a Format File.vtt
8. Takeaway.mp4
8. Takeaway.vtt
8. Final Takeaway
1. Final Takeaway.mp4
1. Final Takeaway.vtt
playlist.m3u
T-SQL Functions Playbook By Andrew McSwiggan
01
demos
demos
m02
demo-01-querying-json-documents.sql
demo-02-convert-data-into-json.sql
demo-03-convert-data-into-json.sql
demo-04-parsing-and-importing-json.sql
demo-05-parsing-and-importing-json.sql
demo-06-lax-and-strict-mode.sql
top-posts.json
m03
demo-01-selecting-data-from-mxl.sql
demo-02-selecting-data-from-xml.sql
demo-03-providing-rowset-view-with-openmxl.sql
demo-04-providing-rowset-view-with-nodes.sql
demo-05-modifying-xml-data.sql
demo-06-working-with-xpath-query-syntax.sql
demo-07-filtering-data-using-contains-and-exist.sql
posts.xml
m04
demo-01-creating-temporal-tables.sql
demo-02-modifying-data-in-temporal-tables.sql
demo-03-selecting-data-from-temporal-tables.sql
demo-04-recovering-a-temporal-table.sql
02
creating-measures-with-aggregation-functions-slides.pdf
demos
Module 2 - What is TSQL - Code and Links.sql
SELECT.txt
WHERE.txt
m2-demos
01_Creating_Demo_Environment.sql
02_Modify_Sales_Report.sql
02_Transferring_Funds.sql
03_Handling_Conversion_Errors.sql
03_Limiting_User_Access.sql
04_Execution_Plan_Reuse.sql
exploring-the-benefits-of-stored-procedures-slides.pdf
getting-started-with-error-handling-in-t-sql-slides.pdf
querying-json-with-t-sql-slides.pdf
setting-up-the-sql-server-environment-slides.pdf
what-is-t-sql-slides.pdf
working-with-the-t-sql-data-manipulation-language-slides.pdf
03
adding-data-using-t-sql-statements-slides.pdf
creating-our-first-stored-procedure-slides.pdf
demos
INSERT.txt
Module 3 -Our First SELECT - Code and Links.sql
m3-demos
01_Creating_and_Executing_Stored_Procedures.sql
01_Transaction_Modes.sql
02_Isolation_Levels_Read.sql
02_Isolation_Levels_Update.sql
02_Using_Parameters.sql
03_Nested_Transactions.sql
03_Using_Debugger_Part1.sql
03_Using_Debugger_Part2.sql
04_Save_Points.sql
exploring-transactions-in-sql-server-slides.pdf
our-first-select-slides.pdf
querying-xml-data-with-t-sql-slides.pdf
ranking-data-with-rank-and-partition-slides.pdf
shaping-data-in-a-query-slides.pdf
04
aggregating-and-summarizing-data-with-functions-slides.pdf
demos
Module 4 - FROM Multi Sources - Code and Links.sql
Module 4 - FROM Single Source - Code and Links.sql
Module 4 - TSQL Demo DB.sql
UPDATE.txt
m4-demos
01_Adding_Sales_People.sql
01_Expand_ABCCompany_Database.sql
01_SQL_Errors.sql
02_Temporary_Objects.sql
02_Using_RAISERROR.sql
03_TRY_CATCH.sql
03_Table_Valued_Parameters.sql
04_Sp_executesql.sql
04_XACT_ABORT_XACT_STATE.sql
05_Debug_Flag.sql
05_Using_THROW.sql
examining-error-handling-methods-slides.pdf
modifying-data-using-t-sql-statements-slides.pdf
querying-data-from-multiple-tables-using-joins-slides.pdf
setting-up-queries-in-stored-procedures-slides.pdf
the-from-clause-slides.pdf
utilizing-temporal-tables-slides.pdf
05
demos
DELETE.txt
Module 5 - Filtering with WHERE - Code and Links.sql
m5-demos
01_Baseline_Statistics.sql
01_Basic_Template.sql
02_Actionable_Message.sql
02_Temp_Table_Plan_Reuse.sql
03_Enforce_Business_Logic.sql
03_Select_1_Versus_Select_Star.sql
04_Parameter_Sniffing.sql
04_Row_Count_Mismatch.sql
05_Error_Table.sql
filtering-and-controlling-flow-slides.pdf
filtering-with-where-slides.pdf
final-takeaway-slides.pdf
handling-errors-in-the-real-world-slides.pdf
optimizing-stored-procedure-performance-slides.pdf
removing-data-using-t-sql-statements-slides.pdf
substituting-a-table-reference-with-a-rowset-function-slides.pptx
06
building-stored-procedures-in-the-real-world-slides.pdf
demos
Module 6 - GROUP BY - Code and Links.sql
Module 6 - HAVING - Code and Links.sql
TRANSACTION.txt
m6-demos
01_UpdateInsertProcedure_Template.sql
grouping-rows-slides.pdf
limiting-the-results-with-t-sql-functions-slides.pdf
maintaining-data-integrity-with-transactions-slides.pdf
query-data-with-inline-queries-and-scalar-functions-slides.pdf
07
aggregating-data-in-a-query-slides.pdf
demos
Advanced.txt
Module 7 - All-at-once - Code and Links.sql
Module 7 - DISTINCT - Code and Links.sql
evaluating-select-expressions-slides.pdf
query-data-with-static-value-functions-slides.pdf
using-advanced-t-sql-techniques-slides.pdf
08
demos
Module 8 - ORDER BY and Paging - Code and Links.sql
final-takeaway-slides.pdf
implementing-if-then-logic-slides.pdf
ordering-and-paging-slides.pdf
using-t-sql-set-operators-slides.pdf
09
combining-queries-with-coalesce-slides.pdf
demos
Module 9 - Wrapping Up - Links.sql
simplifying-with-intermediate-tables-and-common-table-expressions-slides.pdf
wrapping-up-slides.pdf
1. Course Overview
1. Course Overview.mp4
1. Course Overview.vtt
10. Calculating Values Using String Functions
1. Calculating Values Using String Functions.mp4
1. Calculating Values Using String Functions.vtt
2. Formatting Strings with Stuff and Replace.mp4
2. Formatting Strings with Stuff and Replace.vtt
3. Cutting out the Product Attributes.mp4
3. Cutting out the Product Attributes.vtt
4. Pivoting the Attributes.mp4
4. Pivoting the Attributes.vtt
5. Analysing Sales Using Product Attributes.mp4
5. Analysing Sales Using Product Attributes.vtt
10
calculating-values-using-string-functions-slides.pdf
summary-slides.pdf
11. Calculating Values Using Numeric Scalar Functions
1. Calculating Values Using Numeric Scalar Functions.mp4
1. Calculating Values Using Numeric Scalar Functions.vtt
2. The Round Function.mp4
2. The Round Function.vtt
3. Creating A B Customer Tags with Modulus.mp4
3. Creating A B Customer Tags with Modulus.vtt
4. Creating Alternating Customer A B Tags.mp4
4. Creating Alternating Customer A B Tags.vtt
11
calculating-values-using-numeric-scalar-functions-slides.pdf
2. Creating Measures with Aggregation Functions
1. Creating Measures with Aggregation Functions.mp4
1. Creating Measures with Aggregation Functions.vtt
2. A Tour of the Data.mp4
2. A Tour of the Data.vtt
3. Creating an Aggregation Query.mp4
3. Creating an Aggregation Query.vtt
4. Querying Unique Lists of Values.mp4
4. Querying Unique Lists of Values.vtt
5. Querying Aggregations in Lists.mp4
5. Querying Aggregations in Lists.vtt
3. Ranking Data with RANK and PARTITION
1. Ranking Data with Rank and Partition.mp4
1. Ranking Data with Rank and Partition.vtt
2. The Rank Function.mp4
2. The Rank Function.vtt
3. The Dense Rank Function.mp4
3. The Dense Rank Function.vtt
4. The NTILE Function.mp4
4. The NTILE Function.vtt
4. Aggregating and Summarizing Data with Functions
1. Aggregating and Summarizing Data with Functions.mp4
1. Aggregating and Summarizing Data with Functions.vtt
2. The Percent Rank Function.mp4
2. The Percent Rank Function.vtt
3. First and Last Value.mp4
3. First and Last Value.vtt
5. Substituting a Table Reference with a ROWSET Function
1. Substituting a Table Reference with a ROWSET Function.mp4
1. Substituting a Table Reference with a ROWSET Function.vtt
2. OPENROWSET Queries.mp4
2. OPENROWSET Queries.vtt
6. Query Data with Inline Queries and Scalar Functions
1. Query Data with Inline Queries and Scalar Functions.mp4
1. Query Data with Inline Queries and Scalar Functions.vtt
2. Searching for Strings with the LIKE Function.mp4
2. Searching for Strings with the LIKE Function.vtt
3. LIKE Function Demo.mp4
3. LIKE Function Demo.vtt
4. Creating Statements with Simple Scalar Functions.mp4
4. Creating Statements with Simple Scalar Functions.vtt
5. Formatting Functions.mp4
5. Formatting Functions.vtt
6. Inline View Queries and Subqueries.mp4
6. Inline View Queries and Subqueries.vtt
7. The Subquery.mp4
7. The Subquery.vtt
7. Query Data with Static Value Functions
1. Query Data with Static Value Functions.mp4
1. Query Data with Static Value Functions.vtt
2. Monthly Rolling Sales with GETDATE.mp4
2. Monthly Rolling Sales with GETDATE.vtt
8. Implementing IF Then Logic
1. Implementing IF Then Logic.mp4
1. Implementing IF Then Logic.vtt
2. Product Groups.mp4
2. Product Groups.vtt
3. Product Gender.mp4
3. Product Gender.vtt
4. Intelligent Measures.mp4
4. Intelligent Measures.vtt
9. Combining Queries with COALESCE
1. Combining Queries with COALESCE.mp4
1. Combining Queries with COALESCE.vtt
2. Adding the COALESCE Function to a Query.mp4
2. Adding the COALESCE Function to a Query.vtt
3. Joining Multiple Queries with COALESCE.mp4
3. Joining Multiple Queries with COALESCE.vtt
Queries Reports Charts Data Files
Combining and Filtering Data with T-SQL Final Report.sql
Data Files
NorthwindObjectsAndData.sql
WideWorldImporters-Standard.bak
DataTableExample.html
M3 - Calling a User Defined Function.sql
M3 - Casting and Converting Data Types 2.sql
M3 - Casting and Converting Data Types.sql
M3 - Casting and Converting in T-SQL.sql
M3 - Character Functions.sql
M3 - Concatenation sample.sql
M3 - Datepart.sql
M3 - Employee tenure with DATE - CASE.sql
M3 - Formatting Character Functions.sql
M3 - Formatting Dates and Numerical Values.sql
M3 - Formatting String - PatIndex.sql
M3 - Formatting Strings - Adding Concatenation.sql
M3 - Formatting Strings - Characters 2.sql
M3 - Formatting Strings - Characters.sql
M3 - Formatting Strings - REPLACE.sql
M3 - Formatting Strings - SUBSTRINGS.sql
M3 - Formatting Strings - Simplifying with temps and UDFs.sql
M3 - Formatting Strings - TRIM.sql
M3 - Formatting Strings - UPPER and LOWER.sql
M3 - Formatting Strings 2.sql
M3 - Formatting Strings.sql
M3 - Formatting numeric values and ordering.sql
M3 - Numeric Order of Operations.sql
M3 - Order Details Case When Example for due date.sql
M3 - REGEX.sql
M3 - User Defined Functions OrderAmountPurchased.sql
M3 - User Defined Functions Proper.sql
M3 - User Defined Functions ProperWithCharacters.sql
M3 - Working with Numbers.sql
M4 - Analyzing with FULL OUTER Join.sql
M4 - FULL OUTER Join.sql
M4 - Formatted FULL OUTER Join.sql
M4 - Formatted Inner Joins.sql
M4 - Inner Joins Formatted Report.sql
M4 - Inner Joins.sql
M4 - JOIN.sql
M4 - Joining from multiple databases.sql
M4 - LEFT JOIN.sql
M4 - RIGHT JOIN.sql
M4 - RIGHT Joins.sql
M4 - Self Joins 3.sql
M4 - Self Joins example 2.sql
M4 - Self Joins.sql
M5 - Comparison operators and NULL.sql
M5 - Controlling Flow IsNumeric and GOTO.sql
M5 - Controlling Flow with IF.sql
M5 - Controlling Flow with WHILE-BREAK-CONTINUE-GOTO.sql
M5 - Filtering Query Results.sql
M5 - Filtering for NULL 1.sql
M5 - Filtering for NULL 2.sql
M5 - Filtering the table examples.sql
M5 - Filtering using IN and NOT IN.sql
M5 - Filtering with Logical Operators.sql
M5 - Filtering with Strings.sql
M5 - LIKE and NOT LIKE filtering.sql
M5 - Logical Operators.sql
M5 - Logical and Logical Operators.sql
M5 - Using quantifiers to filter.sql
M6 - FETCH NEXT.sql
M6 - TOP Functions.sql
M7 - Products COUNT query 2.sql
M7 - Products COUNT query.sql
M7 - Using AVG in T-SQL 1.sql
M7 - Using AVG in T-SQL 2.sql
M7 - Using COUNT in T-SQL.sql
M7 - Using MIN MAX in T-SQL.sql
M7 - Using SUM in T-SQL.sql
M7-Average Sold Products with variables.rpt
M7-Company Sales with Min Max and Avg.rpt
M7-Products and the number of times ordered.rpt
M7-Products number of times ordered and number of products sold.rpt
M8 - Except.sql
M8 - Intercect.sql
M8 - Union All.sql
M8 - Union.sql
M9 - CTE Report.rpt
M9 - Common Table Expressions.sql
M9 - Cursors with TMP Table for updating.sql
M9 - Temprorary Tables 2.sql
M9 - Temprorary Tables.sql
M9 - Using Cursors in T-SQL.sql
SQL Server 2019 Editions Datasheet.pdf
SQL Server Data Type Conversion Chart.png
suppliers and products.rpt
TSFP_2021.bak
database-backup
comments.csv
tsql-dml-script.sql
tsql-dml.bak
demos
data
tsql-xjt.bak
tsql-xml-json-backup.sql
m02
demo-01-querying-json-documents.sql
demo-02-convert-data-into-json.sql
demo-03-convert-data-into-json.sql
demo-04-parsing-and-importing-json.sql
demo-05-parsing-and-importing-json.sql
demo-06-lax-and-strict-mode.sql
top-posts.json
m03
demo-01-selecting-data-from-mxl.sql
demo-02-selecting-data-from-xml.sql
demo-03-providing-rowset-view-with-openmxl.sql
demo-04-providing-rowset-view-with-nodes.sql
demo-05-modifying-xml-data.sql
demo-06-working-with-xpath-query-syntax.sql
demo-07-filtering-data-using-contains-and-exist.sql
posts.xml
m04
demo-01-creating-temporal-tables.sql
demo-02-modifying-data-in-temporal-tables.sql
demo-03-selecting-data-from-temporal-tables.sql
demo-04-recovering-a-temporal-table.sql
initial-setup
Instructions.txt
playlist.m3u
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ DevCourseWeb com ] PluralSight - Learning Path - Querying Data with T-SQL from SQL Server Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
