SQLtoSSIStoPowerBI

@UCLcw3yrl-vEk7tSB00TYo0Q - 1.2K subscribers

This channel is related to technology and database videos. It is very much useful for beginners who completed studies and searching for Database and ETL-related jobs. The content of this channel build based on real-time scenarios. The use cases helps to Freshers to attend interview.

Home Videos Live Playlists

SSIS||Convert Dob to Age and FirstName and LastName as FullName

SSIS||Convert Dob to Age and FirstName and LastName as FullName SQLtoSSIStoPowerBI

28 views - 2 weeks ago

SQL SERVER - || How to transfer a table from previous version to latest version?

SQL SERVER - || How to transfer a table from previous version to latest version? SQLtoSSIStoPowerBI

30 views - 2 months ago

SQL Server - II HAVING clause with multiple aggregate conditions

SQL Server - II HAVING clause with multiple aggregate conditions SQLtoSSIStoPowerBI

19 views - 3 months ago

SQL Queries||How many ways to find missing records in two tables?

SQL Queries||How many ways to find missing records in two tables? SQLtoSSIStoPowerBI

33 views - 3 months ago

SQL SERVER - II How to create table with JSON data type and retrieve the data?

SQL SERVER - II How to create table with JSON data type and retrieve the data? SQLtoSSIStoPowerBI

24 views - 3 months ago

SSIS||How to handle Dupe records in SSIS without Sort and Aggregate?

SSIS||How to handle Dupe records in SSIS without Sort and Aggregate? SQLtoSSIStoPowerBI

16 views - 3 months ago

SQL Queries|Interview Question for Data Engineer in Capgemini

SQL Queries|Interview Question for Data Engineer in Capgemini SQLtoSSIStoPowerBI

60 views - 4 months ago

SQL SERVER - II||What is SET NOCOUNT?

SQL SERVER - II||What is SET NOCOUNT? SQLtoSSIStoPowerBI

35 views - 5 months ago

SQL SERVER - II||How many ways to Get column value as row based value?

SQL SERVER - II||How many ways to Get column value as row based value? SQLtoSSIStoPowerBI

33 views - 5 months ago

SQL SERVER - II||SQL Job to move files from one folder to another Using Power Shell

SQL SERVER - II||SQL Job to move files from one folder to another Using Power Shell SQLtoSSIStoPowerBI

45 views - 6 months ago

SQL SERVER - II||How to get previous row value without LAG function?

SQL SERVER - II||How to get previous row value without LAG function? SQLtoSSIStoPowerBI

30 views - 6 months ago

SQL SERVER - II||How to change the column as case sensitive?

SQL SERVER - II||How to change the column as case sensitive? SQLtoSSIStoPowerBI

44 views - 6 months ago

SQL SERVER - II||Steps to create SQL Job for Weekdays

SQL SERVER - II||Steps to create SQL Job for Weekdays SQLtoSSIStoPowerBI

27 views - 6 months ago

Stored Procedures||Find the existence of employee in the table

Stored Procedures||Find the existence of employee in the table SQLtoSSIStoPowerBI

14 views - 6 months ago

SQL SERVER - II||How to load table from older version to latest version?

SQL SERVER - II||How to load table from older version to latest version? SQLtoSSIStoPowerBI

26 views - 6 months ago

SQL SERVER - II||Steps to overcome Agent XPs disabled in SSMS

SQL SERVER - II||Steps to overcome Agent XPs disabled in SSMS SQLtoSSIStoPowerBI

33 views - 6 months ago

SQL SERVER - II||How Greatest and Least Functions effectively replaces Case Statements?

SQL SERVER - II||How Greatest and Least Functions effectively replaces Case Statements? SQLtoSSIStoPowerBI

17 views - 6 months ago

SQL SERVER - II||How to confirm data transfer from Staging to Main table?

SQL SERVER - II||How to confirm data transfer from Staging to Main table? SQLtoSSIStoPowerBI

35 views - 6 months ago

SQL SERVER - II||How many ways to handle "Divide By Zero Error Encountered"?

