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