[ DevCourseWeb.com ] PluralSight - Learning Path - Querying Data with T-SQL from SQL Server

• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/WideWorldImporters-Standard.bak-563.22 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/TSFP_2021.bak-551.16 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xml-json-backup.sql-371.2 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xjt.bak-293.12 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml-script.sql-226.61 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml.bak-32.8 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.mp4-31.47 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.mp4-30.68 MB
• ~Get Your Files Here !/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-30.29 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.mp4-28.4 MB
• ~Get Your Files Here !/Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp4-25.72 MB
• ~Get Your Files Here !/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-25.69 MB
• ~Get Your Files Here !/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.19 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp4-23.34 MB
• ~Get Your Files Here !/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.14 MB
• ~Get Your Files Here !/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.04 MB
• ~Get Your Files Here !/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-22.86 MB
• ~Get Your Files Here !/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.33 MB
• ~Get Your Files Here !/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.15 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.mp4-21.11 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/04. Demo - Transaction Modes.mp4-21.08 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/4. Demo - Actionable Message.mp4-20.95 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/3. Applying T-SQL Logical Operators.mp4-20.89 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/4. Controlling Flow with T-SQL Logic.mp4-20.86 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/7. Demo - Error Table and Stored Procedure.mp4-20.31 MB
• ~Get Your Files Here !/Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/6. Self Join.mp4-20.26 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.mp4-20.07 MB
• ~Get Your Files Here !/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-19.88 MB
• ~Get Your Files Here !/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.25 MB
• ~Get Your Files Here !/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-18.94 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/10. Demo - XACT_ABORT and XACT_STATE.mp4-18.43 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/05. Demo - Error Message Details.mp4-17.54 MB
• ~Get Your Files Here !/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.38 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/07. Demo - Transferring Funds.mp4-16.98 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.mp4-16.95 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/3. Demo - Error Handling Template.mp4-16.47 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/09. Demo - TRY..CATCH.mp4-16.46 MB
• ~Get Your Files Here !/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.19 MB
• ~Get Your Files Here !/T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/7. An Insert Statement with Constraints.mp4-16.09 MB
• ~Get Your Files Here !/Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/06. Demo - Using RAISERROR.mp4-15.99 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/6. Inline View Queries and Subqueries.mp4-15.87 MB
• ~Get Your Files Here !/T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/4. Creating Transactions Using BEGIN and COMMIT.mp4-15.66 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/3. Demo - Creating Templates.mp4-15.64 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.mp4-15.6 MB
• ~Get Your Files Here !/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.36 MB
• ~Get Your Files Here !/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.3 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/2. Product Groups.mp4-15.17 MB
• ~Get Your Files Here !/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.14 MB
• ~Get Your Files Here !/Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/10. Demo - Using Sp_executesql.mp4-14.82 MB
• ~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/3. Product Gender.mp4-14.7 MB