种子简介

种子名称： SQL Server 70-761 Querying Data with Transact-SQL
文件类型： 视频
文件数目： 127个文件
文件大小： 22.24 GB
收录时间： 2023-10-11 07:21
已经下载： 3次
资源热度： 73
最近下载： 2024-5-15 17:07

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:5a46565045f10480f9d7a2cbbfd08346608a6512&dn=SQL Server 70-761 Querying Data with Transact-SQL 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

SQL Server 70-761 Querying Data with Transact-SQL.torrent

Introduction/SQL Server 70-761 Introduction.mp4137.47MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.1 Transact-SQL Overview.mp4176.96MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.10 Lab Creating Queries Using Set Operators.mp4120.63MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.11 Lab Examining Precedence Among Set Operators.mp4110.79MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.12 Distinguishing Between UNION and UNION ALL Behavior.mp470.26MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.13 Lab Creating Queries with UNION and UNION ALL.mp452.98MB

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.mp492.34MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.2 Identifying Proper SELECT Query Structure—Predicates and Operators.mp4394.36MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.3 Identifying Proper SELECT Query Structure—Elements and Execution.mp4288.42MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.4 Lab Writing Queries That Filter Data Using Predicates.mp4206.91MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.5 Writing Specific Queries to Satisfy Business Requirements.mp4305.54MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.6 Lab Reviewing Non-Efficient and Efficient Sample Queries.mp477.98MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.7 Lab Controlling the Order of the Query Result.mp4169.32MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.8 Lab Understanding All-at-once Operations.mp4226.31MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/1.9 Constructing Results from Multiple Queries Using Set Operators.mp4167.11MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/Learning objectives.mp428.64MB

Module 1 Manage Data with Transact-SQL/Lesson 1 Create Transact-SQL SELECT Queries/Lesson 1 Summary.mp428.54MB

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.mp4172.79MB

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.mp4296.54MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/2.3 Lab Implementing Join Statements on Provided Tables.mp4245.2MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/2.4 Lab Implementing CROSS JOIN on Provided Tables.mp4213.63MB

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.mp489.69MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/2.6 Lab Using Queries with Multiple JOIN Operators.mp4179.01MB

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.mp4226.83MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/2.8 Writing Queries with NULLs on Joins.mp4127.42MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/2.9 Lab Using Joins with NULLS.mp4205.34MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/Learning objectives.mp423.03MB

Module 1 Manage Data with Transact-SQL/Lesson 2 Query Multiple Tables by Using Joins/Lesson 2 Summary.mp439.29MB

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.mp4255.07MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.10 Using Logical and System Functions.mp4207.47MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.11 Lab Using Built-In Functions in Queries.mp4275.18MB

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.mp4197.61MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.3 Lab Implementing Queries Using Scalar-Valued Functions.mp4152.16MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.4 Lab Implementing Queries Using Table-Valued Functions.mp492.17MB

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.mp487.64MB

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.mp4154.41MB

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.mp459.47MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.8 Using Built-In Aggregate Functions.mp482.76MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/3.9 Using Arithmetic and Date-Related Functions.mp4346.79MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/Learning objectives.mp427.22MB

Module 1 Manage Data with Transact-SQL/Lesson 3 Implement Functions and Aggregate Data/Lesson 3 Summary.mp421.31MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.1 Writing INSERT Statements.mp4169.86MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.2 Writing UPDATE Statements.mp4142.61MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.3 Writing DELETE Statements and Best Practices for Data Modification.mp4148.8MB

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.mp4170.74MB

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.mp4686.92MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.6 Constructing Data Manipulation Language (DML) Statements Using the OUTPUT Statement.mp4184.83MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.7 Lab Creating DML Statements Using the OUTPUT Statement.mp4193.54MB

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.mp488.07MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/4.9 Lab Using DDL Statements.mp4157.21MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/Learning objectives.mp421.49MB

Module 1 Manage Data with Transact-SQL/Lesson 4 Modify Data/Lesson 4 Summary.mp419.54MB