SQL SERVER - II||How many ways to handle "Divide By Zero Error Encountered"? SQLtoSSIStoPowerBI

16 views - 6 months ago

SQL SERVER - II||Import Flat File Vs Import Data in SSMS

SQL SERVER - II||Import Flat File Vs Import Data in SSMS SQLtoSSIStoPowerBI

45 views - 6 months ago

SQL SERVER - II||How to Run Multiple SQL Scripts at once?

SQL SERVER - II||How to Run Multiple SQL Scripts at once? SQLtoSSIStoPowerBI

114 views - 6 months ago

SSIS||Load data from source when target has Check constraint and Identity

SSIS||Load data from source when target has Check constraint and Identity SQLtoSSIStoPowerBI

14 views - 7 months ago

SQL SERVER - II||How to made changes in Dim table using Merge Statement with SCD Type-2?

SQL SERVER - II||How to made changes in Dim table using Merge Statement with SCD Type-2? SQLtoSSIStoPowerBI

47 views - 7 months ago

SQL SERVER - II||How many ways to get count of tables in database?

SQL SERVER - II||How many ways to get count of tables in database? SQLtoSSIStoPowerBI

12 views - 7 months ago

SQL SERVER - II||Which Operating System Your SQL SERVER is Running

SQL SERVER - II||Which Operating System Your SQL SERVER is Running SQLtoSSIStoPowerBI

14 views - 7 months ago

SQL SERVER - II||How to create DDL Trigger for Preventing Deletion of Database?

SQL SERVER - II||How to create DDL Trigger for Preventing Deletion of Database? SQLtoSSIStoPowerBI

15 views - 7 months ago

SQL SERVER - II||How to split the Fullname into three parts using Parsename?

SQL SERVER - II||How to split the Fullname into three parts using Parsename? SQLtoSSIStoPowerBI

24 views - 7 months ago

SSIS Package||Loading data into Fact Sales table using multiple lookup transformations?

SSIS Package||Loading data into Fact Sales table using multiple lookup transformations? SQLtoSSIStoPowerBI

37 views - 7 months ago

SSIS||How to create Text File Logging For SSIS Package?

SSIS||How to create Text File Logging For SSIS Package? SQLtoSSIStoPowerBI

63 views - 7 months ago

SQL SERVER - II||Most efficient method to take a backup of a large table into Database in SSMS

SQL SERVER - II||Most efficient method to take a backup of a large table into Database in SSMS SQLtoSSIStoPowerBI

15 views - 7 months ago

SQL SERVER - II||How to change LastModified column using Trigger?

SQL SERVER - II||How to change LastModified column using Trigger? SQLtoSSIStoPowerBI

22 views - 7 months ago

SQL SERVER - II|| How to set a Database in Read-only?

SQL SERVER - II|| How to set a Database in Read-only? SQLtoSSIStoPowerBI

31 views - 7 months ago

SQL SERVER - II||Implicit Vs Explicit Conversion

SQL SERVER - II||Implicit Vs Explicit Conversion SQLtoSSIStoPowerBI

19 views - 7 months ago

SQL SERVER - II||How many ways to insert Default value into the table?

SQL SERVER - II||How many ways to insert Default value into the table? SQLtoSSIStoPowerBI

20 views - 8 months ago

SQL SERVER - II||What is Covering Index? How it helps to increase query performance?

SQL SERVER - II||What is Covering Index? How it helps to increase query performance? SQLtoSSIStoPowerBI

16 views - 8 months ago

SQL SERVER - II||Difference between source and target tables using CHECKSUM?

SQL SERVER - II||Difference between source and target tables using CHECKSUM? SQLtoSSIStoPowerBI

22 views - 8 months ago

SQL Queries||How to find out NULL column names in a table?

SQL Queries||How to find out NULL column names in a table? SQLtoSSIStoPowerBI

24 views - 8 months ago

SQL SERVER - II||How to handle error 'Operand data type varchar is invalid'?

SQL SERVER - II||How to handle error 'Operand data type varchar is invalid'? SQLtoSSIStoPowerBI

35 views - 8 months ago

