|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 01_Adding_Sales_People.sql |
1.44Кб |
| 01_Baseline_Statistics.sql |
2.70Кб |
| 01_Basic_Template.sql |
2.18Кб |
| 01_Creating_and_Executing_Stored_Procedures.sql |
1.39Кб |
| 01_Creating_Demo_Environment.sql |
5.91Кб |
| 01_Expand_ABCCompany_Database.sql |
323.01Кб |
| 01_SQL_Errors.sql |
1.39Кб |
| 01_Transaction_Modes.sql |
2.32Кб |
| 01_UpdateInsertProcedure_Template.sql |
827б |
| 01. Introduction.mp4 |
4.04Мб |
| 01. Introduction.mp4 |
4.94Мб |
| 01. Introduction.mp4 |
3.42Мб |
| 01. Introduction.mp4 |
4.31Мб |
| 01. Introduction.vtt |
3.63Кб |
| 01. Introduction.vtt |
4.35Кб |
| 01. Introduction.vtt |
3.15Кб |
| 01. Introduction.vtt |
4.09Кб |
| 01. Modifying Data Using T-SQL Statements.mp4 |
1.54Мб |
| 01. Modifying Data Using T-SQL Statements.vtt |
1.21Кб |
| 01. Version Check.mp4 |
713.44Кб |
| 01. Version Check.mp4 |
679.50Кб |
| 01. Version Check.vtt |
7б |
| 01. Version Check.vtt |
7б |
| 02_Actionable_Message.sql |
2.75Кб |
| 02_Isolation_Levels_Read.sql |
652б |
| 02_Isolation_Levels_Update.sql |
924б |
| 02_Modify_Sales_Report.sql |
524б |
| 02_Temp_Table_Plan_Reuse.sql |
4.56Кб |
| 02_Temporary_Objects.sql |
2.64Кб |
| 02_Transferring_Funds.sql |
2.44Кб |
| 02_Using_Parameters.sql |
1.68Кб |
| 02_Using_RAISERROR.sql |
1.54Кб |
| 02. Building Queries in Stored Procedures.mp4 |
2.41Мб |
| 02. Building Queries in Stored Procedures.vtt |
2.62Кб |
| 02. Creating Our Stored Procedure.mp4 |
2.96Мб |
| 02. Creating Our Stored Procedure.vtt |
2.76Кб |
| 02. Examining an Error Message.mp4 |
6.26Мб |
| 02. Examining an Error Message.vtt |
7.26Кб |
| 02. Introduction.mp4 |
4.41Мб |
| 02. Introduction.mp4 |
3.90Мб |
| 02. Introduction.vtt |
3.69Кб |
| 02. Introduction.vtt |
3.34Кб |
| 02. Modifying Records with the UPDATE Statement.mp4 |
4.38Мб |
| 02. Modifying Records with the UPDATE Statement.vtt |
3.23Кб |
| 02. What Is the ACID Principle.mp4 |
4.57Мб |
| 02. What Is the ACID Principle.vtt |
5.09Кб |
| 03_Enforce_Business_Logic.sql |
1.42Кб |
| 03_Handling_Conversion_Errors.sql |
963б |
| 03_Limiting_User_Access.sql |
678б |
| 03_Nested_Transactions.sql |
1.33Кб |
| 03_Select_1_Versus_Select_Star.sql |
2.27Кб |
| 03_Table_Valued_Parameters.sql |
1007б |
| 03_TRY_CATCH.sql |
3.89Кб |
| 03_Using_Debugger_Part1.sql |
337б |
| 03_Using_Debugger_Part2.sql |
482б |
| 03. Errors Requiring Attention.mp4 |
3.43Мб |
| 03. Errors Requiring Attention.vtt |
3.21Кб |
| 03. Exploring New Syntax and Executing.mp4 |
4.58Мб |
| 03. Exploring New Syntax and Executing.vtt |
4.23Кб |
| 03. Reviewing Temporary Objects.mp4 |
4.21Мб |
| 03. Reviewing Temporary Objects.vtt |
4.09Кб |
| 03. Transaction Modes in SQL Server.mp4 |
6.10Мб |
| 03. Transaction Modes in SQL Server.vtt |
5.49Кб |
| 03. Using UPDATE to Modify Data in One Row.mp4 |
4.40Мб |
| 03. Using UPDATE to Modify Data in One Row.vtt |
2.68Кб |
| 03. What Is a Stored Procedure.mp4 |
3.74Мб |
| 03. What Is a Stored Procedure.vtt |
3.54Кб |
| 03. Why Care About Error Handling.mp4 |
4.71Мб |
| 03. Why Care About Error Handling.vtt |
4.43Кб |
| 04_Execution_Plan_Reuse.sql |
3.29Кб |
| 04_Parameter_Sniffing.sql |
2.94Кб |
| 04_Row_Count_Mismatch.sql |
1.42Кб |
| 04_Save_Points.sql |
993б |
| 04_Sp_executesql.sql |
2.81Кб |
| 04_XACT_ABORT_XACT_STATE.sql |
4.44Кб |
| 04. Comparing Data Fetching Options.mp4 |
8.00Мб |
| 04. Comparing Data Fetching Options.vtt |
7.16Кб |
| 04. Creating Temporary Objects.mp4 |
3.46Мб |
| 04. Creating Temporary Objects.vtt |
3.17Кб |
| 04. Demo - Transaction Modes.mp4 |
21.08Мб |
| 04. Demo - Transaction Modes.vtt |
9.25Кб |
| 04. Exploring RAISERROR.mp4 |
3.13Мб |
| 04. Exploring RAISERROR.vtt |
2.98Кб |
| 04. Naming Stored Procedures.mp4 |
3.86Мб |
| 04. Naming Stored Procedures.vtt |
3.66Кб |
| 04. Planning For Failure.mp4 |
7.06Мб |
| 04. Planning For Failure.vtt |
6.29Кб |
| 04. Using UPDATE to Modify Data in Multiple Rows.mp4 |
5.59Мб |
| 04. Using UPDATE to Modify Data in Multiple Rows.vtt |
2.55Кб |
| 05_Debug_Flag.sql |
1.71Кб |
| 05_Error_Table.sql |
3.61Кб |
| 05_Using_THROW.sql |
673б |
| 05. Demo - Adding Queries to Stored Procedures.mp4 |
19.88Мб |
| 05. Demo - Adding Queries to Stored Procedures.vtt |
8.95Кб |
| 05. Demo - Creating and Executing.mp4 |
14.24Мб |
| 05. Demo - Creating and Executing.vtt |
7.68Кб |
| 05. Demo - Error Message Details.mp4 |
17.54Мб |
| 05. Demo - Error Message Details.vtt |
8.29Кб |
| 05. Isolation Levels.mp4 |
3.22Мб |
| 05. Isolation Levels.vtt |
3.12Кб |
| 05. Primary Stored Procedure Benefits.mp4 |
3.82Мб |
| 05. Primary Stored Procedure Benefits.vtt |
3.35Кб |
| 05. Retrieving Number of Affected Rows with @@Rowcount.mp4 |
5.62Мб |
| 05. Retrieving Number of Affected Rows with @@Rowcount.vtt |
3.30Кб |
| 05. What Do We Mean By Atomic.mp4 |
4.36Мб |
| 05. What Do We Mean By Atomic.vtt |
4.32Кб |
| 06. Demo - Creating a Test Environment.mp4 |
19.25Мб |
| 06. Demo - Creating a Test Environment.vtt |
8.06Кб |
| 06. Demo - Creating Test Environment.mp4 |
16.95Мб |
| 06. Demo - Creating Test Environment.vtt |
7.53Кб |
| 06. Demo - Isolation Levels.mp4 |
13.72Мб |
| 06. Demo - Isolation Levels.vtt |
6.77Кб |
| 06. Demo - Scripting Stored Procedures.mp4 |
12.91Мб |
| 06. Demo - Scripting Stored Procedures.vtt |
6.65Кб |
| 06. Demo - Using RAISERROR.mp4 |
15.99Мб |
| 06. Demo - Using RAISERROR.vtt |
8.03Кб |
| 06. Demo - Using Temporary Objects.mp4 |
21.15Мб |
| 06. Demo - Using Temporary Objects.vtt |
10.58Кб |
| 06. Modifying Data Using UPDATE with Constraints.mp4 |
7.96Мб |
| 06. Modifying Data Using UPDATE with Constraints.vtt |
4.71Кб |
| 07. Demo - Minimizing Modifications.mp4 |
7.03Мб |
| 07. Demo - Minimizing Modifications.vtt |
3.75Кб |
| 07. Demo - Transferring Funds.mp4 |
16.98Мб |
| 07. Demo - Transferring Funds.vtt |
8.68Кб |
| 07. Exploring Parameters.mp4 |
3.31Мб |
| 07. Exploring Parameters.vtt |
3.54Кб |
| 07. Exploring Table Valued Parameters.mp4 |
5.03Мб |
| 07. Exploring Table Valued Parameters.vtt |
5.04Кб |
| 07. Exploring TRY..CATCH.mp4 |
3.41Мб |
| 07. Exploring TRY..CATCH.vtt |
3.63Кб |
| 07. Nested Transactions.mp4 |
2.47Мб |
| 07. Nested Transactions.vtt |
2.71Кб |
| 07. UPDATE Using Variables.mp4 |
8.76Мб |
| 07. UPDATE Using Variables.vtt |
4.84Кб |
| 08. Demo - Adding Parameters.mp4 |
15.60Мб |
| 08. Demo - Adding Parameters.vtt |
7.80Кб |
| 08. Demo - Nested Transactions.mp4 |
10.42Мб |
| 08. Demo - Nested Transactions.vtt |
5.09Кб |
| 08. Demo - Table Valued Parameters.mp4 |
8.73Мб |
| 08. Demo - Table Valued Parameters.vtt |
4.37Кб |
| 08. Error Handling Methods.mp4 |
3.29Мб |
| 08. Error Handling Methods.vtt |
2.99Кб |
| 08. Exploring Security Benefits.mp4 |
3.17Мб |
| 08. Exploring Security Benefits.vtt |
3.33Кб |
| 08. FROM and JOIN within an UPDATE.mp4 |
7.16Мб |
| 08. FROM and JOIN within an UPDATE.vtt |
3.62Кб |
| 08. Handling Conversion Errors.mp4 |
3.88Мб |
| 08. Handling Conversion Errors.vtt |
3.14Кб |
| 09. A Few More Details on UPDATE.mp4 |
4.40Мб |
| 09. A Few More Details on UPDATE.vtt |
2.58Кб |
| 09. Demo - Handling Conversion Errors.mp4 |
7.82Мб |
| 09. Demo - Handling Conversion Errors.vtt |
4.49Кб |
| 09. Demo - Limiting User Access.mp4 |
7.54Мб |
| 09. Demo - Limiting User Access.vtt |
3.70Кб |
| 09. Demo - Save Points.mp4 |
8.62Мб |
| 09. Demo - Save Points.vtt |
4.61Кб |
| 09. Demo - TRY..CATCH.mp4 |
16.46Мб |
| 09. Demo - TRY..CATCH.vtt |
6.33Кб |
| 09. Examining Sp_executesql.mp4 |
4.72Мб |
| 09. Examining Sp_executesql.vtt |
4.04Кб |
| 09. Exploring Debugger.mp4 |
3.03Мб |
| 09. Exploring Debugger.vtt |
2.75Кб |
| 1. Adding Data Using T-SQL Statements.mp4 |
1.84Мб |
| 1. Adding Data Using T-SQL Statements.vtt |
1.46Кб |
| 1. Aggregating and Summarizing Data with Functions.mp4 |
8.06Мб |
| 1. Aggregating and Summarizing Data with Functions.vtt |
5.74Кб |
| 1. Calculating Values Using Numeric Scalar Functions.mp4 |
10.47Мб |
| 1. Calculating Values Using Numeric Scalar Functions.vtt |
4.89Кб |
| 1. Calculating Values Using String Functions.mp4 |
7.91Мб |
| 1. Calculating Values Using String Functions.vtt |
5.90Кб |
| 1. Combining Queries with COALESCE.mp4 |
13.28Мб |
| 1. Combining Queries with COALESCE.vtt |
7.37Кб |
| 1. Course Overview.mp4 |
3.45Мб |
| 1. Course Overview.mp4 |
4.07Мб |
| 1. Course Overview.mp4 |
3.03Мб |
| 1. Course Overview.mp4 |
4.68Мб |
| 1. Course Overview.mp4 |
4.73Мб |
| 1. Course Overview.mp4 |
3.41Мб |
| 1. Course Overview.mp4 |
4.27Мб |
| 1. Course Overview.vtt |
2.41Кб |
| 1. Course Overview.vtt |
3.02Кб |
| 1. Course Overview.vtt |
2.05Кб |
| 1. Course Overview.vtt |
3.21Кб |
| 1. Course Overview.vtt |
3.28Кб |
| 1. Course Overview.vtt |
2.16Кб |
| 1. Course Overview.vtt |
2.15Кб |
| 1. Creating Measures with Aggregation Functions.mp4 |
7.93Мб |
| 1. Creating Measures with Aggregation Functions.vtt |
5.17Кб |
| 1. Final Takeaway.mp4 |
4.07Мб |
| 1. Final Takeaway.mp4 |
6.14Мб |
| 1. Final Takeaway.vtt |
3.56Кб |
| 1. Final Takeaway.vtt |
5.67Кб |
| 1. Implementing IF Then Logic.mp4 |
3.52Мб |
| 1. Implementing IF Then Logic.vtt |
3.16Кб |
| 1. Introduction.mp4 |
5.11Мб |
| 1. Introduction.mp4 |
2.90Мб |
| 1. Introduction.mp4 |
3.47Мб |
| 1. Introduction.mp4 |
1.51Мб |
| 1. Introduction.mp4 |
2.25Мб |
| 1. Introduction.mp4 |
3.07Мб |
| 1. Introduction.mp4 |
993.25Кб |
| 1. Introduction.mp4 |
1.06Мб |
| 1. Introduction.mp4 |
1.14Мб |
| 1. Introduction.mp4 |
4.10Мб |
| 1. Introduction.vtt |
4.84Кб |
| 1. Introduction.vtt |
3.16Кб |
| 1. Introduction.vtt |
2.23Кб |
| 1. Introduction.vtt |
1.48Кб |
| 1. Introduction.vtt |
2.11Кб |
| 1. Introduction.vtt |
2.37Кб |
| 1. Introduction.vtt |
892б |
| 1. Introduction.vtt |
992б |
| 1. Introduction.vtt |
1.20Кб |
| 1. Introduction.vtt |
3.69Кб |
| 1. Maintaining Data Integrity with Transactions.mp4 |
4.09Мб |
| 1. Maintaining Data Integrity with Transactions.vtt |
3.68Кб |
| 1. Module Introduction.mp4 |
843.13Кб |
| 1. Module Introduction.mp4 |
559.83Кб |
| 1. Module Introduction.mp4 |
724.12Кб |
| 1. Module Introduction.mp4 |
688.27Кб |
| 1. Module Introduction.mp4 |
739.77Кб |
| 1. Module Introduction.mp4 |
882.54Кб |
| 1. Module Introduction.mp4 |
650.42Кб |
| 1. Module Introduction.vtt |
760б |
| 1. Module Introduction.vtt |
484б |
| 1. Module Introduction.vtt |
750б |
| 1. Module Introduction.vtt |
651б |
| 1. Module Introduction.vtt |
688б |
| 1. Module Introduction.vtt |
789б |
| 1. Module Introduction.vtt |
640б |
| 1. Query Data with Inline Queries and Scalar Functions.mp4 |
5.48Мб |
| 1. Query Data with Inline Queries and Scalar Functions.vtt |
4.77Кб |
| 1. Query Data with Static Value Functions.mp4 |
10.02Мб |
| 1. Query Data with Static Value Functions.vtt |
5.23Кб |
| 1. Querying XML Data in Microsoft SQL Server with T-SQL.mp4 |
3.29Мб |
| 1. Querying XML Data in Microsoft SQL Server with T-SQL.vtt |
2.71Кб |
| 1. Ranking Data with Rank and Partition.mp4 |
10.65Мб |
| 1. Ranking Data with Rank and Partition.vtt |
7.05Кб |
| 1. Removing Data Using T-SQL Statements.mp4 |
1.87Мб |
| 1. Removing Data Using T-SQL Statements.vtt |
1.59Кб |
| 1. Substituting a Table Reference with a ROWSET Function.mp4 |
13.02Мб |
| 1. Substituting a Table Reference with a ROWSET Function.vtt |
7.60Кб |
| 1. Summary.mp4 |
1.48Мб |
| 1. Summary.vtt |
591б |
| 1. Using Advanced T-SQL Techniques.mp4 |
1.55Мб |
| 1. Using Advanced T-SQL Techniques.vtt |
1.10Кб |
| 1. Utilizing Temporal Tables.mp4 |
1.65Мб |
| 1. Utilizing Temporal Tables.vtt |
1.10Кб |
| 1. Version Check.mp4 |
570.23Кб |
| 1. Version Check.mp4 |
487.60Кб |
| 1. Version Check.mp4 |
538.63Кб |
| 1. Version Check.mp4 |
514.93Кб |
| 1. Version Check.vtt |
7б |
| 1. Version Check.vtt |
7б |
| 1. Version Check.vtt |
7б |
| 1. Version Check.vtt |
7б |
| 10. Demo - Debugging Code.mp4 |
12.81Мб |
| 10. Demo - Debugging Code.vtt |
6.99Кб |
| 10. Demo - Using Sp_executesql.mp4 |
14.82Мб |
| 10. Demo - Using Sp_executesql.vtt |
6.36Кб |
| 10. Demo - XACT_ABORT and XACT_STATE.mp4 |
18.43Мб |
| 10. Demo - XACT_ABORT and XACT_STATE.vtt |
6.47Кб |
| 10. Exploring Performance Gains.mp4 |
3.06Мб |
| 10. Exploring Performance Gains.vtt |
3.40Кб |
| 10. Summary.mp4 |
2.03Мб |
| 10. Summary.mp4 |
2.51Мб |
| 10. Summary.vtt |
1.70Кб |
| 10. Summary.vtt |
2.29Кб |
| 10. Takeaway.mp4 |
1.77Мб |
| 10. Takeaway.vtt |
1.73Кб |
| 11. Demo - Execution Plan Reuse.mp4 |
14.45Мб |
| 11. Demo - Execution Plan Reuse.vtt |
6.11Кб |
| 11. Exploring THROW.mp4 |
3.17Мб |
| 11. Exploring THROW.vtt |
3.33Кб |
| 11. Implementing a Debug Flag.mp4 |
2.80Мб |
| 11. Implementing a Debug Flag.vtt |
3.03Кб |
| 11. Reviewing Best Practices.mp4 |
4.08Мб |
| 11. Reviewing Best Practices.vtt |
4.31Кб |
| 12. Demo - Adding a Debug Flag.mp4 |
9.16Мб |
| 12. Demo - Adding a Debug Flag.vtt |
4.14Кб |
| 12. Demo - THROW.mp4 |
7.55Мб |
| 12. Demo - THROW.vtt |
4.43Кб |
| 12. Disadvantages of Stored Procedures.mp4 |
3.67Мб |
| 12. Disadvantages of Stored Procedures.vtt |
3.87Кб |
| 12. Summary.mp4 |
2.91Мб |
| 12. Summary.vtt |
2.59Кб |
| 13. Summary.mp4 |
2.45Мб |
| 13. Summary.mp4 |
2.69Мб |
| 13. Summary.mp4 |
3.00Мб |
| 13. Summary.vtt |
2.25Кб |
| 13. Summary.vtt |
2.58Кб |
| 13. Summary.vtt |
2.38Кб |
| 2. Adding New Records with the INSERT Statement.mp4 |
5.46Мб |
| 2. Adding New Records with the INSERT Statement.vtt |
3.11Кб |
| 2. Adding the COALESCE Function to a Query.mp4 |
10.81Мб |
| 2. Adding the COALESCE Function to a Query.vtt |
3.91Кб |
| 2. A Tour of the Data.mp4 |
6.67Мб |
| 2. A Tour of the Data.vtt |
3.57Кб |
| 2. Comparing RAISERROR and THROW.mp4 |
4.71Мб |
| 2. Comparing RAISERROR and THROW.vtt |
4.21Кб |
| 2. Course Review.mp4 |
5.09Мб |
| 2. Course Review.vtt |
4.04Кб |
| 2. Creating a Baseline.mp4 |
4.10Мб |
| 2. Creating a Baseline.vtt |
3.83Кб |
| 2. Defining Stored Procedure Templates.mp4 |
3.06Мб |
| 2. Defining Stored Procedure Templates.vtt |
3.21Кб |
| 2. Difference between Joins and Set Operators.mp4 |
1.22Мб |
| 2. Difference between Joins and Set Operators.vtt |
929б |
| 2. Evaluating SELECT Expressions.mp4 |
6.94Мб |
| 2. Evaluating SELECT Expressions.vtt |
4.66Кб |
| 2. Expressions and Comparison Operators.mp4 |
30.68Мб |
| 2. Expressions and Comparison Operators.vtt |
11.64Кб |
| 2. Formatting Strings with Stuff and Replace.mp4 |
10.08Мб |
| 2. Formatting Strings with Stuff and Replace.vtt |
5.71Кб |
| 2. Introduction.mp4 |
4.27Мб |
| 2. Introduction.vtt |
2.67Кб |
| 2. Law of Order.mp4 |
4.63Мб |
| 2. Law of Order.vtt |
3.70Кб |
| 2. Module Introduction.mp4 |
683.81Кб |
| 2. Module Introduction.vtt |
682б |
| 2. Monthly Rolling Sales with GETDATE.mp4 |
9.04Мб |
| 2. Monthly Rolling Sales with GETDATE.vtt |
5.56Кб |
| 2. Offset and Fetch.mp4 |
6.66Мб |
| 2. Offset and Fetch.vtt |
4.18Кб |
| 2. OPENROWSET Queries.mp4 |
9.50Мб |
| 2. OPENROWSET Queries.vtt |
5.71Кб |
| 2. Product Groups.mp4 |
15.17Мб |
| 2. Product Groups.vtt |
7.22Кб |
| 2. Querying JSON in Microsoft SQL Server.mp4 |
7.04Мб |
| 2. Querying JSON in Microsoft SQL Server.vtt |
5.39Кб |
| 2. Removing Records with the DELETE Statement.mp4 |
1.46Мб |
| 2. Removing Records with the DELETE Statement.vtt |
1.70Кб |
| 2. Searching for Strings with the LIKE Function.mp4 |
3.98Мб |
| 2. Searching for Strings with the LIKE Function.vtt |
3.78Кб |
| 2. The Percent Rank Function.mp4 |
12.97Мб |
| 2. The Percent Rank Function.vtt |
5.13Кб |
| 2. The Rank Function.mp4 |
8.28Мб |
| 2. The Rank Function.vtt |
4.99Кб |
| 2. The Round Function.mp4 |
8.44Мб |
| 2. The Round Function.vtt |
4.57Кб |
| 2. The SELECT Query Syntax.mp4 |
1.82Мб |
| 2. The SELECT Query Syntax.vtt |
1.49Кб |
| 2. Transaction Properties.mp4 |
1.94Мб |
| 2. Transaction Properties.vtt |
2.40Кб |
| 2. TSQL Demo Database.mp4 |
7.52Мб |
| 2. TSQL Demo Database.vtt |
5.41Кб |
| 2. Understanding NULLs.mp4 |
2.75Мб |
| 2. Understanding NULLs.vtt |
2.84Кб |
| 2. Understanding Primary and Foreign Keys.mp4 |
8.09Мб |
| 2. Understanding Primary and Foreign Keys.vtt |
5.28Кб |
| 2. Understanding Temporal or System-versioned Tables.mp4 |
6.94Мб |
| 2. Understanding Temporal or System-versioned Tables.vtt |
5.93Кб |
| 2. Using Common Table Expressions in T-SQL.mp4 |
22.86Мб |
| 2. Using Common Table Expressions in T-SQL.vtt |
9.35Кб |
| 2. Using COUNT in T-SQL.mp4 |
22.33Мб |
| 2. Using COUNT in T-SQL.vtt |
10.81Кб |
| 2. Using INSERT with Multiple Values.mp4 |
4.26Мб |
| 2. Using INSERT with Multiple Values.vtt |
3.06Кб |
| 2. What Is a SQL Query.mp4 |
3.80Мб |
| 2. What Is a SQL Query.vtt |
3.75Кб |
| 2. What Is Grouping Good For.mp4 |
25.72Мб |
| 2. What Is Grouping Good For.vtt |
4.61Кб |
| 2. What is XML How Do I Build Good XML.mp4 |
11.86Мб |
| 2. What is XML How Do I Build Good XML.vtt |
8.71Кб |
| 2. Working with the T-SQL Data Manipulation Language.mp4 |
6.81Мб |
| 2. Working with the T-SQL Data Manipulation Language.vtt |
4.76Кб |
| 3. 3VL (Ternary) Logic.mp4 |
6.26Мб |
| 3. 3VL (Ternary) Logic.vtt |
5.41Кб |
| 3. An Insert Statement with Columns and Values.mp4 |
8.93Мб |
| 3. An Insert Statement with Columns and Values.vtt |
4.90Кб |
| 3. Applying T-SQL Logical Operators.mp4 |
20.89Мб |
| 3. Applying T-SQL Logical Operators.vtt |
10.33Кб |
| 3. Concatenating Values in T-SQL.mp4 |
10.25Мб |
| 3. Concatenating Values in T-SQL.vtt |
6.45Кб |
| 3. Creating A B Customer Tags with Modulus.mp4 |
12.06Мб |
| 3. Creating A B Customer Tags with Modulus.vtt |
5.67Кб |
| 3. Creating an Aggregation Query.mp4 |
6.71Мб |
| 3. Creating an Aggregation Query.vtt |
4.09Кб |
| 3. Creating Temporal and History Tables.mp4 |
5.23Мб |
| 3. Creating Temporal and History Tables.vtt |
3.24Кб |
| 3. Cutting out the Product Attributes.mp4 |
9.12Мб |
| 3. Cutting out the Product Attributes.vtt |
5.53Кб |
| 3. Dealing with NULLs.mp4 |
2.34Мб |
| 3. Dealing with NULLs.vtt |
2.13Кб |
| 3. Demo - Creating Templates.mp4 |
15.64Мб |
| 3. Demo - Creating Templates.vtt |
7.48Кб |
| 3. Demo - Error Handling Template.mp4 |
16.47Мб |
| 3. Demo - Error Handling Template.vtt |
7.97Кб |
| 3. Demo - FROM Single Table.mp4 |
7.51Мб |
| 3. Demo - FROM Single Table.vtt |
3.65Кб |
| 3. Demo - Gathering Baseline Stats.mp4 |
20.07Мб |
| 3. Demo - Gathering Baseline Stats.vtt |
9.26Кб |
| 3. First and Last Value.mp4 |
11.79Мб |
| 3. First and Last Value.vtt |
7.89Кб |
| 3. Grouping Rows.mp4 |
10.06Мб |
| 3. Grouping Rows.vtt |
7.34Кб |
| 3. Joining Multiple Queries with COALESCE.mp4 |
5.45Мб |
| 3. Joining Multiple Queries with COALESCE.vtt |
2.72Кб |
| 3. LIKE Function Demo.mp4 |
10.66Мб |
| 3. LIKE Function Demo.vtt |
4.88Кб |
| 3. More Terminology.mp4 |
7.44Мб |
| 3. More Terminology.vtt |
5.83Кб |
| 3. ORDER BY.mp4 |
2.41Мб |
| 3. ORDER BY.vtt |
2.34Кб |
| 3. Product Gender.mp4 |
14.70Мб |
| 3. Product Gender.vtt |
8.16Кб |
| 3. Removing a Specific Record with DELETE.mp4 |
3.99Мб |
| 3. Removing a Specific Record with DELETE.vtt |
2.77Кб |
| 3. Selecting Data from XML - OPENXML and the query and value Methods.mp4 |
24.19Мб |
| 3. Selecting Data from XML - OPENXML and the query and value Methods.vtt |
14.43Кб |
| 3. SELECT within an INSERT Statement.mp4 |
8.30Мб |
| 3. SELECT within an INSERT Statement.vtt |
5.28Кб |
| 3. Setting up the SQL Server Environment.mp4 |
6.72Мб |
| 3. Setting up the SQL Server Environment.vtt |
3.31Кб |
| 3. Takeaway.mp4 |
2.70Мб |
| 3. Takeaway.vtt |
2.52Кб |
| 3. The Dense Rank Function.mp4 |
13.99Мб |
| 3. The Dense Rank Function.vtt |
6.89Кб |
| 3. TOP Functions.mp4 |
11.91Мб |
| 3. TOP Functions.vtt |
6.39Кб |
| 3. Understanding and Differentiating the T-SQL Sub-languages.mp4 |
2.71Мб |
| 3. Understanding and Differentiating the T-SQL Sub-languages.vtt |
2.91Кб |
| 3. Understanding T-SQL Transactions.mp4 |
3.82Мб |
| 3. Understanding T-SQL Transactions.vtt |
4.53Кб |
| 3. Union All.mp4 |
5.13Мб |
| 3. Union All.vtt |
2.10Кб |
| 3. Using SUM in T-SQL.mp4 |
9.79Мб |
| 3. Using SUM in T-SQL.vtt |
3.49Кб |
| 3. Using Temporary Tables in T-SQL.mp4 |
10.28Мб |
| 3. Using Temporary Tables in T-SQL.vtt |
4.64Кб |
| 3. Using the Inner Join.mp4 |
12.25Мб |
| 3. Using the Inner Join.vtt |
6.86Кб |
| 3. What Is JSON What About JSON in SQL Server.mp4 |
10.94Мб |
| 3. What Is JSON What About JSON in SQL Server.vtt |
8.36Кб |
| 3. What Is T-SQL.mp4 |
5.49Мб |
| 3. What Is T-SQL.vtt |
5.03Кб |
| 4. Adding and Modifying Data in Temporal Tables.mp4 |
25.69Мб |
| 4. Adding and Modifying Data in Temporal Tables.vtt |
6.74Кб |
| 4. A Little SQL Server Architecture.mp4 |
7.87Мб |
| 4. A Little SQL Server Architecture.vtt |
6.72Кб |
| 4. An Insert Statement with All Values.mp4 |
4.00Мб |
| 4. An Insert Statement with All Values.vtt |
2.70Кб |
| 4. Busting Performance Myths.mp4 |
4.45Мб |
| 4. Busting Performance Myths.vtt |
3.83Кб |
| 4. Casting and Converting Data Types.mp4 |
17.38Мб |
| 4. Casting and Converting Data Types.vtt |
10.13Кб |
| 4. Controlling Flow with T-SQL Logic.mp4 |
20.86Мб |
| 4. Controlling Flow with T-SQL Logic.vtt |
13.33Кб |
| 4. Creating Alternating Customer A B Tags.mp4 |
4.01Мб |
| 4. Creating Alternating Customer A B Tags.vtt |
1.74Кб |
| 4. Creating SQL Server Databases.mp4 |
10.48Мб |
| 4. Creating SQL Server Databases.vtt |
7.81Кб |
| 4. Creating Statements with Simple Scalar Functions.mp4 |
9.68Мб |
| 4. Creating Statements with Simple Scalar Functions.vtt |
5.14Кб |
| 4. Creating Transactions Using BEGIN and COMMIT.mp4 |
15.66Мб |
| 4. Creating Transactions Using BEGIN and COMMIT.vtt |
10.38Кб |
| 4. Demo - Actionable Message.mp4 |
20.95Мб |
| 4. Demo - Actionable Message.vtt |
9.90Кб |
| 4. Demo - First SELECT.mp4 |
10.84Мб |
| 4. Demo - First SELECT.vtt |
6.21Кб |
| 4. Determinism and Tiebreakers.mp4 |
2.23Мб |
| 4. Determinism and Tiebreakers.vtt |
1.92Кб |
| 4. Exploring Key Takeaways.mp4 |
3.83Мб |
| 4. Exploring Key Takeaways.vtt |
4.20Кб |
| 4. Feedback.mp4 |
1.33Мб |
| 4. Feedback.vtt |
1.30Кб |
| 4. Getting to Know the XPath Syntax and XQuery Language.mp4 |
14.01Мб |
| 4. Getting to Know the XPath Syntax and XQuery Language.vtt |
11.26Кб |
| 4. Group Filtering with HAVING.mp4 |
4.60Мб |
| 4. Group Filtering with HAVING.vtt |
2.90Кб |
| 4. Intelligent Measures.mp4 |
7.40Мб |
| 4. Intelligent Measures.vtt |
3.32Кб |
| 4. Introduction to Multiple Tables in FROM.mp4 |
9.19Мб |
| 4. Introduction to Multiple Tables in FROM.vtt |
5.37Кб |
| 4. Left and Right Joins.mp4 |
11.15Мб |
| 4. Left and Right Joins.vtt |
4.48Кб |
| 4. Logical Predicates and Operators.mp4 |
7.51Мб |
| 4. Logical Predicates and Operators.vtt |
6.65Кб |
| 4. Pivoting the Attributes.mp4 |
10.13Мб |
| 4. Pivoting the Attributes.vtt |
3.82Кб |
| 4. Querying JSON Documents with T-SQL.mp4 |
8.64Мб |
| 4. Querying JSON Documents with T-SQL.vtt |
6.17Кб |
| 4. Querying Unique Lists of Values.mp4 |
8.10Мб |
| 4. Querying Unique Lists of Values.vtt |
4.16Кб |
| 4. Removing Multiple Records with DELETE.mp4 |
9.36Мб |
| 4. Removing Multiple Records with DELETE.vtt |
5.05Кб |
| 4. The NTILE Function.mp4 |
6.50Мб |
| 4. The NTILE Function.vtt |
4.11Кб |
| 4. Union.mp4 |
3.40Мб |
| 4. Union.vtt |
1.86Кб |
| 4. Using AVG in T-SQL.mp4 |
23.14Мб |
| 4. Using AVG in T-SQL.vtt |
8.92Кб |
| 4. Using Cursors in T-SQL.mp4 |
15.36Мб |
| 4. Using Cursors in T-SQL.vtt |
7.73Кб |
| 4. Using DISTINCT.mp4 |
6.05Мб |
| 4. Using DISTINCT.vtt |
3.53Кб |
| 4. Using SELECT to Retrieve a Specific Field in an INSERT.mp4 |
6.70Мб |
| 4. Using SELECT to Retrieve a Specific Field in an INSERT.vtt |
4.08Кб |
| 4. Using Variables to Limit Results.mp4 |
9.52Мб |
| 4. Using Variables to Limit Results.vtt |
5.17Кб |
| 4. What Is the T-SQL Data Manipulation Language.mp4 |
1.81Мб |
| 4. What Is the T-SQL Data Manipulation Language.vtt |
1.97Кб |
| 5. Analysing Sales Using Product Attributes.mp4 |
10.59Мб |
| 5. Analysing Sales Using Product Attributes.vtt |
5.38Кб |
| 5. An Insert Statement with NULL and DEFAULT.mp4 |
8.56Мб |
| 5. An Insert Statement with NULL and DEFAULT.vtt |
5.45Кб |
| 5. Continuing the Journey.mp4 |
2.68Мб |
| 5. Continuing the Journey.vtt |
2.68Кб |
| 5. Converting Data into JSON with FOR JSON PATH and AUTO.mp4 |
15.30Мб |
| 5. Converting Data into JSON with FOR JSON PATH and AUTO.vtt |
7.33Кб |
| 5. Deleting Data Using JOINs.mp4 |
5.27Мб |
| 5. Deleting Data Using JOINs.vtt |
3.86Кб |
| 5. Demo - Enforcing Business Logic.mp4 |
11.95Мб |
| 5. Demo - Enforcing Business Logic.vtt |
5.56Кб |
| 5. Demo - Multiple Tables.mp4 |
10.44Мб |
| 5. Demo - Multiple Tables.vtt |
5.78Кб |
| 5. Demo - Temp Table Myth.mp4 |
12.95Мб |
| 5. Demo - Temp Table Myth.vtt |
5.46Кб |
| 5. Filtering with WHERE.mp4 |
9.31Мб |
| 5. Filtering with WHERE.vtt |
5.50Кб |
| 5. Formatting Functions.mp4 |
6.85Мб |
| 5. Formatting Functions.vtt |
4.31Кб |
| 5. Formatting Strings.mp4 |
21.11Мб |
| 5. Formatting Strings.vtt |
11.27Кб |
| 5. Full OUTER Joins.mp4 |
11.66Мб |
| 5. Full OUTER Joins.vtt |
4.19Кб |
| 5. Intersect.mp4 |
7.83Мб |
| 5. Intersect.vtt |
3.13Кб |
| 5. Module Review.mp4 |
1.17Мб |
| 5. Module Review.mp4 |
3.54Мб |
| 5. Module Review.mp4 |
898.91Кб |
| 5. Module Review.vtt |
1.10Кб |
| 5. Module Review.vtt |
2.76Кб |
| 5. Module Review.vtt |
952б |
| 5. Next Steps.mp4 |
1.89Мб |
| 5. Next Steps.vtt |
1.98Кб |
| 5. Paging Result Sets.mp4 |
3.86Мб |
| 5. Paging Result Sets.vtt |
3.37Кб |
| 5. Providing Rowset Views with OPENXML and the nodes Method.mp4 |
15.14Мб |
| 5. Providing Rowset Views with OPENXML and the nodes Method.vtt |
9.67Кб |
| 5. Querying Aggregations in Lists.mp4 |
13.94Мб |
| 5. Querying Aggregations in Lists.vtt |
8.36Кб |
| 5. Querying Data Locked in a Transaction with NOLOCK.mp4 |
5.88Мб |
| 5. Querying Data Locked in a Transaction with NOLOCK.vtt |
4.59Кб |
| 5. Retrieving Records on INSERT Using the OUTPUT Clause.mp4 |
12.67Мб |
| 5. Retrieving Records on INSERT Using the OUTPUT Clause.vtt |
6.53Кб |
| 5. Review and Resources.mp4 |
2.43Мб |
| 5. Review and Resources.mp4 |
1.94Мб |
| 5. Review and Resources.mp4 |
1.53Мб |
| 5. Review and Resources.vtt |
1.96Кб |
| 5. Review and Resources.vtt |
1.67Кб |
| 5. Review and Resources.vtt |
1.07Кб |
| 5. Selecting Data from Temporal Tables at Specific Points in Time.mp4 |
9.55Мб |
| 5. Selecting Data from Temporal Tables at Specific Points in Time.vtt |
5.97Кб |
| 5. The Database for This Training - StackOverflow or StackExchange.mp4 |
16.19Мб |
| 5. The Database for This Training - StackOverflow or StackExchange.vtt |
7.06Кб |
| 5. Tools.mp4 |
3.86Мб |
| 5. Tools.vtt |
3.14Кб |
| 5. Using MIN and MAX in T-SQL.mp4 |
23.04Мб |
| 5. Using MIN and MAX in T-SQL.vtt |
10.52Кб |
| 5. Using SQL Server Management Studio.mp4 |
30.29Мб |
| 5. Using SQL Server Management Studio.vtt |
13.63Кб |
| 6. Additional Resources and Conclusion.mp4 |
2.19Мб |
| 6. Additional Resources and Conclusion.vtt |
2.34Кб |
| 6. An Insert Statement with an Identity.mp4 |
6.57Мб |
| 6. An Insert Statement with an Identity.vtt |
4.21Кб |
| 6. Demo - Ordering and Paging.mp4 |
14.14Мб |
| 6. Demo - Ordering and Paging.vtt |
7.56Кб |
| 6. Demo - Row Count Mismatch.mp4 |
10.03Мб |
| 6. Demo - Row Count Mismatch.vtt |
5.40Кб |
| 6. Demo - Select 1 Versus Select.mp4 |
12.05Мб |
| 6. Demo - Select 1 Versus Select.vtt |
5.39Кб |
| 6. Demo - Tools.mp4 |
7.27Мб |
| 6. Demo - Tools.vtt |
4.46Кб |
| 6. Except.mp4 |
11.36Мб |
| 6. Except.vtt |
5.25Кб |
| 6. Inline View Queries and Subqueries.mp4 |
15.87Мб |
| 6. Inline View Queries and Subqueries.vtt |
7.77Кб |
| 6. Module Review.mp4 |
1.45Мб |
| 6. Module Review.mp4 |
1.26Мб |
| 6. Module Review.vtt |
1.48Кб |
| 6. Module Review.vtt |
1.45Кб |
| 6. Recovering Data in a Temporal Table.mp4 |
6.60Мб |
| 6. Recovering Data in a Temporal Table.vtt |
4.20Кб |
| 6. Removing Data with Constraints and Cascade Deleting of Data.mp4 |
14.01Мб |
| 6. Removing Data with Constraints and Cascade Deleting of Data.vtt |
8.28Кб |
| 6. Review and Resources.mp4 |
1.24Мб |
| 6. Review and Resources.vtt |
1.17Кб |
| 6. Self Join.mp4 |
20.26Мб |
| 6. Self Join.vtt |
9.81Кб |
| 6. Summary and Resources.mp4 |
1.18Мб |
| 6. Summary and Resources.vtt |
842б |
| 6. Undoing Transactions Using ROLLBACK.mp4 |
5.05Мб |
| 6. Undoing Transactions Using ROLLBACK.vtt |
3.69Кб |
| 6. Updating XML with modify and the XML Data Modification Language.mp4 |
8.13Мб |
| 6. Updating XML with modify and the XML Data Modification Language.vtt |
5.62Кб |
| 6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.mp4 |
4.96Мб |
| 6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.vtt |
4.05Кб |
| 6. Utilizing MERGE to Perform Operations on a Target Table.mp4 |
12.04Мб |
| 6. Utilizing MERGE to Perform Operations on a Target Table.vtt |
7.26Кб |
| 6. What You Need to Know About SELECT for DML.mp4 |
18.94Мб |
| 6. What You Need to Know About SELECT for DML.vtt |
11.63Кб |
| 6. Working with Characters.mp4 |
28.40Мб |
| 6. Working with Characters.vtt |
16.97Кб |
| 7. An Insert Statement with Constraints.mp4 |
16.09Мб |
| 7. An Insert Statement with Constraints.vtt |
7.77Кб |
| 7. BULK INSERT Using a Format File.mp4 |
12.64Мб |
| 7. BULK INSERT Using a Format File.vtt |
6.72Кб |
| 7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp4 |
11.81Мб |
| 7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.vtt |
8.89Кб |
| 7. Demo - Error Table and Stored Procedure.mp4 |
20.31Мб |
| 7. Demo - Error Table and Stored Procedure.vtt |
9.23Кб |
| 7. Exploring Parameter Sniffing.mp4 |
3.55Мб |
| 7. Exploring Parameter Sniffing.vtt |
3.50Кб |
| 7. Filtering XML Data with Contains and Exist.mp4 |
8.46Мб |
| 7. Filtering XML Data with Contains and Exist.vtt |
5.20Кб |
| 7. Formatting Dates and Numbers.mp4 |
31.47Мб |
| 7. Formatting Dates and Numbers.vtt |
14.62Кб |
| 7. Module Review.mp4 |
2.18Мб |
| 7. Module Review.mp4 |
3.06Мб |
| 7. Module Review.vtt |
1.90Кб |
| 7. Module Review.vtt |
2.63Кб |
| 7. Parsing and Importing JSON with OPENROWSET and OPENJSON.mp4 |
11.41Мб |
| 7. Parsing and Importing JSON with OPENROWSET and OPENJSON.vtt |
9.09Кб |
| 7. Partially Undoing Transactions Using Savepoints.mp4 |
10.65Мб |
| 7. Partially Undoing Transactions Using Savepoints.vtt |
7.34Кб |
| 7. Review and Resources.mp4 |
2.30Мб |
| 7. Review and Resources.mp4 |
2.87Мб |
| 7. Review and Resources.vtt |
2.17Кб |
| 7. Review and Resources.vtt |
2.66Кб |
| 7. Takeaway.mp4 |
2.01Мб |
| 7. Takeaway.vtt |
1.71Кб |
| 7. The Subquery.mp4 |
6.45Мб |
| 7. The Subquery.vtt |
3.44Кб |
| 7. What You Need to Know About WHERE for DML.mp4 |
14.24Мб |
| 7. What You Need to Know About WHERE for DML.vtt |
7.08Кб |
| 8. Adding Multiple Records from a Data File with BULK INSERT.mp4 |
10.19Мб |
| 8. Adding Multiple Records from a Data File with BULK INSERT.vtt |
7.04Кб |
| 8. Course Summary.mp4 |
3.80Мб |
| 8. Course Summary.vtt |
3.45Кб |
| 8. Demo - Parameter Sniffing.mp4 |
23.34Мб |
| 8. Demo - Parameter Sniffing.vtt |
10.12Кб |
| 8. Distributed Transactions at a High Level.mp4 |
2.37Мб |
| 8. Distributed Transactions at a High Level.vtt |
2.02Кб |
| 8. Handling Missing Properties with LAX and STRICT Mode.mp4 |
12.37Мб |
| 8. Handling Missing Properties with LAX and STRICT Mode.vtt |
7.33Кб |
| 8. Review and Resources.mp4 |
1.58Мб |
| 8. Review and Resources.vtt |
1.23Кб |
| 8. Takeaway.mp4 |
2.03Мб |
| 8. Takeaway.mp4 |
966.55Кб |
| 8. Takeaway.mp4 |
2.04Мб |
| 8. Takeaway.mp4 |
2.80Мб |
| 8. Takeaway.vtt |
2.00Кб |
| 8. Takeaway.vtt |
842б |
| 8. Takeaway.vtt |
2.06Кб |
| 8. Takeaway.vtt |
2.56Кб |
| 9. Summary.mp4 |
2.64Мб |
| 9. Summary.vtt |
2.50Кб |
| 9. Takeaway.mp4 |
2.15Мб |
| 9. Takeaway.mp4 |
1.40Мб |
| 9. Takeaway.mp4 |
1.81Мб |
| 9. Takeaway.vtt |
2.00Кб |
| 9. Takeaway.vtt |
1.23Кб |
| 9. Takeaway.vtt |
1.90Кб |
| adding-data-using-t-sql-statements-slides.pdf |
1.33Мб |
| Advanced.txt |
7.31Кб |
| aggregating-and-summarizing-data-with-functions-slides.pdf |
232.31Кб |
| aggregating-data-in-a-query-slides.pdf |
294.30Кб |
| building-stored-procedures-in-the-real-world-slides.pdf |
175.10Кб |
| calculating-values-using-numeric-scalar-functions-slides.pdf |
640.42Кб |
| calculating-values-using-string-functions-slides.pdf |
222.08Кб |
| Combining and Filtering Data with T-SQL Final Report.sql |
3.82Кб |
| combining-queries-with-coalesce-slides.pdf |
222.08Кб |
| comments.csv |
300б |
| creating-measures-with-aggregation-functions-slides.pdf |
1001.37Кб |
| creating-our-first-stored-procedure-slides.pdf |
209.81Кб |
| DataTableExample.html |
68.13Кб |
| DELETE.txt |
7.18Кб |
| demo-01-creating-temporal-tables.sql |
698б |
| demo-01-creating-temporal-tables.sql |
698б |
| demo-01-querying-json-documents.sql |
383б |
| demo-01-querying-json-documents.sql |
383б |
| demo-01-selecting-data-from-mxl.sql |
3.68Кб |
| demo-01-selecting-data-from-mxl.sql |
3.68Кб |
| demo-02-convert-data-into-json.sql |
489б |
| demo-02-convert-data-into-json.sql |
489б |
| demo-02-modifying-data-in-temporal-tables.sql |
1.64Кб |
| demo-02-modifying-data-in-temporal-tables.sql |
1.64Кб |
| demo-02-selecting-data-from-xml.sql |
486б |
| demo-02-selecting-data-from-xml.sql |
486б |
| demo-03-convert-data-into-json.sql |
327б |
| demo-03-convert-data-into-json.sql |
327б |
| demo-03-providing-rowset-view-with-openmxl.sql |
1.25Кб |
| demo-03-providing-rowset-view-with-openmxl.sql |
1.25Кб |
| demo-03-selecting-data-from-temporal-tables.sql |
373б |
| demo-03-selecting-data-from-temporal-tables.sql |
373б |
| demo-04-parsing-and-importing-json.sql |
247б |
| demo-04-parsing-and-importing-json.sql |
247б |
| demo-04-providing-rowset-view-with-nodes.sql |
1.16Кб |
| demo-04-providing-rowset-view-with-nodes.sql |
1.16Кб |
| demo-04-recovering-a-temporal-table.sql |
633б |
| demo-04-recovering-a-temporal-table.sql |
633б |
| demo-05-modifying-xml-data.sql |
1003б |
| demo-05-modifying-xml-data.sql |
1003б |
| demo-05-parsing-and-importing-json.sql |
548б |
| demo-05-parsing-and-importing-json.sql |
548б |
| demo-06-lax-and-strict-mode.sql |
486б |
| demo-06-lax-and-strict-mode.sql |
486б |
| demo-06-working-with-xpath-query-syntax.sql |
549б |
| demo-06-working-with-xpath-query-syntax.sql |
549б |
| demo-07-filtering-data-using-contains-and-exist.sql |
427б |
| demo-07-filtering-data-using-contains-and-exist.sql |
427б |
| evaluating-select-expressions-slides.pdf |
435.97Кб |
| examining-error-handling-methods-slides.pdf |
781.10Кб |
| exploring-the-benefits-of-stored-procedures-slides.pdf |
432.50Кб |
| exploring-transactions-in-sql-server-slides.pdf |
697.27Кб |
| filtering-and-controlling-flow-slides.pdf |
1.68Мб |
| filtering-with-where-slides.pdf |
644.01Кб |
| final-takeaway-slides.pdf |
158.37Кб |
| final-takeaway-slides.pdf |
399.39Кб |
| getting-started-with-error-handling-in-t-sql-slides.pdf |
1.05Мб |
| grouping-rows-slides.pdf |
1023.54Кб |
| handling-errors-in-the-real-world-slides.pdf |
420.00Кб |
| implementing-if-then-logic-slides.pdf |
187.01Кб |
| INSERT.txt |
10.28Кб |
| Instructions.txt |
835б |
| limiting-the-results-with-t-sql-functions-slides.pdf |
722.50Кб |
| M3 - Calling a User Defined Function.sql |
588б |
| M3 - Casting and Converting Data Types.sql |
497б |
| M3 - Casting and Converting Data Types 2.sql |
1.44Кб |
| M3 - Casting and Converting in T-SQL.sql |
878б |
| M3 - Character Functions.sql |
670б |
| M3 - Concatenation sample.sql |
2.88Кб |
| M3 - Datepart.sql |
3.17Кб |
| M3 - Employee tenure with DATE - CASE.sql |
3.27Кб |
| M3 - Formatting Character Functions.sql |
1.71Кб |
| M3 - Formatting Dates and Numerical Values.sql |
140б |
| M3 - Formatting numeric values and ordering.sql |
698б |
| M3 - Formatting String - PatIndex.sql |
1.11Кб |
| M3 - Formatting Strings.sql |
6.14Кб |
| M3 - Formatting Strings 2.sql |
213б |
| M3 - Formatting Strings - Adding Concatenation.sql |
796б |
| M3 - Formatting Strings - Characters.sql |
611б |
| M3 - Formatting Strings - Characters 2.sql |
808б |
| M3 - Formatting Strings - REPLACE.sql |
496б |
| M3 - Formatting Strings - Simplifying with temps and UDFs.sql |
1.49Кб |
| M3 - Formatting Strings - SUBSTRINGS.sql |
1022б |
| M3 - Formatting Strings - TRIM.sql |
497б |
| M3 - Formatting Strings - UPPER and LOWER.sql |
476б |
| M3 - Numeric Order of Operations.sql |
390б |
| M3 - Order Details Case When Example for due date.sql |
1.77Кб |
| M3 - REGEX.sql |
631б |
| M3 - User Defined Functions OrderAmountPurchased.sql |
1.62Кб |
| M3 - User Defined Functions Proper.sql |
1.29Кб |
| M3 - User Defined Functions ProperWithCharacters.sql |
3.61Кб |
| M3 - Working with Numbers.sql |
1.00Кб |
| M4 - Analyzing with FULL OUTER Join.sql |
714б |
| M4 - Formatted FULL OUTER Join.sql |
1.32Кб |
| M4 - Formatted Inner Joins.sql |
536б |
| M4 - FULL OUTER Join.sql |
556б |
| M4 - Inner Joins.sql |
972б |
| M4 - Inner Joins Formatted Report.sql |
542б |
| M4 - JOIN.sql |
673б |
| M4 - Joining from multiple databases.sql |
184б |
| M4 - LEFT JOIN.sql |
538б |
| M4 - RIGHT JOIN.sql |
1.38Кб |
| M4 - RIGHT Joins.sql |
540б |
| M4 - Self Joins.sql |
338б |
| M4 - Self Joins 3.sql |
180б |
| M4 - Self Joins example 2.sql |
215б |
| M5 - Comparison operators and NULL.sql |
1.01Кб |
| M5 - Controlling Flow IsNumeric and GOTO.sql |
491б |
| M5 - Controlling Flow with IF.sql |
2.51Кб |
| M5 - Controlling Flow with WHILE-BREAK-CONTINUE-GOTO.sql |
780б |
| M5 - Filtering for NULL 1.sql |
157б |
| M5 - Filtering for NULL 2.sql |
495б |
| M5 - Filtering Query Results.sql |
665б |
| M5 - Filtering the table examples.sql |
944б |
| M5 - Filtering using IN and NOT IN.sql |
389б |
| M5 - Filtering with Logical Operators.sql |
2.32Кб |
| M5 - Filtering with Strings.sql |
1.81Кб |
| M5 - LIKE and NOT LIKE filtering.sql |
607б |
| M5 - Logical and Logical Operators.sql |
4.42Кб |
| M5 - Logical Operators.sql |
777б |
| M5 - Using quantifiers to filter.sql |
808б |
| M6 - FETCH NEXT.sql |
1023б |
| M6 - TOP Functions.sql |
2.15Кб |
| M7-Average Sold Products with variables.rpt |
6.58Кб |
| M7-Company Sales with Min Max and Avg.rpt |
7.88Кб |
| M7-Products and the number of times ordered.rpt |
3.65Кб |
| M7 - Products COUNT query.sql |
844б |
| M7 - Products COUNT query 2.sql |
385б |
| M7-Products number of times ordered and number of products sold.rpt |
4.81Кб |
| M7 - Using AVG in T-SQL 1.sql |
557б |
| M7 - Using AVG in T-SQL 2.sql |
881б |
| M7 - Using COUNT in T-SQL.sql |
1.27Кб |
| M7 - Using MIN MAX in T-SQL.sql |
475б |
| M7 - Using SUM in T-SQL.sql |
599б |
| M8 - Except.sql |
768б |
| M8 - Intercect.sql |
604б |
| M8 - Union.sql |
546б |
| M8 - Union All.sql |
1.00Кб |
| M9 - Common Table Expressions.sql |
2.84Кб |
| M9 - CTE Report.rpt |
1.91Кб |
| M9 - Cursors with TMP Table for updating.sql |
857б |
| M9 - Temprorary Tables.sql |
1.47Кб |
| M9 - Temprorary Tables 2.sql |
1.83Кб |
| M9 - Using Cursors in T-SQL.sql |
546б |
| maintaining-data-integrity-with-transactions-slides.pdf |
1.40Мб |
| modifying-data-using-t-sql-statements-slides.pdf |
1.09Мб |
| Module 2 - What is TSQL - Code and Links.sql |
1.24Кб |
| Module 3 -Our First SELECT - Code and Links.sql |
1.53Кб |
| Module 4 - FROM Multi Sources - Code and Links.sql |
748б |
| Module 4 - FROM Single Source - Code and Links.sql |
976б |
| Module 4 - TSQL Demo DB.sql |
2.83Кб |
| Module 5 - Filtering with WHERE - Code and Links.sql |
1.48Кб |
| Module 6 - GROUP BY - Code and Links.sql |
905б |
| Module 6 - HAVING - Code and Links.sql |
734б |
| Module 7 - All-at-once - Code and Links.sql |
759б |
| Module 7 - DISTINCT - Code and Links.sql |
902б |
| Module 8 - ORDER BY and Paging - Code and Links.sql |
1.22Кб |
| Module 9 - Wrapping Up - Links.sql |
387б |
| NorthwindObjectsAndData.sql |
1.36Мб |
| optimizing-stored-procedure-performance-slides.pdf |
262.88Кб |
| ordering-and-paging-slides.pdf |
673.18Кб |
| our-first-select-slides.pdf |
661.41Кб |
| playlist.m3u |
3.96Кб |
| playlist.m3u |
3.35Кб |
| playlist.m3u |
2.90Кб |
| playlist.m3u |
2.20Кб |
| playlist.m3u |
1.94Кб |
| playlist.m3u |
4.54Кб |
| playlist.m3u |
3.29Кб |
| posts.xml |
3.23Кб |
| posts.xml |
3.23Кб |
| query-data-with-inline-queries-and-scalar-functions-slides.pdf |
1.54Мб |
| query-data-with-static-value-functions-slides.pdf |
285.37Кб |
| querying-data-from-multiple-tables-using-joins-slides.pdf |
1.21Мб |
| querying-json-with-t-sql-slides.pdf |
1.87Мб |
| querying-xml-data-with-t-sql-slides.pdf |
1.59Мб |
| ranking-data-with-rank-and-partition-slides.pdf |
147.74Кб |
| removing-data-using-t-sql-statements-slides.pdf |
789.98Кб |
| SELECT.txt |
2.96Кб |
| setting-up-queries-in-stored-procedures-slides.pdf |
222.20Кб |
| setting-up-the-sql-server-environment-slides.pdf |
1.69Мб |
| shaping-data-in-a-query-slides.pdf |
1.49Мб |
| simplifying-with-intermediate-tables-and-common-table-expressions-slides pdf |
775.88Кб |
| SQL Server 2019 Editions Datasheet.pdf |
147.49Кб |
| SQL Server Data Type Conversion Chart.png |
43.74Кб |
| substituting-a-table-reference-with-a-rowset-function-slides.pptx |
535.43Кб |
| summary-slides.pdf |
981.21Кб |
| suppliers and products.rpt |
4.93Кб |
| the-from-clause-slides.pdf |
525.73Кб |
| top-posts.json |
305б |
| top-posts.json |
305б |
| TRANSACTION.txt |
3.20Кб |
| TSFP_2021.bak |
551.16Мб |
| tsql-dml.bak |
32.80Мб |
| tsql-dml-script.sql |
226.61Мб |
| tsql-xjt.bak |
293.12Мб |
| tsql-xml-json-backup.sql |
371.20Мб |
| UPDATE.txt |
2.88Кб |
| using-advanced-t-sql-techniques-slides.pdf |
1.10Мб |
| using-t-sql-set-operators-slides.pdf |
1.11Мб |
| utilizing-temporal-tables-slides.pdf |
1.03Мб |
| what-is-t-sql-slides.pdf |
987.08Кб |
| WHERE.txt |
1.20Кб |
| WideWorldImporters-Standard.bak |
563.22Мб |
| working-with-the-t-sql-data-manipulation-language-slides.pdf |
2.27Мб |
| wrapping-up-slides.pdf |
1.46Мб |