FileMood

Download SQL Server 70-761 Querying Data with Transact-SQL

SQL Server 70 761 Querying Data with Transact SQL

Name

SQL Server 70-761 Querying Data with Transact-SQL

 DOWNLOAD Copy Link

Total Size

23.9 GB

Total Files

255

Hash

5A46565045F10480F9D7A2CBBFD08346608A6512

/Introduction/

SQL Server 70-761 Introduction.en.ttml

7.8 KB

SQL Server 70-761 Introduction.mp4

144.1 MB

/.../Lesson 1 Create Transact-SQL SELECT Queries/

1.1 Transact-SQL Overview.en.ttml

9.3 KB

1.1 Transact-SQL Overview.mp4

185.6 MB

1.10 Lab Creating Queries Using Set Operators.en.ttml

6.3 KB

1.10 Lab Creating Queries Using Set Operators.mp4

126.5 MB

1.11 Lab Examining Precedence Among Set Operators.en.ttml

4.9 KB

1.11 Lab Examining Precedence Among Set Operators.mp4

116.2 MB

1.12 Distinguishing Between UNION and UNION ALL Behavior.en.ttml

3.2 KB

1.12 Distinguishing Between UNION and UNION ALL Behavior.mp4

73.7 MB

1.13 Lab Creating Queries with UNION and UNION ALL.en.ttml

2.7 KB

1.13 Lab Creating Queries with UNION and UNION ALL.mp4

55.6 MB

1.14 Identifying the Query That Would Return Expected Results Based on Provided Table St.en.ttml

5.6 KB

1.14 Identifying the Query That Would Return Expected Results Based on Provided Table Structure and or Data.mp4

96.8 MB

1.2 Identifying Proper SELECT Query StructurePredicates and Operators.en.ttml

21.9 KB

1.2 Identifying Proper SELECT Query Structure—Predicates and Operators.mp4

413.5 MB

1.3 Identifying Proper SELECT Query StructureElements and Execution.en.ttml

14.8 KB

1.3 Identifying Proper SELECT Query Structure—Elements and Execution.mp4

302.4 MB

1.4 Lab Writing Queries That Filter Data Using Predicates.en.ttml

11.0 KB

1.4 Lab Writing Queries That Filter Data Using Predicates.mp4

217.0 MB

1.5 Writing Specific Queries to Satisfy Business Requirements.en.ttml

17.1 KB

1.5 Writing Specific Queries to Satisfy Business Requirements.mp4

320.4 MB

1.6 Lab Reviewing Non-Efficient and Efficient Sample Queries.en.ttml

4.3 KB

1.6 Lab Reviewing Non-Efficient and Efficient Sample Queries.mp4

81.8 MB

1.7 Lab Controlling the Order of the Query Result.en.ttml

7.7 KB

1.7 Lab Controlling the Order of the Query Result.mp4

177.5 MB

1.8 Lab Understanding All-at-once Operations.en.ttml

12.3 KB

1.8 Lab Understanding All-at-once Operations.mp4

237.3 MB

1.9 Constructing Results from Multiple Queries Using Set Operators.en.ttml

9.9 KB

1.9 Constructing Results from Multiple Queries Using Set Operators.mp4

175.2 MB

Learning objectives.en.ttml

1.6 KB

Learning objectives.mp4

30.0 MB

Lesson 1 Summary.en.ttml

1.5 KB

Lesson 1 Summary.mp4

29.9 MB

/.../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.3 KB

2.1 Writing Queries With Join Statements Based on Provided Tables, Data, and Requirements.mp4

181.2 MB

2.2 Determining Proper Usage of INNER JOIN, LEFT RIGHT FULL OUTER JOIN, and CROSS JOIN.en.ttml

13.8 KB

2.2 Determining Proper Usage of INNER JOIN, LEFT RIGHT FULL OUTER JOIN, and CROSS JOIN.mp4

310.9 MB

2.3 Lab Implementing Join Statements on Provided Tables.en.ttml

10.9 KB

2.3 Lab Implementing Join Statements on Provided Tables.mp4

257.1 MB

2.4 Lab Implementing CROSS JOIN on Provided Tables.en.ttml

9.8 KB

2.4 Lab Implementing CROSS JOIN on Provided Tables.mp4

224.0 MB

2.5 Constructing Multiple JOIN Operators Using AND and OR.en.ttml

4.5 KB

2.5 Constructing Multiple JOIN Operators Using AND and OR.mp4

94.0 MB

2.6 Lab Using Queries with Multiple JOIN Operators.en.ttml

9.8 KB

2.6 Lab Using Queries with Multiple JOIN Operators.mp4

187.7 MB

