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