~Get Your Files Here !/2 - Setting Up Your Learning Lab/4 - Using the Pizza DB in this Course.mp4 63.8 MB
~Get Your Files Here !/4 - Create Correlated Subqueries/14 - Correlated subqueries versus Inner Joins which is better.mp4 62.0 MB
~Get Your Files Here !/6 - Write Queries using Derived Tables/21 - Joining Derived Tables.mp4 58.1 MB
~Get Your Files Here !/2 - Setting Up Your Learning Lab/5 - Using the Pizza DB with SQL Server.mp4 44.5 MB
~Get Your Files Here !/3 - Writing your First Subquery/9 - Incorporate Subqueries into Expressions.mp4 40.0 MB
~Get Your Files Here !/1 - Introduction/2 - What is a Subquery.mp4 38.8 MB
~Get Your Files Here !/4 - Create Correlated Subqueries/10 - Demystify Correlated Subqueries.mp4 38.4 MB
~Get Your Files Here !/2 - Setting Up Your Learning Lab/6 - Using the Pizza DB with MySQL.mp4 36.6 MB
~Get Your Files Here !/6 - Write Queries using Derived Tables/20 - What is a Derived Table.mp4 35.0 MB
~Get Your Files Here !/4 - Create Correlated Subqueries/11 - Demystify Correlated Subqueries Example.mp4 33.1 MB
~Get Your Files Here !/5 - Create Subqueries in the WHERE and HAVING Clauses/15 - Get Existential with Exists.mp4 32.4 MB
~Get Your Files Here !/4 - Create Correlated Subqueries/12 - Write a Correlated Subquery with Two Tables.mp4 29.3 MB
~Get Your Files Here !/5 - Create Subqueries in the WHERE and HAVING Clauses/18 - Get fancy and write a correlated subquery in the HAVING clause.mp4 29.2 MB
~Get Your Files Here !/2 - Setting Up Your Learning Lab/3 - Should I use SQL Server MySQL or PostgreSQL to Learn Subqueries.mp4 28.5 MB
~Get Your Files Here !/3 - Writing your First Subquery/8 - Place a subquery in the column list.mp4 28.4 MB
~Get Your Files Here !/5 - Create Subqueries in the WHERE and HAVING Clauses/17 - Subquery in the Having Clause.mp4 27.7 MB
~Get Your Files Here !/5 - Create Subqueries in the WHERE and HAVING Clauses/19 - Get fancy and write a correlated subquery in the HAVING clause Part B.mp4 23.6 MB
~Get Your Files Here !/5 - Create Subqueries in the WHERE and HAVING Clauses/16 - Are you in Use the IN Condition to Test for Membership.mp4 23.6 MB
~Get Your Files Here !/1 - Introduction/1 - Welcome to Subquery Magic.mp4 18.9 MB
~Get Your Files Here !/2 - Setting Up Your Learning Lab/7 - Using the Pizza DB with PostgreSQL.mp4 13.3 MB
T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/WideWorldImporters-Standard.bak 590.6 MB
T-SQL Functions Playbook By Andrew McSwiggan/TSFP_2021.bak 577.9 MB
T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xml-json-backup.sql 389.2 MB
T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xjt.bak 307.4 MB
T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml-script.sql 237.6 MB
T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml.bak 34.4 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.mp4 33.0 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.mp4 32.2 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/5. Using SQL Server Management Studio.mp4 31.8 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.mp4 29.8 MB
Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp4 27.0 MB
Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/4. Adding and Modifying Data in Temporal Tables.mp4 26.9 MB
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 25.4 MB
Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp4 24.5 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/4. Using AVG in T-SQL.mp4 24.3 MB
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 24.2 MB
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 24.0 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/2. Using COUNT in T-SQL.mp4 23.4 MB
Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.mp4 22.2 MB
Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.mp4 22.1 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/Queries Reports Charts Data Files/Data Files/WideWorldImporters-Standard.bak 590.6 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/TSFP_2021.bak 577.9 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xml-json-backup.sql 389.2 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/demos/data/tsql-xjt.bak 307.4 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml-script.sql 237.6 MB
~Get Your Files Here !/T-SQL Functions Playbook By Andrew McSwiggan/database-backup/tsql-dml.bak 34.4 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 33.0 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 32.2 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 31.8 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 29.8 MB
~Get Your Files Here !/Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp4 27.0 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 26.9 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 25.4 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 24.5 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 24.3 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 24.2 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 24.0 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 23.4 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 22.2 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 22.1 MB