种子简介

种子名称： Querying Data with T-SQL from SQL Server
文件类型： 视频
文件数目： 314个文件
文件大小： 2.37 GB
收录时间： 2023-11-21 00:00
已经下载： 3次
资源热度： 91
最近下载： 2024-5-16 11:46

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

Querying Data with T-SQL from SQL Server.torrent

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/01. Version Check.mp4713.44KB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/02. Introduction.mp44.41MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/03. What Is a Stored Procedure.mp43.74MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/04. Comparing Data Fetching Options.mp48MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/05. Primary Stored Procedure Benefits.mp43.82MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/06. Demo - Creating Test Environment.mp416.95MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/07. Demo - Minimizing Modifications.mp47.03MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/08. Exploring Security Benefits.mp43.17MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/09. Demo - Limiting User Access.mp47.54MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/10. Exploring Performance Gains.mp43.06MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/11. Demo - Execution Plan Reuse.mp414.45MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/12. Disadvantages of Stored Procedures.mp43.67MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/02. Exploring the Benefits of Stored Procedures/13. Summary.mp42.45MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/01. Introduction.mp44.04MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/02. Creating Our Stored Procedure.mp42.96MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/03. Exploring New Syntax and Executing.mp44.58MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/04. Naming Stored Procedures.mp43.86MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/05. Demo - Creating and Executing.mp414.24MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/06. Demo - Scripting Stored Procedures.mp412.91MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/07. Exploring Parameters.mp43.31MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/08. Demo - Adding Parameters.mp415.6MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/09. Exploring Debugger.mp43.03MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/10. Demo - Debugging Code.mp412.81MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/11. Reviewing Best Practices.mp44.08MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/03. Creating Our First Stored Procedure/12. Summary.mp42.91MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/01. Introduction.mp44.94MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/02. Building Queries in Stored Procedures.mp42.41MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/03. Reviewing Temporary Objects.mp44.21MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/04. Creating Temporary Objects.mp43.46MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/05. Demo - Adding Queries to Stored Procedures.mp419.88MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/06. Demo - Using Temporary Objects.mp421.15MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/07. Exploring Table Valued Parameters.mp45.03MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/08. Demo - Table Valued Parameters.mp48.73MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/09. Examining Sp_executesql.mp44.72MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/10. Demo - Using Sp_executesql.mp414.82MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/11. Implementing a Debug Flag.mp42.8MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/12. Demo - Adding a Debug Flag.mp49.16MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/04. Setting up Queries in Stored Procedures/13. Summary.mp42.69MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.mp43.45MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/1. Introduction.mp45.11MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/2. Creating a Baseline.mp44.1MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/3. Demo - Gathering Baseline Stats.mp420.07MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/4. Busting Performance Myths.mp44.45MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/5. Demo - Temp Table Myth.mp412.95MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/6. Demo - Select 1 Versus Select.mp412.05MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/7. Exploring Parameter Sniffing.mp43.55MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/8. Demo - Parameter Sniffing.mp423.34MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/5. Optimizing Stored Procedure Performance/9. Summary.mp42.64MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/1. Introduction.mp42.9MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/2. Defining Stored Procedure Templates.mp43.06MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/3. Demo - Creating Templates.mp415.64MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/4. Exploring Key Takeaways.mp43.83MB

