Skip to content
Register for a course

Techfura

All about Programming and Data Engineering

  • Blog
  • Register

SQL MERGE statement

January 28, 2021March 2, 2022 Kennedy

With data processing, in performing ETL workloads to a data warehouse, some of the activities in ETL can be achieved using the MERGE statement in SQL. The MERGE statement in SQL is a special type of query in SQL Server Read More …

Merge Statement, TSQL

Cloud Platforms Comparison Cheat Sheet

May 6, 2025May 6, 2025 Kennedy

Here’s a comprehensive cheat sheet for Cloud Comparison Cheat Sheet – core services across Microsoft Azure, Amazon Web Services (AWS), and Google Cloud Platform (GCP), organized by major category, plus brief descriptions and links to official docs for deeper dives. Read More …

Azure

SQL – CRUD and CT

February 3, 2025February 3, 2025 techfura

When writing a Microsoft SQL Server store procedure, it is normal to have multiple stored procedures for each CRUD operation (Create, Read, Update, Delete) – SELECT, INSERT, UPDATE and DELETE. However, is it possible to simplify this Transact-SQL logic into a single SQL Server stored Read More …

Stored Procedure and UDF, TSQL

Building a Real-Time Data Pipeline with Python, Docker, Airflow, Spark, Kafka, and Cassandra

September 12, 2024September 12, 2024 techfura

In today’s data-driven world, the ability to efficiently collect, process, and analyze large volumes of data is paramount. This blog post will delve into a data engineering project that leverages a powerful combination of tools: Python, Docker, Airflow, Spark, Kafka, Read More …

Data Engineering

Mastering Personalized Conversations with RAG

September 9, 2024September 9, 2024 techfura

In today’s fast-evolving tech landscape, the demand for personalized, contextually aware conversational systems is higher than ever. Whether you’re developing customer support bots, virtual personal assistants, or interactive educational tools, leveraging advanced models like Retrieval-Augmented Generation (RAG) can transform your Read More …

AI/ML, RAG

Top 10 Core Concepts in every Programming Languages

May 13, 2024May 13, 2024 techfura

While there are many programming languages, they all share some fundamental building blocks. Here’s a breakdown of the top 10 core concepts you’ll find in pretty much every coding language: Understanding these core concepts is like learning the alphabet of Read More …

Fundamentals, Programming

Intro to Apache Spark

May 8, 2024May 8, 2024 techfura

Apache Spark is a lightning-fast cluster computing technology, designed for fast computation. It is based on Hadoop MapReduce and it extends the MapReduce model to efficiently use it for more types of computations, which includes interactive queries and stream processing. Read More …

Intro to Apache Spark, SparkDataframe, Dataset, RDD, Scala, Spark

Spark SQL – Part I

May 8, 2024May 8, 2024 techfura

The world of data is exploding. Businesses are generating massive datasets from various sources – customer transactions, sensor readings, social media feeds, and more. Analyzing this data is crucial for uncovering valuable insights, informing decisions, and gaining a competitive edge. Read More …

Programming, Spark, SparkSQL

ETL with PySpark – Intro

May 8, 2024May 8, 2024 techfura

Data transformation is an essential step in the data processing pipeline, especially when working with big data platforms like PySpark. In this article, we’ll explore the different types of data transformations you can perform using PySpark, complete with easy-to-understand code Read More …

Programming, PySpark, SparkBig Data, PySpark, Python, Spark

Spark DataFrame Cheat Sheet

May 8, 2024May 8, 2024 techfura

Core Concepts DataFrame is simply a type alias of Dataset[Row] Quick Reference val spark = SparkSession .builder() .appName(“Spark SQL basic example”) .master(“local”) .getOrCreate() // For implicit conversions like converting RDDs to DataFrames import spark.implicits._ Creation create DataSet from seq   Read More …

Programming, Spark, Spark DataFrame Cheat Sheet

Basic Linux Commands – Cheat sheet

May 8, 2024May 8, 2024 techfura

This cheat sheet covers some of the most essential commands you’ll encounter in Linux. File Management: Basic Operations: Permissions and Ownership: Network: Process Management: Finding Things: Help and Information: This is a basic list. Many more commands exist for specific Read More …

Basic Linux Commands, LinuxCheat Sheet, Linux

Posts navigation

Older posts

Categories

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)

Archives

  • May 2025 (1)
  • February 2025 (1)
  • September 2024 (2)
  • May 2024 (7)
  • January 2024 (1)
  • June 2023 (2)
  • March 2022 (1)
  • April 2021 (8)
  • March 2021 (3)
  • January 2021 (3)
  • December 2020 (2)
  • October 2020 (1)
  • September 2020 (10)
  • July 2020 (1)
  • June 2020 (6)
  • May 2020 (30)
  • April 2020 (1)
  • April 2019 (1)

Recent Posts

  • Cloud Platforms Comparison Cheat Sheet
  • SQL – CRUD and CT
  • Building a Real-Time Data Pipeline with Python, Docker, Airflow, Spark, Kafka, and Cassandra
  • Mastering Personalized Conversations with RAG
  • Top 10 Core Concepts in every Programming Languages

Tags

ADLA Azure Big Data Cheat Sheet CTE Data Data Engineering Dataframe Data Pipeline Dataset Functions Linux MSSQL Procedures PySpark Python RDD Scala SLQ Delete Duplicates Spark SQL SQL SERVER SSIS SSIS Catalog error SSISDB Stored procedures STUFF() Stuff() Function TSQL U-SQL U-SQL Table UDF USQL U_SQL File Metadata

Traffic Count

traffic counter

Categories

  • AI/ML (1)
    • RAG (1)
  • Apache Kafka (1)
    • Apache Kafka 101 (1)
  • Azure (23)
    • ADF (4)
    • ADLA (14)
      • USQL (14)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • Data Engineering (2)
    • DE Roadmap (1)
  • DevOps (1)
    • Azure DevOps CI/CD Pipeline (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (2)
    • Functions (1)
    • Split csv Files (1)
  • Linux (2)
    • Basic Linux Commands (1)
    • Shell Script (1)
  • MSSQL (4)
    • CDC (1)
    • TDE (3)
  • Programming (42)
    • C# (5)
    • C++ (4)
    • Fundamentals (1)
    • HTML/CSS (3)
    • JavaScript (6)
    • Python (1)
    • Spark (4)
      • Intro to Apache Spark (1)
      • PySpark (1)
      • Spark DataFrame Cheat Sheet (1)
      • SparkSQL (1)
    • TSQL (16)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Merge Statement (1)
      • Mostly Asked Questions (4)
      • Stored Procedure and UDF (4)
  • Reporting (2)
    • SSRS (2)
© 2024 Techfura. All Rights Reserved
Proudly powered by WordPress | Education Hub by WEN Themes