SQL SERVER - II||How to Update LastModified Column in the table with Trigger?

SQL SERVER - II||How to Update LastModified Column in the table with Trigger? SQLtoSSIStoPowerBI

25 views - 8 months ago

Excel||How Slicers are different to Filter in Excel?

Excel||How Slicers are different to Filter in Excel? SQLtoSSIStoPowerBI

14 views - 8 months ago

SQL SERVER - II||SQL Transaction for money transfer from one to another

SQL SERVER - II||SQL Transaction for money transfer from one to another SQLtoSSIStoPowerBI

22 views - 8 months ago

SQL SERVER - II||How to know identity column without using sp_help?

SQL SERVER - II||How to know identity column without using sp_help? SQLtoSSIStoPowerBI

15 views - 8 months ago

SQL SERVER - II||How to create tables with all constraints?

SQL SERVER - II||How to create tables with all constraints? SQLtoSSIStoPowerBI

14 views - 8 months ago

SQL Queries||How to get count of comma separated values in a column?

SQL Queries||How to get count of comma separated values in a column? SQLtoSSIStoPowerBI

40 views - 8 months ago

SQL SERVER - II||How to add constraints to the existing columns in a table?

SQL SERVER - II||How to add constraints to the existing columns in a table? SQLtoSSIStoPowerBI

10 views - 9 months ago

SQL Queries||How to get dayname of first and last day for each month?

SQL Queries||How to get dayname of first and last day for each month? SQLtoSSIStoPowerBI

12 views - 9 months ago

SQL SERVER II||Case Expression to get to know Year as Leap Year or Not

SQL SERVER II||Case Expression to get to know Year as Leap Year or Not SQLtoSSIStoPowerBI

9 views - 9 months ago

SSIS||Handling null values in Stage table before loaded into Fact

SSIS||Handling null values in Stage table before loaded into Fact SQLtoSSIStoPowerBI

6 views - 9 months ago

Stored Procedures||IF...ELSE and IIF()

Stored Procedures||IF...ELSE and IIF() SQLtoSSIStoPowerBI

27 views - 9 months ago

SQL Queries||Interview Questions on Date column-II

SQL Queries||Interview Questions on Date column-II SQLtoSSIStoPowerBI

29 views - 9 months ago

SSIS||How to load First 100 Rows from CSV file into table?

SSIS||How to load First 100 Rows from CSV file into table? SQLtoSSIStoPowerBI

60 views - 9 months ago

SQL SERVER - II||How to handle T-SQL Error Code using Try Catch Block?

SQL SERVER - II||How to handle T-SQL Error Code using Try Catch Block? SQLtoSSIStoPowerBI

15 views - 9 months ago

SSIS||How to create a folder with today's date using script task?

SSIS||How to create a folder with today's date using script task? SQLtoSSIStoPowerBI

12 views - 9 months ago

Power BI||How to get connected SQL SERVER and MySQL?

Power BI||How to get connected SQL SERVER and MySQL? SQLtoSSIStoPowerBI

24 views - 9 months ago

SQL Queries||Write CTE to separate name into first and last names

SQL Queries||Write CTE to separate name into first and last names SQLtoSSIStoPowerBI

25 views - 9 months ago

SQL SERVER-II How many ways to convert month number to month name?

SQL SERVER-II How many ways to convert month number to month name? SQLtoSSIStoPowerBI

26 views - 9 months ago

Power BI||Create Map with Airport Names data

Power BI||Create Map with Airport Names data SQLtoSSIStoPowerBI

37 views - 10 months ago

Excel||How to remove Space and Special Characters in a Cell in Excel?

Excel||How to remove Space and Special Characters in a Cell in Excel? SQLtoSSIStoPowerBI

19 views - 10 months ago

SQL SERVER - II||How to use REPLACE to cleansing the data?

SQL SERVER - II||How to use REPLACE to cleansing the data? SQLtoSSIStoPowerBI

33 views - 10 months ago

SSIS||How to get count of text files in a folder?

SSIS||How to get count of text files in a folder? SQLtoSSIStoPowerBI

18 views - 10 months ago