2.7 Determining the Correct Results When Presented with Multi-table SELECT Statements an.en.ttml

10.3 KB

2.7 Determining the Correct Results When Presented with Multi-table SELECT Statements and Source Data.mp4

237.8 MB

2.8 Writing Queries with NULLs on Joins.en.ttml

7.5 KB

2.8 Writing Queries with NULLs on Joins.mp4

133.6 MB

2.9 Lab Using Joins with NULLS.en.ttml

10.9 KB

2.9 Lab Using Joins with NULLS.mp4

215.3 MB

Learning objectives.en.ttml

1.4 KB

Learning objectives.mp4

24.2 MB

Lesson 2 Summary.en.ttml

1.9 KB

Lesson 2 Summary.mp4

41.2 MB

/.../Lesson 3 Implement Functions and Aggregate Data/

3.1 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Compone.en.ttml

16.2 KB

3.1 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Components.mp4

267.5 MB

3.10 Using Logical and System Functions.en.ttml

9.9 KB

3.10 Using Logical and System Functions.mp4

217.5 MB

3.11 Lab Using Built-In Functions in Queries.en.ttml

12.0 KB

3.11 Lab Using Built-In Functions in Queries.mp4

288.5 MB

3.2 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Creatio.en.ttml

11.4 KB

3.2 Constructing Queries Using Scalar-Valued and Table-Valued Functions Function Creation and Implementation.mp4

207.2 MB

3.3 Lab Implementing Queries Using Scalar-Valued Functions.en.ttml

8.0 KB

3.3 Lab Implementing Queries Using Scalar-Valued Functions.mp4

159.5 MB

3.4 Lab Implementing Queries Using Table-Valued Functions.en.ttml

5.5 KB

3.4 Lab Implementing Queries Using Table-Valued Functions.mp4

96.6 MB

3.5 Identifying the Impact of Function Usage to Query Performance and WHERE Clause Sarga.en.ttml

5.5 KB

3.5 Identifying the Impact of Function Usage to Query Performance and WHERE Clause Sargability.mp4

91.9 MB

3.6 Lab Analyzing the Query Performance Impact of Function Usage and WHERE Clause.en.ttml

7.3 KB

3.6 Lab Analyzing the Query Performance Impact of Function Usage and WHERE Clause.mp4

161.9 MB

3.7 Identifying the Differences Between Deterministic and Non-Deterministic Functions.en.ttml

3.8 KB

3.7 Identifying the Differences Between Deterministic and Non-Deterministic Functions.mp4

62.4 MB

3.8 Using Built-In Aggregate Functions.en.ttml

4.2 KB

3.8 Using Built-In Aggregate Functions.mp4

86.8 MB

3.9 Using Arithmetic and Date-Related Functions.en.ttml

15.0 KB

3.9 Using Arithmetic and Date-Related Functions.mp4

363.6 MB

Learning objectives.en.ttml

1.7 KB

Learning objectives.mp4

28.5 MB

Lesson 3 Summary.en.ttml

1.5 KB

Lesson 3 Summary.mp4

22.3 MB

/.../Lesson 4 Modify Data/

4.1 Writing INSERT Statements.en.ttml

11.2 KB

4.1 Writing INSERT Statements.mp4

178.1 MB

4.2 Writing UPDATE Statements.en.ttml

8.5 KB

4.2 Writing UPDATE Statements.mp4

149.5 MB

4.3 Writing DELETE Statements and Best Practices for Data Modification.en.ttml

8.0 KB

4.3 Writing DELETE Statements and Best Practices for Data Modification.mp4

156.0 MB

4.4 Determining Which Statements Can Be Used to Load Data to a Table Based on Its Struct.en.ttml

9.8 KB

4.4 Determining Which Statements Can Be Used to Load Data to a Table Based on Its Structure and Constraints.mp4

179.0 MB

4.5 Lab Using INSERT, UPDATE, and DELETE to Modify the Contents of a Table.en.ttml

29.4 KB

4.5 Lab Using INSERT, UPDATE, and DELETE to Modify the Contents of a Table.mp4

720.3 MB

4.6 Constructing Data Manipulation Language (DML) Statements Using the OUTPUT Statement.en.ttml

10.6 KB

4.6 Constructing Data Manipulation Language (DML) Statements Using the OUTPUT Statement.mp4

193.8 MB

4.7 Lab Creating DML Statements Using the OUTPUT Statement.en.ttml

8.4 KB

4.7 Lab Creating DML Statements Using the OUTPUT Statement.mp4

202.9 MB

4.8 Determining the Results of Data Definition Language (DDL) on Supplied Tables and Dat.en.ttml

