|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 1.10 Lab Creating Queries Using Set Operators.en.ttml |
6.14Кб |
| 1.10 Lab Creating Queries Using Set Operators.mp4 |
120.63Мб |
| 1.11 Lab Examining Precedence Among Set Operators.en.ttml |
4.83Кб |
| 1.11 Lab Examining Precedence Among Set Operators.mp4 |
110.79Мб |
| 1.12 Distinguishing Between UNION and UNION ALL Behavior.en.ttml |
3.12Кб |
| 1.12 Distinguishing Between UNION and UNION ALL Behavior.mp4 |
70.26Мб |
| 1.13 Lab Creating Queries with UNION and UNION ALL.en.ttml |
2.61Кб |
| 1.13 Lab Creating Queries with UNION and UNION ALL.mp4 |
52.98Мб |
| 1.14 Identifying the Query That Would Return Expected Results Based on Provided Table St.en.ttml |
5.51Кб |
| 1.14 Identifying the Query That Would Return Expected Results Based on Provided Table Structure and or Data.mp4 |
92.34Мб |
| 1.1 Transact-SQL Overview.en.ttml |
9.10Кб |
| 1.1 Transact-SQL Overview.mp4 |
176.96Мб |
| 1.2 Identifying Proper SELECT Query StructurePredicates and Operators.en.ttml |
21.37Кб |
| 1.2 Identifying Proper SELECT Query Structure—Predicates and Operators.mp4 |
394.36Мб |
| 1.3 Identifying Proper SELECT Query StructureElements and Execution.en.ttml |
14.46Кб |
| 1.3 Identifying Proper SELECT Query Structure—Elements and Execution.mp4 |
288.42Мб |
| 1.4 Lab Writing Queries That Filter Data Using Predicates.en.ttml |
10.72Кб |
| 1.4 Lab Writing Queries That Filter Data Using Predicates.mp4 |
206.91Мб |
| 1.5 Writing Specific Queries to Satisfy Business Requirements.en.ttml |
16.66Кб |
| 1.5 Writing Specific Queries to Satisfy Business Requirements.mp4 |
305.54Мб |
| 1.6 Lab Reviewing Non-Efficient and Efficient Sample Queries.en.ttml |
4.23Кб |
| 1.6 Lab Reviewing Non-Efficient and Efficient Sample Queries.mp4 |
77.98Мб |
| 1.7 Lab Controlling the Order of the Query Result.en.ttml |
7.47Кб |
| 1.7 Lab Controlling the Order of the Query Result.mp4 |
169.32Мб |
| 1.8 Lab Understanding All-at-once Operations.en.ttml |
11.99Кб |
| 1.8 Lab Understanding All-at-once Operations.mp4 |
226.31Мб |
| 1.9 Constructing Results from Multiple Queries Using Set Operators.en.ttml |
9.69Кб |
| 1.9 Constructing Results from Multiple Queries Using Set Operators.mp4 |
167.11Мб |
| 10.1 Determining Results of Data Definition Language (DDL) Statements Based on Transacti.en.ttml |
19.76Кб |
| 10.1 Determining Results of Data Definition Language (DDL) Statements Based on Transaction Control Statements.mp4 |
439.58Мб |
| 10.2 Implementing TryCatch Error Handling with Transact-SQL.en.ttml |
17.23Кб |
| 10.2 Implementing Try…Catch Error Handling with Transact-SQL.mp4 |
299.03Мб |
| 10.3 Lab Using TryCatch to Redirect Errors.en.ttml |
12.05Кб |
| 10.3 Lab Using Try…Catch to Redirect Errors.mp4 |
269.50Мб |
| 10.4 Generating Error Messages with THROW and RAISERROR.en.ttml |
11.73Кб |
| 10.4 Generating Error Messages with THROW and RAISERROR.mp4 |
238.52Мб |
| 10.5 Lab Using THROW and RAISERROR.en.ttml |
10.78Кб |
| 10.5 Lab Using THROW and RAISERROR.mp4 |
205.04Мб |
| 10.6 Lab Using Error Functions to Retrieve Detailed Error Information.en.ttml |
2.89Кб |
| 10.6 Lab Using Error Functions to Retrieve Detailed Error Information.mp4 |
58.05Мб |
| 10.7 Implementing Transaction Control in Conjunction with Error Handling in Stored Proce.en.ttml |
6.80Кб |
| 10.7 Implementing Transaction Control in Conjunction with Error Handling in Stored Procedures.mp4 |
142.27Мб |
| 10.8 Lab Using Transaction Control in Conjunction with Error Handling in Stored Procedur.en.ttml |
27.48Кб |
| 10.8 Lab Using Transaction Control in Conjunction with Error Handling in Stored Procedures.mp4 |
597.11Мб |
| 11.10 Identifying Proper Usage of ISNULL and COALESCE Functions.en.ttml |
9.49Кб |
| 11.10 Identifying Proper Usage of ISNULL and COALESCE Functions.mp4 |
226.05Мб |
| 11.11 Lab Using ISNULL and COALESCE.en.ttml |
9.32Кб |
| 11.11 Lab Using ISNULL and COALESCE.mp4 |
224.87Мб |
| 11.1 Evaluating Results of Data Type Conversions.en.ttml |
18.10Кб |
| 11.1 Evaluating Results of Data Type Conversions.mp4 |
427.01Мб |
| 11.2 Lab Converting Data Types.en.ttml |
8.90Кб |
| 11.2 Lab Converting Data Types.mp4 |
200.19Мб |
| 11.3 Determining Proper Data Types for Given Data Elements or Table Columns General Guid.en.ttml |
18.16Кб |
| 11.3 Determining Proper Data Types for Given Data Elements or Table Columns General Guidelines.mp4 |
311.92Мб |
| 11.4 Determining Proper Data Types for Given Data Elements or Table Columns Numeric, Cha.en.ttml |
11.18Кб |
| 11.4 Determining Proper Data Types for Given Data Elements or Table Columns Numeric, Character, Unicode and Other Data Types.mp4 |
235.16Мб |
| 11.5 Lab Using Proper Data Types.en.ttml |
17.98Кб |
| 11.5 Lab Using Proper Data Types.mp4 |
501.93Мб |
| 11.6 Identifying Locations of Implicit Data Type Conversions in Queries.en.ttml |
8.11Кб |
| 11.6 Identifying Locations of Implicit Data Type Conversions in Queries.mp4 |
183.22Мб |
| 11.7 Lab Identifying Implicit Data Type Conversions.en.ttml |
7.49Кб |
| 11.7 Lab Identifying Implicit Data Type Conversions.mp4 |
167.95Мб |
| 11.8 Determining the Correct Results of Joins and Functions in Presence of NULL Values.en.ttml |
4.90Кб |
| 11.8 Determining the Correct Results of Joins and Functions in Presence of NULL Values.mp4 |
95.15Мб |
| 11.9 Lab Using Joins and Functions Containing NULL Values.en.ttml |
11.49Кб |
| 11.9 Lab Using Joins and Functions Containing NULL Values.mp4 |
312.21Мб |
| 2.1 Writing Queries With Join Statements Based on Provided Tables, Data, and Requirement.en.ttml |
8.07Кб |
| 2.1 Writing Queries With Join Statements Based on Provided Tables, Data, and Requirements.mp4 |
172.79Мб |
| 2.2 Determining Proper Usage of INNER JOIN, LEFT RIGHT FULL OUTER JOIN, and CROSS JOIN.en.ttml |
13.45Кб |
| 2.2 Determining Proper Usage of INNER JOIN, LEFT RIGHT FULL OUTER JOIN, and CROSS JOIN.mp4 |
296.54Мб |
| 2.3 Lab Implementing Join Statements on Provided Tables.en.ttml |
10.64Кб |
| 2.3 Lab Implementing Join Statements on Provided Tables.mp4 |
245.20Мб |
| 2.4 Lab Implementing CROSS JOIN on Provided Tables.en.ttml |
9.59Кб |
| 2.4 Lab Implementing CROSS JOIN on Provided Tables.mp4 |
213.63Мб |
| 2.5 Constructing Multiple JOIN Operators Using AND and OR.en.ttml |
4.36Кб |
| 2.5 Constructing Multiple JOIN Operators Using AND and OR.mp4 |
89.69Мб |
| 2.6 Lab Using Queries with Multiple JOIN Operators.en.ttml |
9.53Кб |
| 2.6 Lab Using Queries with Multiple JOIN Operators.mp4 |
179.01Мб |
| 2.7 Determining the Correct Results When Presented with Multi-table SELECT Statements an.en.ttml |
10.02Кб |
| 2.7 Determining the Correct Results When Presented with Multi-table SELECT Statements and Source Data.mp4 |
226.83Мб |
| 2.8 Writing Queries with NULLs on Joins.en.ttml |
7.29Кб |
| 2.8 Writing Queries with NULLs on Joins.mp4 |
127.42Мб |
| 2.9 Lab Using Joins with NULLS.en.ttml |
10.65Кб |
| 2.9 Lab Using Joins with NULLS.mp4 |
205.34Мб |
| 3.10 Using Logical and System Functions.en.ttml |
9.69Кб |
| 3.10 Using Logical and System Functions.mp4 |
207.47Мб |
| 3.11 Lab Using Built-In Functions in Queries.en.ttml |
11.75Кб |
| 3.11 Lab Using Built-In Functions in Queries.mp4 |
275.18Мб |
| 3.1 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Compone.en.ttml |
15.84Кб |
| 3.1 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Components.mp4 |
255.07Мб |
| 3.2 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Creatio.en.ttml |
11.11Кб |
| 3.2 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Creation and Implementation.mp4 |
197.61Мб |
| 3.3 Lab Implementing Queries Using Scalar-Valued Functions.en.ttml |
7.84Кб |
| 3.3 Lab Implementing Queries Using Scalar-Valued Functions.mp4 |
152.16Мб |
| 3.4 Lab Implementing Queries Using Table-Valued Functions.en.ttml |
5.39Кб |
| 3.4 Lab Implementing Queries Using Table-Valued Functions.mp4 |
92.17Мб |
| 3.5 Identifying the Impact of Function Usage to Query Performance and WHERE Clause Sarga.en.ttml |
5.35Кб |
| 3.5 Identifying the Impact of Function Usage to Query Performance and WHERE Clause Sargability.mp4 |
87.64Мб |
| 3.6 Lab Analyzing the Query Performance Impact of Function Usage and WHERE Clause.en.ttml |
7.10Кб |
| 3.6 Lab Analyzing the Query Performance Impact of Function Usage and WHERE Clause.mp4 |
154.41Мб |
| 3.7 Identifying the Differences Between Deterministic and Non-Deterministic Functions.en.ttml |
3.70Кб |
| 3.7 Identifying the Differences Between Deterministic and Non-Deterministic Functions.mp4 |
59.47Мб |
| 3.8 Using Built-In Aggregate Functions.en.ttml |
4.09Кб |
| 3.8 Using Built-In Aggregate Functions.mp4 |
82.76Мб |
| 3.9 Using Arithmetic and Date-Related Functions.en.ttml |
14.62Кб |
| 3.9 Using Arithmetic and Date-Related Functions.mp4 |
346.79Мб |
| 4.1 Writing INSERT Statements.en.ttml |
10.96Кб |
| 4.1 Writing INSERT Statements.mp4 |
169.86Мб |
| 4.2 Writing UPDATE Statements.en.ttml |
8.28Кб |
| 4.2 Writing UPDATE Statements.mp4 |
142.61Мб |
| 4.3 Writing DELETE Statements and Best Practices for Data Modification.en.ttml |
7.77Кб |
| 4.3 Writing DELETE Statements and Best Practices for Data Modification.mp4 |
148.80Мб |
| 4.4 Determining Which Statements Can Be Used to Load Data to a Table Based on Its Struct.en.ttml |
9.57Кб |
| 4.4 Determining Which Statements Can Be Used to Load Data to a Table Based on Its Structure and Constraints.mp4 |
170.74Мб |
| 4.5 Lab Using INSERT, UPDATE, and DELETE to Modify the Contents of a Table.en.ttml |
28.73Кб |
| 4.5 Lab Using INSERT, UPDATE, and DELETE to Modify the Contents of a Table.mp4 |
686.92Мб |
| 4.6 Constructing Data Manipulation Language (DML) Statements Using the OUTPUT Statement.en.ttml |
10.40Кб |
| 4.6 Constructing Data Manipulation Language (DML) Statements Using the OUTPUT Statement.mp4 |
184.83Мб |
| 4.7 Lab Creating DML Statements Using the OUTPUT Statement.en.ttml |
8.15Кб |
| 4.7 Lab Creating DML Statements Using the OUTPUT Statement.mp4 |
193.54Мб |
| 4.8 Determining the Results of Data Definition Language (DDL) on Supplied Tables and Dat.en.ttml |
6.66Кб |
| 4.8 Determining the Results of Data Definition Language (DDL) on Supplied Tables and Data.mp4 |
88.07Мб |
| 4.9 Lab Using DDL Statements.en.ttml |
6.95Кб |
| 4.9 Lab Using DDL Statements.mp4 |
157.21Мб |
| 5.1 Determining the Results of Queries Using Subqueries and Table Joins.en.ttml |
9.91Кб |
| 5.1 Determining the Results of Queries Using Subqueries and Table Joins.mp4 |
199.37Мб |
| 5.2 Evaluating Performance Differences Between Table Joins and Correlated Subqueries Bas.en.ttml |
12.11Кб |
| 5.2 Evaluating Performance Differences Between Table Joins and Correlated Subqueries Based on Provided Data and Query Plans.mp4 |
232.61Мб |
| 5.3 Lab Comparing Subqueries and Table Joins.en.ttml |
11.53Кб |
| 5.3 Lab Comparing Subqueries and Table Joins.mp4 |
288.14Мб |
| 5.4 Distinguishing Between the Use of CROSS APPLY and OUTER APPLY.en.ttml |
4.83Кб |
| 5.4 Distinguishing Between the Use of CROSS APPLY and OUTER APPLY.mp4 |
106.56Мб |
| 5.5 Writing APPLY Statements That Return a Given Data Set Based on Supplied Data.en.ttml |
6.25Кб |
| 5.5 Writing APPLY Statements That Return a Given Data Set Based on Supplied Data.mp4 |
150.97Мб |
| 5.6 Lab Using the APPLY Operator.en.ttml |
6.18Кб |
| 5.6 Lab Using the APPLY Operator.mp4 |
140.88Мб |
| 6.1 Identifying Basic Components of Table Expressions.en.ttml |
15.42Кб |
| 6.1 Identifying Basic Components of Table Expressions.mp4 |
281.84Мб |
| 6.2 Defining Usage Differences Between Table Expressions and Temporary Tables.en.ttml |
4.79Кб |
| 6.2 Defining Usage Differences Between Table Expressions and Temporary Tables.mp4 |
92.38Мб |
| 6.3 Lab Using Table Expressions.en.ttml |
13.87Кб |
| 6.3 Lab Using Table Expressions.mp4 |
294.68Мб |
| 6.4 Constructing Recursive Table Expressions to Meet Business Requirements.en.ttml |
6.87Кб |
| 6.4 Constructing Recursive Table Expressions to Meet Business Requirements.mp4 |
161.80Мб |
| 6.5 Lab Using Recursive Table Expressions.en.ttml |
7.90Кб |
| 6.5 Lab Using Recursive Table Expressions.mp4 |
150.89Мб |
| 7.1 Using Windowing Functions to Group and Rank the Results of a Query.en.ttml |
23.86Кб |
| 7.1 Using Windowing Functions to Group and Rank the Results of a Query.mp4 |
476.46Мб |
| 7.2 Distinguishing Between Using Windowing Functions and GROUP BY.en.ttml |
3.79Кб |
| 7.2 Distinguishing Between Using Windowing Functions and GROUP BY.mp4 |
72.09Мб |
| 7.3 Lab Using Windowing Functions and GROUP BY.en.ttml |
14.02Кб |
| 7.3 Lab Using Windowing Functions and GROUP BY.mp4 |
325.34Мб |
| 7.4 Constructing Complex GROUP BY Clauses Using GROUPING SETS and CUBE.en.ttml |
15.58Кб |
| 7.4 Constructing Complex GROUP BY Clauses Using GROUPING SETS and CUBE.mp4 |
308.46Мб |
| 7.5 Lab Using GROUPING SETS and CUBE.en.ttml |
14.59Кб |
| 7.5 Lab Using GROUPING SETS and CUBE.mp4 |
337.98Мб |
| 7.6 Constructing PIVOT and UNPIVOT Statements to Return Desired Results Based on Supplie.en.ttml |
13.03Кб |
| 7.6 Constructing PIVOT and UNPIVOT Statements to Return Desired Results Based on Supplied Data.mp4 |
223.31Мб |
| 7.7 Lab Using PIVOT and UNPIVOT.en.ttml |
11.14Кб |
| 7.7 Lab Using PIVOT and UNPIVOT.mp4 |
286.25Мб |
| 7.8 Determining the Impact of NULL Values in PIVOT and UNPIVOT Queries.en.ttml |
3.83Кб |
| 7.8 Determining the Impact of NULL Values in PIVOT and UNPIVOT Queries.mp4 |
85.47Мб |
| 7.9 Lab Using PIVOT and UNPIVOT in Queries with NULL Values.en.ttml |
6.48Кб |
| 7.9 Lab Using PIVOT and UNPIVOT in Queries with NULL Values.mp4 |
179.98Мб |
| 8.1 Querying Historic Data Using Temporal Tables.en.ttml |
7.36Кб |
| 8.1 Querying Historic Data Using Temporal Tables.mp4 |
163.22Мб |
| 8.2 Lab Using Temporal Tables.en.ttml |
6.31Кб |
| 8.2 Lab Using Temporal Tables.mp4 |
165.10Мб |
| 8.3 Querying and Outputting JSON Data.en.ttml |
17.49Кб |
| 8.3 Querying and Outputting JSON Data.mp4 |
385.68Мб |
| 8.4 Lab Using JSON Data.en.ttml |
12.70Кб |
| 8.4 Lab Using JSON Data.mp4 |
291.47Мб |
| 8.5 Querying and Outputting XML Data.en.ttml |
18.27Кб |
| 8.5 Querying and Outputting XML Data.mp4 |
430.27Мб |
| 8.6 Lab Using XML Data.en.ttml |
25.88Кб |
| 8.6 Lab Using XML Data.mp4 |
587.16Мб |
| 9.10 Creating Indexed Views.en.ttml |
8.19Кб |
| 9.10 Creating Indexed Views.mp4 |
160.63Мб |
| 9.11 Lab Creating Views and Using View Options.en.ttml |
11.11Кб |
| 9.11 Lab Creating Views and Using View Options.mp4 |
241.46Мб |
| 9.12 Lab Creating Indexed Views.en.ttml |
6.90Кб |
| 9.12 Lab Creating Indexed Views.mp4 |
167.13Мб |
| 9.1 Creating Stored Procedures.en.ttml |
12.34Кб |
| 9.1 Creating Stored Procedures.mp4 |
213.89Мб |
| 9.2 Creating Table-Valued and Scalar-Valued User-Defined Functions.en.ttml |
15.41Кб |
| 9.2 Creating Table-Valued and Scalar-Valued User-Defined Functions.mp4 |
221.85Мб |
| 9.3 Creating and Using Views.en.ttml |
12.88Кб |
| 9.3 Creating and Using Views.mp4 |
225.95Мб |
| 9.4 Lab Writing Stored Procedures.en.ttml |
10.38Кб |
| 9.4 Lab Writing Stored Procedures.mp4 |
183.08Мб |
| 9.5 Implementing Input and Output Parameters in Stored Procedures.en.ttml |
11.63Кб |
| 9.5 Implementing Input and Output Parameters in Stored Procedures.mp4 |
224.84Мб |
| 9.6 Lab Creating and Executing Stored Procedures with Input and Output Parameters.en.ttml |
6.89Кб |
| 9.6 Lab Creating and Executing Stored Procedures with Input and Output Parameters.mp4 |
142.62Мб |
| 9.7 Identifying Whether to Use Scalar-Valued or Table-Valued User-Defined Functions.en.ttml |
7.46Кб |
| 9.7 Identifying Whether to Use Scalar-Valued or Table-Valued User-Defined Functions.mp4 |
161.72Мб |
| 9.8 Lab Implementing Scalar-Valued and Table-Valued UDFs.en.ttml |
15.03Кб |
| 9.8 Lab Implementing Scalar-Valued and Table-Valued UDFs.mp4 |
274.44Мб |
| 9.9 Distinguishing Between Deterministic and Non-Deterministic Functions.en.ttml |
3.53Кб |
| 9.9 Distinguishing Between Deterministic and Non-Deterministic Functions.mp4 |
77.98Мб |
| Learning objectives.en.ttml |
1.60Кб |
| Learning objectives.en.ttml |
1.33Кб |
| Learning objectives.en.ttml |
1.71Кб |
| Learning objectives.en.ttml |
1.22Кб |
| Learning objectives.en.ttml |
1.55Кб |
| Learning objectives.en.ttml |
1.37Кб |
| Learning objectives.en.ttml |
1.50Кб |
| Learning objectives.en.ttml |
1.00Кб |
| Learning objectives.en.ttml |
1.57Кб |
| Learning objectives.en.ttml |
1.50Кб |
| Learning objectives.en.ttml |
1.44Кб |
| Learning objectives.mp4 |
28.64Мб |
| Learning objectives.mp4 |
23.03Мб |
| Learning objectives.mp4 |
27.22Мб |
| Learning objectives.mp4 |
21.49Мб |
| Learning objectives.mp4 |
22.34Мб |
| Learning objectives.mp4 |
22.16Мб |
| Learning objectives.mp4 |
27.42Мб |
| Learning objectives.mp4 |
16.08Мб |
| Learning objectives.mp4 |
27.50Мб |
| Learning objectives.mp4 |
25.95Мб |
| Learning objectives.mp4 |
23.36Мб |
| Lesson 10 Summary.en.ttml |
1.38Кб |
| Lesson 10 Summary.mp4 |
28.70Мб |
| Lesson 11 Summary.en.ttml |
1.58Кб |
| Lesson 11 Summary.mp4 |
29.76Мб |
| Lesson 1 Summary.en.ttml |
1.51Кб |
| Lesson 1 Summary.mp4 |
28.54Мб |
| Lesson 2 Summary.en.ttml |
1.89Кб |
| Lesson 2 Summary.mp4 |
39.29Мб |
| Lesson 3 Summary.en.ttml |
1.47Кб |
| Lesson 3 Summary.mp4 |
21.31Мб |
| Lesson 4 Summary.en.ttml |
1.51Кб |
| Lesson 4 Summary.mp4 |
19.54Мб |
| Lesson 5 Summary.en.ttml |
1.07Кб |
| Lesson 5 Summary.mp4 |
17.10Мб |
| Lesson 6 Summary.en.ttml |
1.24Кб |
| Lesson 6 Summary.mp4 |
14.88Мб |
| Lesson 7 Summary.en.ttml |
1.51Кб |
| Lesson 7 Summary.mp4 |
23.12Мб |
| Lesson 8 Summary.en.ttml |
1.77Кб |
| Lesson 8 Summary.mp4 |
34.03Мб |
| Lesson 9 Summary.en.ttml |
1.31Кб |
| Lesson 9 Summary.mp4 |
24.39Мб |
| Module Introduction.en.ttml |
1.54Кб |
| Module Introduction.en.ttml |
1.30Кб |
| Module Introduction.en.ttml |
1.13Кб |
| Module Introduction.mp4 |
28.63Мб |
| Module Introduction.mp4 |
21.12Мб |
| Module Introduction.mp4 |
19.92Мб |
| SQL Server 70-761 Introduction.en.ttml |
7.63Кб |
| SQL Server 70-761 Introduction.mp4 |
137.47Мб |
| SQL Server 70-761 Summary.en.ttml |
5.48Кб |
| SQL Server 70-761 Summary.mp4 |
102.21Мб |
| SQLServerLL_Code.zip |
59.31Кб |