Capturing Logic with Stored Procedures in T-SQL By Jared Westover/6. Building Stored Procedures in the Real World/5. Continuing the Journey.mp42.68MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/1. Course Overview/1. Course Overview.mp44.07MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/10. Summary/1. Summary.mp41.48MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/1. Version Check.mp4570.23KB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/2. Introduction.mp44.27MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/3. Setting up the SQL Server Environment.mp46.72MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/4. Creating SQL Server Databases.mp410.48MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/5. Using SQL Server Management Studio.mp430.29MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/2. Setting up the SQL Server Environment/6. Summary and Resources.mp41.18MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/1. Introduction.mp43.47MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/2. The SELECT Query Syntax.mp41.82MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/3. Concatenating Values in T-SQL.mp410.25MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/4. Casting and Converting Data Types.mp417.38MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/5. Formatting Strings.mp421.11MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/6. Working with Characters.mp428.4MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/7. Formatting Dates and Numbers.mp431.47MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/3. Shaping Data in a Query/8. Review and Resources.mp41.58MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/1. Introduction.mp41.51MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/2. Understanding Primary and Foreign Keys.mp48.09MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/3. Using the Inner Join.mp412.25MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/4. Left and Right Joins.mp411.15MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/5. Full OUTER Joins.mp411.66MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/6. Self Join.mp420.26MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/4. Querying Data from Multiple Tables Using JOINS/7. Review and Resources.mp42.3MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/1. Introduction.mp42.25MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/2. Expressions and Comparison Operators.mp430.68MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/3. Applying T-SQL Logical Operators.mp420.89MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/4. Controlling Flow with T-SQL Logic.mp420.86MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/5. Filtering and Controlling Flow/5. Review and Resources.mp42.43MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/1. Introduction.mp43.07MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/2. Offset and Fetch.mp46.66MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/3. TOP Functions.mp411.91MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/4. Using Variables to Limit Results.mp49.52MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/6. Limiting the Results with T-SQL Functions/5. Review and Resources.mp41.94MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/1. Introduction.mp4993.25KB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/2. Using COUNT in T-SQL.mp422.33MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/3. Using SUM in T-SQL.mp49.79MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/4. Using AVG in T-SQL.mp423.14MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/5. Using MIN and MAX in T-SQL.mp423.04MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/7. Aggregating Data in a Query/6. Review and Resources.mp41.24MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/1. Introduction.mp41.06MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/2. Difference between Joins and Set Operators.mp41.22MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/3. Union All.mp45.13MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/4. Union.mp43.4MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/5. Intersect.mp47.83MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/6. Except.mp411.36MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/8. Using T-SQL Set Operators/7. Review and Resources.mp42.87MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/1. Introduction.mp41.14MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/2. Using Common Table Expressions in T-SQL.mp422.86MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/3. Using Temporary Tables in T-SQL.mp410.28MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/4. Using Cursors in T-SQL.mp415.36MB

Combining and Filtering Data with T-SQL 2019 By Tamara Pattinson/9. Simplifying with Intermediate Tables and Common Table Expressions/5. Review and Resources.mp41.53MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/01. Version Check.mp4679.5KB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/02. Introduction.mp43.9MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/03. Why Care About Error Handling.mp44.71MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/04. Planning For Failure.mp47.06MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/05. What Do We Mean By Atomic.mp44.36MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/06. Demo - Creating a Test Environment.mp419.25MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/07. Demo - Transferring Funds.mp416.98MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/08. Handling Conversion Errors.mp43.88MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/09. Demo - Handling Conversion Errors.mp47.82MB

Handling Errors in T-SQL By Jared Westover/02. Getting Started with Error Handling in T-SQL/10. Summary.mp42.03MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/01. Introduction.mp43.42MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/02. What Is the ACID Principle.mp44.57MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/03. Transaction Modes in SQL Server.mp46.1MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/04. Demo - Transaction Modes.mp421.08MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/05. Isolation Levels.mp43.22MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/06. Demo - Isolation Levels.mp413.72MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/07. Nested Transactions.mp42.47MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/08. Demo - Nested Transactions.mp410.42MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/09. Demo - Save Points.mp48.62MB

Handling Errors in T-SQL By Jared Westover/03. Exploring Transactions in SQL Server/10. Summary.mp42.51MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/01. Introduction.mp44.31MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/02. Examining an Error Message.mp46.26MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/03. Errors Requiring Attention.mp43.43MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/04. Exploring RAISERROR.mp43.13MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/05. Demo - Error Message Details.mp417.54MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/06. Demo - Using RAISERROR.mp415.99MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/07. Exploring TRY..CATCH.mp43.41MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/08. Error Handling Methods.mp43.29MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/09. Demo - TRY..CATCH.mp416.46MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/10. Demo - XACT_ABORT and XACT_STATE.mp418.43MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/11. Exploring THROW.mp43.17MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/12. Demo - THROW.mp47.55MB

Handling Errors in T-SQL By Jared Westover/04. Examining Error Handling Methods/13. Summary.mp43MB

Handling Errors in T-SQL By Jared Westover/1. Course Overview/1. Course Overview.mp43.03MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/1. Introduction.mp44.1MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/2. Comparing RAISERROR and THROW.mp44.71MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/3. Demo - Error Handling Template.mp416.47MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/4. Demo - Actionable Message.mp420.95MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/5. Demo - Enforcing Business Logic.mp411.95MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/6. Demo - Row Count Mismatch.mp410.03MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/7. Demo - Error Table and Stored Procedure.mp420.31MB