6.8 KB

4.8 Determining the Results of Data Definition Language (DDL) on Supplied Tables and Data.mp4

92.3 MB

4.9 Lab Using DDL Statements.en.ttml

7.1 KB

4.9 Lab Using DDL Statements.mp4

164.8 MB

Learning objectives.en.ttml

1.2 KB

Learning objectives.mp4

22.5 MB

Lesson 4 Summary.en.ttml

1.5 KB

Lesson 4 Summary.mp4

20.5 MB

/Module 1 Manage Data with Transact-SQL/

Module Introduction.en.ttml

1.6 KB

Module Introduction.mp4

30.0 MB

/.../Lesson 5 Query Data by Using Subqueries and Apply/

5.1 Determining the Results of Queries Using Subqueries and Table Joins.en.ttml

10.1 KB

5.1 Determining the Results of Queries Using Subqueries and Table Joins.mp4

209.1 MB

5.2 Evaluating Performance Differences Between Table Joins and Correlated Subqueries Bas.en.ttml

12.4 KB

5.2 Evaluating Performance Differences Between Table Joins and Correlated Subqueries Based on Provided Data and Query Plans.mp4

243.9 MB

5.3 Lab Comparing Subqueries and Table Joins.en.ttml

11.8 KB

5.3 Lab Comparing Subqueries and Table Joins.mp4

302.1 MB

5.4 Distinguishing Between the Use of CROSS APPLY and OUTER APPLY.en.ttml

4.9 KB

5.4 Distinguishing Between the Use of CROSS APPLY and OUTER APPLY.mp4

111.7 MB

5.5 Writing APPLY Statements That Return a Given Data Set Based on Supplied Data.en.ttml

6.4 KB

5.5 Writing APPLY Statements That Return a Given Data Set Based on Supplied Data.mp4

158.3 MB

5.6 Lab Using the APPLY Operator.en.ttml

6.3 KB

5.6 Lab Using the APPLY Operator.mp4

147.7 MB

Learning objectives.en.ttml

1.6 KB

Learning objectives.mp4

23.4 MB

Lesson 5 Summary.en.ttml

1.1 KB

Lesson 5 Summary.mp4

17.9 MB

/.../Lesson 6 Query Data by Using Table Expressions/

6.1 Identifying Basic Components of Table Expressions.en.ttml

15.8 KB

6.1 Identifying Basic Components of Table Expressions.mp4

295.5 MB

6.2 Defining Usage Differences Between Table Expressions and Temporary Tables.en.ttml

4.9 KB

6.2 Defining Usage Differences Between Table Expressions and Temporary Tables.mp4

96.9 MB

6.3 Lab Using Table Expressions.en.ttml

14.2 KB

6.3 Lab Using Table Expressions.mp4

309.0 MB

6.4 Constructing Recursive Table Expressions to Meet Business Requirements.en.ttml

7.0 KB

6.4 Constructing Recursive Table Expressions to Meet Business Requirements.mp4

169.7 MB

6.5 Lab Using Recursive Table Expressions.en.ttml

8.1 KB

6.5 Lab Using Recursive Table Expressions.mp4

158.2 MB

Learning objectives.en.ttml

1.4 KB

Learning objectives.mp4

23.2 MB

Lesson 6 Summary.en.ttml

1.3 KB

Lesson 6 Summary.mp4

15.6 MB

/.../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

24.4 KB

7.1 Using Windowing Functions to Group and Rank the Results of a Query.mp4

499.6 MB

7.2 Distinguishing Between Using Windowing Functions and GROUP BY.en.ttml

3.9 KB

7.2 Distinguishing Between Using Windowing Functions and GROUP BY.mp4

75.6 MB

7.3 Lab Using Windowing Functions and GROUP BY.en.ttml

14.4 KB

7.3 Lab Using Windowing Functions and GROUP BY.mp4

341.1 MB

7.4 Constructing Complex GROUP BY Clauses Using GROUPING SETS and CUBE.en.ttml

16.0 KB

7.4 Constructing Complex GROUP BY Clauses Using GROUPING SETS and CUBE.mp4

323.4 MB

7.5 Lab Using GROUPING SETS and CUBE.en.ttml

14.9 KB

7.5 Lab Using GROUPING SETS and CUBE.mp4

354.4 MB

7.6 Constructing PIVOT and UNPIVOT Statements to Return Desired Results Based on Supplie.en.ttml

13.3 KB

7.6 Constructing PIVOT and UNPIVOT Statements to Return Desired Results Based on Supplied Data.mp4

234.2 MB

7.7 Lab Using PIVOT and UNPIVOT.en.ttml

11.4 KB

