Видео 121
Просмотров 1 173 872

SQL Tutorial - How to change data in a View

18:39

SQL Tutorial - How to compare multiple columns in SQL

16:14

SQL Tutorial - How to update data using joins in SQL

22:41

How to Debug Data Flows in Azure Data Factory

11:31

How to transform data using Data Flows

21:54

SQL Tutorial - Stored Procedures Optional Parameters

9:41

SQL Tutorial - How to search text in a Stored Procedure

Learn how to search text in a stored procedure, if you want to know what stored procedures are inserting, updating or deleting data in a table this tutorial will show you how. Using a combination of system catalog views, sys.objects and sys.sql_modules you will not only be able to find all stored procedures that reference a table but other objects too such as views, triggers and functions.
Further reading can be found on Microsoft Docs:
sys.objects
docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-objects-transact-sql?view=sql-server-ver16
sys.sql_modules
docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-modules-transact-sql?view=sql-server...

Видео

SQL Tutorial - How to change data in a View

18:39

SQL Tutorial - How to change data in a View

Просмотров 2,8 тыс.2 года назад

Learn how to change data in a View in SQL, in this SQL Tutorial I will be talking about how to INSERT, UPDATE and DELETE data in Views. An important point to remember when modifying data in a View is that no changes are actually happening to the View, instead the data is being changed in the underlying base table. I talk through the rules for updateable Views and test out different scenarios.

SQL Tutorial - How to compare multiple columns in SQL

16:14

SQL Tutorial - How to compare multiple columns in SQL

Просмотров 11 тыс.2 года назад

Learn how to compare multiple columns in SQL, in this video I cover comparing multiple columns in the WHERE clause, using CHECKSUM, BINARY_CHECKSUM and HASHBYTES. I also discuss the advantages and disadvantages of using CHECKSUM, BINARY_CHECKSUM and HASHBYTES and what is my preferred approach for comparing multiple columns. An important point when using CHECKSUM, BINARY_CHECKSUM or HASHBYTES to...

SQL Tutorial - How to update data using joins in SQL

22:41

SQL Tutorial - How to update data using joins in SQL

Просмотров 5 тыс.2 года назад

Learn how to update data using joins in SQL and much more, in this video we will cover how to perform updates using joins in SQL, how to update multiple columns at the same time, how to update data using CTEs and how to update data within a transaction, we will also cover what sanity checks need to carried when out when performing updates. #beardeddev #sql #data #dataengineering #dataanalysis T...

How to Debug Data Flows in Azure Data Factory

11:31

How to Debug Data Flows in Azure Data Factory

Просмотров 2,5 тыс.2 года назад

Learn how to debug data flows, how to turn on data flow debug, how to configure data flow debug settings and how much data flow debug costs. In this video we look at a data flow created previously and how we can see how the data changes with each transformation, we also discuss how much data flow debug costs, unfortunately it's not free and more details can be found on the link below, keep an e...

21:54

How to transform data using Data Flows

Просмотров 2,1 тыс.2 года назад

Learn how to transform data using Data Flows within Azure Data Factory. Data Flows are an no code/low code solution that allow us to connect to data sources, transform data then write that data to a data destination. In this video we cover what transformations are available within Data Flows, work through an example where we pick up a file, apply an aggregate transformation followed by a derive...

SQL Tutorial - Stored Procedures Optional Parameters

9:41

SQL Tutorial - Stored Procedures Optional Parameters

Просмотров 2,6 тыс.2 года назад

Learn how to create stored procedures with optional parameters in under 10 minutes. In this video I walk through a simple stored procedure example where I assign default values for parameters within the stored procedure definition, this prevents the need of adding all parameters every time you execute the stored procedure. Assigning default values within the stored procedure definition effectiv...

SQL Tutorial - How to drop a column from a table

13:15

SQL Tutorial - How to drop a column from a table

Просмотров 8612 года назад

Learn how to drop columns from a table in this video tutorial and also why you might come across some errors. In this SQL Tutorial I cover: How to drop columns from a table How to drop multiple columns from a table What impact does dropping columns have on Views that include those columns How to drop computed columns and what happens if you try to drop a column that is part of the computation W...

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 2

11:16

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 2

Просмотров 3,7 тыс.2 года назад

In this tutorial I demonstrate how to create a dynamic pivot query in SQL using STRING_AGG, a function added in SQL Server 2017. Performing pivot operations in SQL can be quite static when we have to list out each attribute and building a dynamic pivot query can help us solve that problem. Dynamic pivot queries also have the added benefit that we don't need to change the query when new values a...

SQL Tutorial - How to add total rows and columns to a Pivot Query

15:41

SQL Tutorial - How to add total rows and columns to a Pivot Query

Просмотров 8 тыс.2 года назад

Learn how to add total rows and columns to a pivot query in 15 minutes. In this SQL tutorial I show you how to add totals to pivot queries, I explain how to add a total row and and a total column. Adding totals to pivot queries in SQL Server Management studio is not my preferred approach but it can be done and it can be as simple as adding rows together. In the video I discuss the different app...

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 1

19:40

SQL Tutorial - How to create a Dynamic Pivot in SQL Part 1

Просмотров 8 тыс.2 года назад

In this tutorial I demonstrate how to create a dynamic pivot query in SQL, performing pivot operations in SQL can be quite static when we have to list out each attribute and building a dynamic pivot query can help us solve that problem. Dynamic pivot queries also have the added benefit that we don't need to change the query when new values are added like we would have to do with a static pivot ...

8:46

SQL Tutorial - Nesting CASE statements

Просмотров 22 тыс.2 года назад

Learn how to nest CASE statements in this SQL tutorial, nesting CASE statements can be used for layers of conditional logic but can become complex and difficult to read so always remember to add comments to your code, I also like to indent my case statements to improve readability. The other issue with nested CASE statements is that they are not very dynamic but we could overcome that problem b...

Data Factory Tutorial - How to add an Pre Copy Script

8:24

Data Factory Tutorial - How to add an Pre Copy Script

Просмотров 7 тыс.2 года назад

Learn how to add an Pre-copy script to your pipelines in this Data Factory Tutorial. In this video I show you how to truncate a table using an Pre-copy script within a copy activity. This is useful if you are loading data to a staging table that will then be processed further, we don't want to just keep adding data and a Pre-copy script can be used to truncate the sink or target table. I also d...

SQL Tutorial - How to Join to Derived Tables

8:58

SQL Tutorial - How to Join to Derived Tables

Просмотров 2,7 тыс.2 года назад

In this SQL Tutorial learn to how to join to derived tables. I talk you through the benefits of derived tables, show you to create a derived table then how to join to the derived table. In the video we work through practical examples, creating the same query with a join between two tables then grouping and creating a derived table then joining to give the same results. If you are not familiar w...

SQL Tutorial - Difference between CTEs and Derived Tables

28:53

SQL Tutorial - Difference between CTEs and Derived Tables

Просмотров 2,9 тыс.2 года назад

In this SQL Tutorial I talk through the differences between CTEs and Derived Tables in SQL Server. CTEs actually came along to address some of the limitations of Derived Tables, when nesting Derived Tables it can be difficult to understand what the query is doing, CTEs address this by allowing you to read the SQL code from top to bottom, as Derived Tables are also declared in the FROM clause of...