Azure Data Factory
What is Azure Data Factory - Azure Data Factory use cases
- Create Data Factory
- ADF Components and terminology
- Azure storage account
- Copy data activity
- Delete data activity
- Create AZURE SQL Database
- Copy CSV file from AZURE Blob to AZURE SQL
- Triggers in azure data factory
- Scheduled trigger in azure data factory
- Event based triggers in azure data factory
- Data flow in Azure data factory | Filter and sort
transformation in adf
- Join transformation
- Union transformation
- Select transformation
- Derived Column transformation
- Aggregate transformation
- Parameterize dataset
- Linked service parameterization
- Pipeline parameterization
- File naming
- Get Metadata activity
- ForEach activity
- If Condition activity
- Set Variable activity
- append variable activity
- Stored Procedure Activity
- Lookup activity
- wait activity
- Validate schema and structure of the file before
processing |ADF Project
- Copy Data From Rest API to ADLS using ADF | ADF Project
- Switch activity
- Validation activity
- Execute pipeline activity
- Filter activity
- Until activity
- Web activity
- Fail activity
- Script activity
- Exists Transformation
- Conditional Split Transformation
- Pivot transformation
- Unpivot Transformation
- Surrogate Key Transformation
- Windows transformation
- Alter row transformation
- Rank transformation
- SCD Type 1
- Error solution - Dataset is using 'Azure Sql Database'
linked service with SQL Version v2 type
- Import schema failed Error in ADF
- Dataflow import schema error | Import schema failed issue
in ADF
- SCD Type 1 Using ADF
- End to End ADF Project | Data Migration Project
- ADF Project | Skip Empty Files scenario
- ADF Project | Delete file scenario Project
- How to find total file count available in folder
- How to get email notifications for pipeline failures in
ADF
- File Unzip Scenario – ADF Project
What is Azure Data Factory Azure Data Factory use cases Create Data Factory ADF Components and terminology Azure storage account Copy data activity Delete data activity Create AZURE SQL Database Copy CSV file from AZURE Blob to AZURE SQL Triggers in azure data factory Scheduled trigger in azure data factory Event based triggers in azure data factory Data flow in Azure data factory | Filter and sort
transformation in adf Join transformation Union transformation Select transformation Derived Column transformation Aggregate transformation Parameterize dataset Linked service parameterization Pipeline parameterization File naming Get Metadata activity ForEach activity If Condition activity Set Variable activity append variable activity Stored Procedure Activity Lookup activity wait activity Validate schema and structure of the file before
processing |ADF Project Copy Data From Rest API to ADLS using ADF | ADF Project Validation activity Execute pipeline activity Filter activity Until activity Web activity Fail activity Script activity Exists Transformation Conditional Split Transformation Pivot transformation Unpivot Transformation Surrogate Key Transformation Windows transformation Alter row transformation Rank transformation SCD Type 1 Error solution - Dataset is using 'Azure Sql Database'
linked service with SQL Version v2 type Import schema failed Error in ADF Dataflow import schema error | Import schema failed issue
in ADF SCD Type 1 Using ADF End to End ADF Project | Data Migration Project ADF Project | Skip Empty Files scenario ADF Project | Delete file scenario Project How to find total file count available in folder How to get email notifications for pipeline failures in
ADF File Unzip Scenario – ADF Project
SQL Server
- What is SQL Server
- SQL Server History
- SQL Server desktop parts
- Commands
- Data types
- Date functions
- Default databases
- Tables
- Joins
- Operates
- Temporary table
- Union & Union all
- Rank & Dense rank
- Primary key & Foreign key
- Execution plan & show plan
- Synonym
- Clauses
- Views
- Pivot table & Unpivot Tables
- Sequence
- Group by
- Highest salary
- Sub queries
- Triggers
- Running total
What is SQL Server SQL Server History SQL Server desktop parts
Commands Data types Date functions Default databases Tables Joins Operates Temporary table Union & Union all Rank & Dense rank
Primary key & Foreign key Execution plan & show plan Synonym Clauses Views Pivot table & Unpivot Tables Sequence Group by Highest salary Sub queries Triggers Running total