7.7 Lab Using PIVOT and UNPIVOT.mp4

300.2 MB

7.8 Determining the Impact of NULL Values in PIVOT and UNPIVOT Queries.en.ttml

3.9 KB

7.8 Determining the Impact of NULL Values in PIVOT and UNPIVOT Queries.mp4

89.6 MB

7.9 Lab Using PIVOT and UNPIVOT in Queries with NULL Values.en.ttml

6.6 KB

7.9 Lab Using PIVOT and UNPIVOT in Queries with NULL Values.mp4

188.7 MB

Learning objectives.en.ttml

1.5 KB

Learning objectives.mp4

28.7 MB

Lesson 7 Summary.en.ttml

1.5 KB

Lesson 7 Summary.mp4

24.2 MB

/.../Lesson 8 Query Temporal Data and Non-Relational Data/

8.1 Querying Historic Data Using Temporal Tables.en.ttml

7.5 KB

8.1 Querying Historic Data Using Temporal Tables.mp4

171.1 MB

8.2 Lab Using Temporal Tables.en.ttml

6.5 KB

8.2 Lab Using Temporal Tables.mp4

173.1 MB

8.3 Querying and Outputting JSON Data.en.ttml

17.9 KB

8.3 Querying and Outputting JSON Data.mp4

404.4 MB

8.4 Lab Using JSON Data.en.ttml

13.0 KB

8.4 Lab Using JSON Data.mp4

305.6 MB

8.5 Querying and Outputting XML Data.en.ttml

18.7 KB

8.5 Querying and Outputting XML Data.mp4

451.2 MB

8.6 Lab Using XML Data.en.ttml

26.5 KB

8.6 Lab Using XML Data.mp4

615.7 MB

Learning objectives.en.ttml

1.0 KB

Learning objectives.mp4

16.9 MB

Lesson 8 Summary.en.ttml

1.8 KB

Lesson 8 Summary.mp4

35.7 MB

/Module 2 Query Data With Advanced Transact-SQL Components/

Module Introduction.en.ttml

1.3 KB

Module Introduction.mp4

22.1 MB

/.../Lesson 10 Implement Error Handling and Transactions/

10.1 Determining Results of Data Definition Language (DDL) Statements Based on Transacti.en.ttml

20.2 KB

10.1 Determining Results of Data Definition Language (DDL) Statements Based on Transaction Control Statements.mp4

460.9 MB

10.2 Implementing TryCatch Error Handling with Transact-SQL.en.ttml

17.6 KB

10.2 Implementing Try…Catch Error Handling with Transact-SQL.mp4

313.6 MB

10.3 Lab Using TryCatch to Redirect Errors.en.ttml

12.3 KB

10.3 Lab Using Try…Catch to Redirect Errors.mp4

282.6 MB

10.4 Generating Error Messages with THROW and RAISERROR.en.ttml

12.0 KB

10.4 Generating Error Messages with THROW and RAISERROR.mp4

250.1 MB

10.5 Lab Using THROW and RAISERROR.en.ttml

11.0 KB

10.5 Lab Using THROW and RAISERROR.mp4

215.0 MB

10.6 Lab Using Error Functions to Retrieve Detailed Error Information.en.ttml

3.0 KB

10.6 Lab Using Error Functions to Retrieve Detailed Error Information.mp4

60.9 MB

10.7 Implementing Transaction Control in Conjunction with Error Handling in Stored Proce.en.ttml

7.0 KB

10.7 Implementing Transaction Control in Conjunction with Error Handling in Stored Procedures.mp4

149.2 MB

10.8 Lab Using Transaction Control in Conjunction with Error Handling in Stored Procedur.en.ttml

28.1 KB

10.8 Lab Using Transaction Control in Conjunction with Error Handling in Stored Procedures.mp4

626.1 MB

Learning objectives.en.ttml

1.6 KB

Learning objectives.mp4

28.8 MB

Lesson 10 Summary.en.ttml

1.4 KB

Lesson 10 Summary.mp4

30.1 MB

/.../Lesson 11 Implement Data Types and NULLS/

11.1 Evaluating Results of Data Type Conversions.en.ttml

18.5 KB

11.1 Evaluating Results of Data Type Conversions.mp4

447.8 MB

11.10 Identifying Proper Usage of ISNULL and COALESCE Functions.en.ttml

9.7 KB

11.10 Identifying Proper Usage of ISNULL and COALESCE Functions.mp4

237.0 MB

11.11 Lab Using ISNULL and COALESCE.en.ttml

9.5 KB

11.11 Lab Using ISNULL and COALESCE.mp4

235.8 MB