Module 1 Manage Data with Transact-SQL/Module Introduction.mp428.63MB

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.mp4199.37MB

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.mp4232.61MB

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.mp4288.14MB

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.mp4106.56MB

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.mp4150.97MB

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.mp4140.88MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 5 Query Data by Using Subqueries and Apply/Learning objectives.mp422.34MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 5 Query Data by Using Subqueries and Apply/Lesson 5 Summary.mp417.1MB

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.mp4281.84MB

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.mp492.38MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 6 Query Data by Using Table Expressions/6.3 Lab Using Table Expressions.mp4294.68MB

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.mp4161.8MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 6 Query Data by Using Table Expressions/6.5 Lab Using Recursive Table Expressions.mp4150.89MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 6 Query Data by Using Table Expressions/Learning objectives.mp422.16MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 6 Query Data by Using Table Expressions/Lesson 6 Summary.mp414.88MB

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.mp4476.46MB

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.mp472.09MB

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.mp4325.34MB

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.mp4308.46MB

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.mp4337.98MB

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.mp4223.31MB

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.mp4286.25MB

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.mp485.47MB

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.mp4179.98MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 7 Group and Pivot Data by Using Queries/Learning objectives.mp427.42MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 7 Group and Pivot Data by Using Queries/Lesson 7 Summary.mp423.12MB

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.mp4163.22MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 8 Query Temporal Data and Non-Relational Data/8.2 Lab Using Temporal Tables.mp4165.1MB

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.mp4385.68MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 8 Query Temporal Data and Non-Relational Data/8.4 Lab Using JSON Data.mp4291.47MB

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.mp4430.27MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 8 Query Temporal Data and Non-Relational Data/8.6 Lab Using XML Data.mp4587.16MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 8 Query Temporal Data and Non-Relational Data/Learning objectives.mp416.08MB

Module 2 Query Data With Advanced Transact-SQL Components/Lesson 8 Query Temporal Data and Non-Relational Data/Lesson 8 Summary.mp434.03MB

Module 2 Query Data With Advanced Transact-SQL Components/Module Introduction.mp421.12MB

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.mp4439.58MB

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.mp4299.03MB

Module 3 Program Databases by Using Transact-SQL/Lesson 10 Implement Error Handling and Transactions/10.3 Lab Using Try…Catch to Redirect Errors.mp4269.5MB

Module 3 Program Databases by Using Transact-SQL/Lesson 10 Implement Error Handling and Transactions/10.4 Generating Error Messages with THROW and RAISERROR.mp4238.52MB

Module 3 Program Databases by Using Transact-SQL/Lesson 10 Implement Error Handling and Transactions/10.5 Lab Using THROW and RAISERROR.mp4205.04MB

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.mp458.05MB

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.mp4142.27MB

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.mp4597.11MB

Module 3 Program Databases by Using Transact-SQL/Lesson 10 Implement Error Handling and Transactions/Learning objectives.mp427.5MB

Module 3 Program Databases by Using Transact-SQL/Lesson 10 Implement Error Handling and Transactions/Lesson 10 Summary.mp428.7MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/11.1 Evaluating Results of Data Type Conversions.mp4427.01MB

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.mp4226.05MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/11.11 Lab Using ISNULL and COALESCE.mp4224.87MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/11.2 Lab Converting Data Types.mp4200.19MB

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.mp4311.92MB

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.mp4235.16MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/11.5 Lab Using Proper Data Types.mp4501.93MB

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.mp4183.22MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/11.7 Lab Identifying Implicit Data Type Conversions.mp4167.95MB

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.mp495.15MB

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.mp4312.21MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/Learning objectives.mp425.95MB

Module 3 Program Databases by Using Transact-SQL/Lesson 11 Implement Data Types and NULLS/Lesson 11 Summary.mp429.76MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/9.1 Creating Stored Procedures.mp4213.89MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/9.10 Creating Indexed Views.mp4160.63MB

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.mp4241.46MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/9.12 Lab Creating Indexed Views.mp4167.13MB

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.mp4221.85MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/9.3 Creating and Using Views.mp4225.95MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/9.4 Lab Writing Stored Procedures.mp4183.08MB

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.mp4224.84MB

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.mp4142.62MB

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.mp4161.72MB

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.mp4274.44MB

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.mp477.98MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/Learning objectives.mp423.36MB

Module 3 Program Databases by Using Transact-SQL/Lesson 9 Create Database Programmability Objects by Using Transact-SQL/Lesson 9 Summary.mp424.39MB

Module 3 Program Databases by Using Transact-SQL/Module Introduction.mp419.92MB

Summary/SQL Server 70-761 Summary.mp4102.21MB