Handling Errors in T-SQL By Jared Westover/5. Handling Errors in the Real World/8. Course Summary.mp43.8MB

Querying Data Using T-SQL By Ami Levin/1. Course Overview/1. Course Overview.mp44.68MB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/1. Version Check.mp4487.6KB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/2. Module Introduction.mp4683.81KB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/3. What Is T-SQL.mp45.49MB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/4. A Little SQL Server Architecture.mp47.87MB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/5. Tools.mp43.86MB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/6. Demo - Tools.mp47.27MB

Querying Data Using T-SQL By Ami Levin/2. What Is T-SQL/7. Module Review.mp42.18MB

Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/1. Module Introduction.mp4843.13KB

Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/2. What Is a SQL Query.mp43.8MB

Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/3. More Terminology.mp47.44MB

Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/4. Demo - First SELECT.mp410.84MB

Querying Data Using T-SQL By Ami Levin/3. Our First SELECT/5. Module Review.mp41.17MB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/1. Module Introduction.mp4559.83KB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/2. TSQL Demo Database.mp47.52MB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/3. Demo - FROM Single Table.mp47.51MB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/4. Introduction to Multiple Tables in FROM.mp49.19MB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/5. Demo - Multiple Tables.mp410.44MB

Querying Data Using T-SQL By Ami Levin/4. The FROM Clause/6. Module Review.mp41.45MB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/1. Module Introduction.mp4724.12KB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/2. Understanding NULLs.mp42.75MB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/3. 3VL (Ternary) Logic.mp46.26MB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/4. Logical Predicates and Operators.mp47.51MB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/5. Filtering with WHERE.mp49.31MB

Querying Data Using T-SQL By Ami Levin/5. Filtering with WHERE/6. Module Review.mp41.26MB

Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/1. Module Introduction.mp4688.27KB

Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/2. What Is Grouping Good For.mp425.72MB

Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/3. Grouping Rows.mp410.06MB

Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/4. Group Filtering with HAVING.mp44.6MB

Querying Data Using T-SQL By Ami Levin/6. Grouping Rows/5. Module Review.mp43.54MB

Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/1. Module Introduction.mp4739.77KB

Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/2. Evaluating SELECT Expressions.mp46.94MB

Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/3. Dealing with NULLs.mp42.34MB

Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/4. Using DISTINCT.mp46.05MB

Querying Data Using T-SQL By Ami Levin/7. Evaluating SELECT Expressions/5. Module Review.mp4898.91KB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/1. Module Introduction.mp4882.54KB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/2. Law of Order.mp44.63MB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/3. ORDER BY.mp42.41MB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/4. Determinism and Tiebreakers.mp42.23MB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/5. Paging Result Sets.mp43.86MB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/6. Demo - Ordering and Paging.mp414.14MB

Querying Data Using T-SQL By Ami Levin/8. Ordering and Paging/7. Module Review.mp43.06MB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/1. Module Introduction.mp4650.42KB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/2. Course Review.mp45.09MB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/3. Takeaway.mp42.7MB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/4. Feedback.mp41.33MB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/5. Next Steps.mp41.89MB

Querying Data Using T-SQL By Ami Levin/9. Wrapping Up/6. Additional Resources and Conclusion.mp42.19MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/1. Course Overview/1. Course Overview.mp44.73MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/1. Version Check.mp4538.63KB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/2. Querying JSON in Microsoft SQL Server.mp47.04MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/3. What Is JSON What About JSON in SQL Server.mp410.94MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/4. Querying JSON Documents with T-SQL.mp48.64MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/5. Converting Data into JSON with FOR JSON PATH and AUTO.mp415.3MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/6. Using SQL JSON Functions - JSON_VALUE, JSON_QUERY, JSON_MODIFY, and IS_JSON.mp44.96MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/7. Parsing and Importing JSON with OPENROWSET and OPENJSON.mp411.41MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/8. Handling Missing Properties with LAX and STRICT Mode.mp412.37MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/2. Querying JSON with T-SQL/9. Takeaway.mp42.15MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/1. Querying XML Data in Microsoft SQL Server with T-SQL.mp43.29MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/2. What is XML How Do I Build Good XML.mp411.86MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/3. Selecting Data from XML - OPENXML and the query and value Methods.mp424.19MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/4. Getting to Know the XPath Syntax and XQuery Language.mp414.01MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/5. Providing Rowset Views with OPENXML and the nodes Method.mp415.14MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/6. Updating XML with modify and the XML Data Modification Language.mp48.13MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/7. Filtering XML Data with Contains and Exist.mp48.46MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/3. Querying XML Data with T-SQL/8. Takeaway.mp42.03MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/1. Utilizing Temporal Tables.mp41.65MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/2. Understanding Temporal or System-versioned Tables.mp46.94MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/3. Creating Temporal and History Tables.mp45.23MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/4. Adding and Modifying Data in Temporal Tables.mp425.69MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/5. Selecting Data from Temporal Tables at Specific Points in Time.mp49.55MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/6. Recovering Data in a Temporal Table.mp46.6MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/4. Utilizing Temporal Tables/7. Takeaway.mp42.01MB

