381 подписчиков
127 видео
Master Azure Data Factory: Data Flow Transformations - Select, Derived, & Aggregate Explained!
Mastering Multiple Row Subqueries in Snowflake: A Comprehensive Guide! with All, Any, IN Subquery!!
How to Use Cursors in Snowflake: Step-by-Step Tutorial
How to Use FOR Loops in Snowflake Scripting | Type of for Loop | Snowflake tutorial | SQL
Mastering Validation Mode | Copy INTO Command | Techniques in Snowflake Database
How to Declare Variables in Snowflake Scripting: Declaration, Scope, Assignment, SELECT Statements
Mastering Snowflake: Efficiently Handling Rejected Records with COPY INTO Command
Mastering Date Functions in Snowflake: DATEDIFF, LAST_DAY, NEXT_DAY, and More!
Subquery Using Exists and Not-Exists Function: A Deep Dive into Snowflake SQL Functions
How to Create and Attach Event Triggers to Pipelines | Type of Trigger |Azure Data Factory Tutorial
Mastering Snowflake: Exploring Table Types and Data Types for Optimal Performance
Snowflake Streams Deep Dive | Change Data Capture (CDC) | Real-Time Data Processing Simplified
Snowflake Scripting Tutorial: Using IF Statements with Example
Database Vs Data warehouse
Introduction to Snowflake Scripting: Basics of Begin and End Blocks
WHILE Loops in Snowflake Scripting Explained | Practical Examples| Snowflake |SQL
ADF Mapping Design: Identify Employees Earning Below Departmental Average Salary.
Tableau Data Connections: A Comprehensive Tutorial
Efficient Data Handling with Resultsets in Snowflake Scripting | Snowflake SQL
Mastering SQL Set Operators: Union, Union All, Intersect, Minus
Accessing Azure Data Lake Storage Using Service Principal in Databricks: A Step-by-Step Guide
DDL COMMAND
How to Use the RETURN Command in Snowflake Scripting | Return as Tables
Bulk Data Transfer: Azure Data Storage to SQL Database Using ADF
Basics of Loops in Snowflake Scripting | Snowflake Scripting Tutorial | Loop
Power of Snowflake Database | Exploring File Format Objects for Optimal Data Management
Unleashing the Power of Common Table Expressions (CTEs) for Advanced Data Analysis with Snowflake
How to Master Group By Functions in Snowflake: Complete Guide and Examples
How to use the Lookup Activity in Microsoft Fabric Data Factory: A Step-by-Step Guide
Snowflake Tutorial: How to Drop Columns from Existing Tables
How to Use UPDATE Statements for Data Management using snowflake
Creating and Linking Databricks Secret Scope with Azure Key Vault
Automate the process using Task and Streams with snowflake
Mastering REGEXP_COUNT in Snowflake SQL: Real-World Text Analysis Examples
How to Select Required column and Rename Columns in Databricks Using Pyspark
Load data from Azure SQL and Blob Storage to Snowflake | using Sort and Union Transformations | ADF
Using SQLROWCOUNT, SQLFOUND, and SQLNOTFOUND in Snowflake Scripting to Track DML Statement Effects
Snowflake | COPY INTO COMMAND | OPTION: - SIZE_LIMIT | RETURN_FAILED_ONLY | TRUNCATECOLUMNS | FORCE.
Exploring RANK and DENSE_RANK Functions in Snowflake SQL
Loading Data from Azure Blob to Snowflake Table |Container Creation | External Stage Integration
Creating a Database and table using the Azure SQL in Azure Portal
Snowflake Tutorial: How to Modify Existing Columns in a Table
1| Azure Databricks Setup: How to Create a Databricks Workspace
Mastering Pipeline Variables: Dynamic Data Handling in Your Workflows in ADF/Microsoft Fabric
Exploring Self Joins in SQL: Mastering Relationships Within a Single Table
How to Load Unique and Duplicate Rows into Separate Tables Using Azure Data Factory | ADF Tutorial
Mastering Number and Date Formatting in Snowflake: TO_NUMBER, TO_DATE, CAST, and Double Colon
3 | Azure Storage Account Setup: Step-by-Step Tutorial
Kusto Query Language (KQL) Basics: Using Pipes, Take & Project
How to Remove Duplicate Records in PySpark | Window Function | row num function | Real-World Example