11.2 Lab Converting Data Types.en.ttml

9.1 KB

11.2 Lab Converting Data Types.mp4

209.9 MB

11.3 Determining Proper Data Types for Given Data Elements or Table Columns General Guid.en.ttml

18.6 KB

11.3 Determining Proper Data Types for Given Data Elements or Table Columns General Guidelines.mp4

327.1 MB

11.4 Determining Proper Data Types for Given Data Elements or Table Columns Numeric, Cha.en.ttml

11.4 KB

11.4 Determining Proper Data Types for Given Data Elements or Table Columns Numeric, Character, Unicode and Other Data Types.mp4

246.6 MB

11.5 Lab Using Proper Data Types.en.ttml

18.4 KB

11.5 Lab Using Proper Data Types.mp4

526.3 MB

11.6 Identifying Locations of Implicit Data Type Conversions in Queries.en.ttml

8.3 KB

11.6 Identifying Locations of Implicit Data Type Conversions in Queries.mp4

192.1 MB

11.7 Lab Identifying Implicit Data Type Conversions.en.ttml

7.7 KB

11.7 Lab Identifying Implicit Data Type Conversions.mp4

176.1 MB

11.8 Determining the Correct Results of Joins and Functions in Presence of NULL Values.en.ttml

5.0 KB

11.8 Determining the Correct Results of Joins and Functions in Presence of NULL Values.mp4

99.8 MB

11.9 Lab Using Joins and Functions Containing NULL Values.en.ttml

11.8 KB

11.9 Lab Using Joins and Functions Containing NULL Values.mp4

327.4 MB

Learning objectives.en.ttml

1.5 KB

Learning objectives.mp4

27.2 MB

Lesson 11 Summary.en.ttml

1.6 KB

Lesson 11 Summary.mp4

31.2 MB

/.../Lesson 9 Create Database Programmability Objects by Using Transact-SQL/

9.1 Creating Stored Procedures.en.ttml

12.6 KB

9.1 Creating Stored Procedures.mp4

224.3 MB

9.10 Creating Indexed Views.en.ttml

8.4 KB

9.10 Creating Indexed Views.mp4

168.4 MB

9.11 Lab Creating Views and Using View Options.en.ttml

11.4 KB

9.11 Lab Creating Views and Using View Options.mp4

253.2 MB

9.12 Lab Creating Indexed Views.en.ttml

7.1 KB

9.12 Lab Creating Indexed Views.mp4

175.3 MB

9.2 Creating Table-Valued and Scalar-Valued User-Defined Functions.en.ttml

15.8 KB

9.2 Creating Table-Valued and Scalar-Valued User-Defined Functions.mp4

232.6 MB

9.3 Creating and Using Views.en.ttml

13.2 KB

9.3 Creating and Using Views.mp4

236.9 MB

9.4 Lab Writing Stored Procedures.en.ttml

10.6 KB

9.4 Lab Writing Stored Procedures.mp4

192.0 MB

9.5 Implementing Input and Output Parameters in Stored Procedures.en.ttml

11.9 KB

9.5 Implementing Input and Output Parameters in Stored Procedures.mp4

235.8 MB

9.6 Lab Creating and Executing Stored Procedures with Input and Output Parameters.en.ttml

7.1 KB

9.6 Lab Creating and Executing Stored Procedures with Input and Output Parameters.mp4

149.5 MB

9.7 Identifying Whether to Use Scalar-Valued or Table-Valued User-Defined Functions.en.ttml

7.6 KB

9.7 Identifying Whether to Use Scalar-Valued or Table-Valued User-Defined Functions.mp4

169.6 MB

9.8 Lab Implementing Scalar-Valued and Table-Valued UDFs.en.ttml

15.4 KB

9.8 Lab Implementing Scalar-Valued and Table-Valued UDFs.mp4

287.8 MB

9.9 Distinguishing Between Deterministic and Non-Deterministic Functions.en.ttml

3.6 KB

9.9 Distinguishing Between Deterministic and Non-Deterministic Functions.mp4

81.8 MB

Learning objectives.en.ttml

1.5 KB

Learning objectives.mp4

24.5 MB

Lesson 9 Summary.en.ttml

1.3 KB

Lesson 9 Summary.mp4

25.6 MB

/Module 3 Program Databases by Using Transact-SQL/

Module Introduction.en.ttml

1.2 KB

Module Introduction.mp4

20.9 MB

/Summary/

SQL Server 70-761 Summary.en.ttml

5.6 KB

SQL Server 70-761 Summary.mp4

107.2 MB

/

SQLServerLL_Code.zip

60.7 KB

 

Total files 255


Copyright © 2024 FileMood.com