Querying JSON, XML, and Temporal Data with T-SQL By Xavier Morera/5. Final Takeaway/1. Final Takeaway.mp44.07MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/01. Modifying Data Using T-SQL Statements.mp41.54MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/02. Modifying Records with the UPDATE Statement.mp44.38MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/03. Using UPDATE to Modify Data in One Row.mp44.4MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/04. Using UPDATE to Modify Data in Multiple Rows.mp45.59MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/05. Retrieving Number of Affected Rows with @@Rowcount.mp45.62MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/06. Modifying Data Using UPDATE with Constraints.mp47.96MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/07. UPDATE Using Variables.mp48.76MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/08. FROM and JOIN within an UPDATE.mp47.16MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/09. A Few More Details on UPDATE.mp44.4MB

T-SQL Data Manipulation Playbook By Xavier Morera/04. Modifying Data Using T-SQL Statements/10. Takeaway.mp41.77MB

T-SQL Data Manipulation Playbook By Xavier Morera/1. Course Overview/1. Course Overview.mp43.41MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/1. Version Check.mp4514.93KB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/2. Working with the T-SQL Data Manipulation Language.mp46.81MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/3. Understanding and Differentiating the T-SQL Sub-languages.mp42.71MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/4. What Is the T-SQL Data Manipulation Language.mp41.81MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/5. The Database for This Training - StackOverflow or StackExchange.mp416.19MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/6. What You Need to Know About SELECT for DML.mp418.94MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/7. What You Need to Know About WHERE for DML.mp414.24MB

T-SQL Data Manipulation Playbook By Xavier Morera/2. Working with the T-SQL Data Manipulation Language/8. Takeaway.mp4966.55KB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/1. Adding Data Using T-SQL Statements.mp41.84MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/2. Adding New Records with the INSERT Statement.mp45.46MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/3. An Insert Statement with Columns and Values.mp48.93MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/4. An Insert Statement with All Values.mp44MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/5. An Insert Statement with NULL and DEFAULT.mp48.56MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/6. An Insert Statement with an Identity.mp46.57MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/7. An Insert Statement with Constraints.mp416.09MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/8. Adding Multiple Records from a Data File with BULK INSERT.mp410.19MB

T-SQL Data Manipulation Playbook By Xavier Morera/3. Adding Data Using T-SQL Statements/9. Takeaway.mp41.4MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/1. Removing Data Using T-SQL Statements.mp41.87MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/2. Removing Records with the DELETE Statement.mp41.46MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/3. Removing a Specific Record with DELETE.mp43.99MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/4. Removing Multiple Records with DELETE.mp49.36MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/5. Deleting Data Using JOINs.mp45.27MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/6. Removing Data with Constraints and Cascade Deleting of Data.mp414.01MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/7. Clearing Tables Using TRUNCATE and How It Differs from DELETE.mp411.81MB

T-SQL Data Manipulation Playbook By Xavier Morera/5. Removing Data Using T-SQL Statements/8. Takeaway.mp42.04MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/1. Maintaining Data Integrity with Transactions.mp44.09MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/2. Transaction Properties.mp41.94MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/3. Understanding T-SQL Transactions.mp43.82MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/4. Creating Transactions Using BEGIN and COMMIT.mp415.66MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/5. Querying Data Locked in a Transaction with NOLOCK.mp45.88MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/6. Undoing Transactions Using ROLLBACK.mp45.05MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/7. Partially Undoing Transactions Using Savepoints.mp410.65MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/8. Distributed Transactions at a High Level.mp42.37MB

T-SQL Data Manipulation Playbook By Xavier Morera/6. Maintaining Data Integrity with Transactions/9. Takeaway.mp41.81MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/1. Using Advanced T-SQL Techniques.mp41.55MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/2. Using INSERT with Multiple Values.mp44.26MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/3. SELECT within an INSERT Statement.mp48.3MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/4. Using SELECT to Retrieve a Specific Field in an INSERT.mp46.7MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/5. Retrieving Records on INSERT Using the OUTPUT Clause.mp412.67MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/6. Utilizing MERGE to Perform Operations on a Target Table.mp412.04MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/7. BULK INSERT Using a Format File.mp412.64MB

T-SQL Data Manipulation Playbook By Xavier Morera/7. Using Advanced T-SQL Techniques/8. Takeaway.mp42.8MB

T-SQL Data Manipulation Playbook By Xavier Morera/8. Final Takeaway/1. Final Takeaway.mp46.14MB

T-SQL Functions Playbook By Andrew McSwiggan/1. Course Overview/1. Course Overview.mp44.27MB

T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/1. Calculating Values Using String Functions.mp47.91MB

T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/2. Formatting Strings with Stuff and Replace.mp410.08MB

T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/3. Cutting out the Product Attributes.mp49.12MB

T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/4. Pivoting the Attributes.mp410.13MB

T-SQL Functions Playbook By Andrew McSwiggan/10. Calculating Values Using String Functions/5. Analysing Sales Using Product Attributes.mp410.59MB

T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/1. Calculating Values Using Numeric Scalar Functions.mp410.47MB

T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/2. The Round Function.mp48.44MB

T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/3. Creating A B Customer Tags with Modulus.mp412.06MB

T-SQL Functions Playbook By Andrew McSwiggan/11. Calculating Values Using Numeric Scalar Functions/4. Creating Alternating Customer A B Tags.mp44.01MB

T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/1. Creating Measures with Aggregation Functions.mp47.93MB

T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/2. A Tour of the Data.mp46.67MB

T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/3. Creating an Aggregation Query.mp46.71MB

T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/4. Querying Unique Lists of Values.mp48.1MB

T-SQL Functions Playbook By Andrew McSwiggan/2. Creating Measures with Aggregation Functions/5. Querying Aggregations in Lists.mp413.94MB

T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/1. Ranking Data with Rank and Partition.mp410.65MB

T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/2. The Rank Function.mp48.28MB

T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/3. The Dense Rank Function.mp413.99MB

T-SQL Functions Playbook By Andrew McSwiggan/3. Ranking Data with RANK and PARTITION/4. The NTILE Function.mp46.5MB

T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/1. Aggregating and Summarizing Data with Functions.mp48.06MB

T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/2. The Percent Rank Function.mp412.97MB

T-SQL Functions Playbook By Andrew McSwiggan/4. Aggregating and Summarizing Data with Functions/3. First and Last Value.mp411.79MB

T-SQL Functions Playbook By Andrew McSwiggan/5. Substituting a Table Reference with a ROWSET Function/1. Substituting a Table Reference with a ROWSET Function.mp413.02MB

T-SQL Functions Playbook By Andrew McSwiggan/5. Substituting a Table Reference with a ROWSET Function/2. OPENROWSET Queries.mp49.5MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/1. Query Data with Inline Queries and Scalar Functions.mp45.48MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/2. Searching for Strings with the LIKE Function.mp43.98MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/3. LIKE Function Demo.mp410.66MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/4. Creating Statements with Simple Scalar Functions.mp49.68MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/5. Formatting Functions.mp46.85MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/6. Inline View Queries and Subqueries.mp415.87MB

T-SQL Functions Playbook By Andrew McSwiggan/6. Query Data with Inline Queries and Scalar Functions/7. The Subquery.mp46.45MB

T-SQL Functions Playbook By Andrew McSwiggan/7. Query Data with Static Value Functions/1. Query Data with Static Value Functions.mp410.02MB

T-SQL Functions Playbook By Andrew McSwiggan/7. Query Data with Static Value Functions/2. Monthly Rolling Sales with GETDATE.mp49.04MB

T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/1. Implementing IF Then Logic.mp43.52MB

T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/2. Product Groups.mp415.17MB

T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/3. Product Gender.mp414.7MB

T-SQL Functions Playbook By Andrew McSwiggan/8. Implementing IF Then Logic/4. Intelligent Measures.mp47.4MB

T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/1. Combining Queries with COALESCE.mp413.28MB

T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/2. Adding the COALESCE Function to a Query.mp410.81MB

T-SQL Functions Playbook By Andrew McSwiggan/9. Combining Queries with COALESCE/3. Joining Multiple Queries with COALESCE.mp45.45MB