Librarium
Settings

Mukesh Singh

@sql-datatools

This channel contains all the tutorial demo for Microsoft Business Intelligence with (SQL Server, SSRS, SSIS and SSAS).

  • Programming Language: Python, R, Spark, PySpark and C#
  • PL/SQL, T-SQL, ETLs with SQL Server 2012, 2014 and 2016 onward
  • Tools: MS Visio, Microsoft Azure Explorer Tools, Azure Data Lake tools, Amazon Glue, Pentaho, Talend, Teradata SQL Assistant and DbVisualizer
  • Microsoft SQL Server, AWS, Azure SQL server, Teradata, Hadoop, Tableau, Power BI, Micro-strategy and Reporting Services, NoSQL MongoDB
  • Airflow, GCP, Amazon WMS APIs Apart from this, we are here to support the natural things such as birds, animals, trees, mountain, water-falls, space and funny moments also.
667
2023-10-07
0.24 LBC

07:43

SQL – How to use PIVOT Tables Operator to Convert Rows into Columns

Mukesh Singh

Shared 11/07/2024

05:23

SQL - How to Use Rollup Operator to Calculate SubTotal and GrandTotal at hierarchal Level

Mukesh Singh

Shared 11/07/2024

06:02

SQL Interview Questions — High Cardinality Vs Low Cardinality

Mukesh Singh

Shared 08/07/2024

06:59

SQL Interview Questions - Row_Number() vs Rank() vs Dense_Rank()

Mukesh Singh

Shared 05/07/2024

03:44

Databricks - What are Materialized Views || Speed up your Lakeview dashboards

Mukesh Singh

Shared 03/07/2024

11:56

Jeep Toy with Ivaan is live

Mukesh Singh

Shared 28/06/2024

01:49

Mukesh Singh is live

Mukesh Singh

Shared 28/06/2024

04:58

SQL — What are the Key Differences Between Primary Key and Foreign Key

Mukesh Singh

Shared 27/06/2024

06:45

PySpark - Replace Accented letters with their Non-Accented letters

Mukesh Singh

Shared 26/06/2024

06:09

Orchestration- Databricks Workflow VS Azure Data Factory

Mukesh Singh

Shared 25/06/2024

02:06

DataBricks- Delta Lake Saves Your Money in many ways

Mukesh Singh

Shared 25/06/2024

30

Babies Love💗Dogs || #animals #shorts #trending #jeenu #reels #nature #kindness #dog #love

Mukesh Singh

Shared 23/06/2024

17

💗Dogs are better than human || #shorts #animals #streetfood #dog #support #jeenu #nature #trending

Mukesh Singh

Shared 22/06/2024

08:01

DataBricks - How to load CSV Or JSON files from AWS S3 to dataframe by using PySpark

Mukesh Singh

Shared 13/06/2024

08:36

Alteryx - How to Use RegEx Tool and Formula Tool

Mukesh Singh

Shared 12/06/2024

06:47

RedShift — How to Import CSV/JSON Files into RedShift Serverless

Mukesh Singh

Shared 10/06/2024

07:37

DataBricks — Retrieve matched rows from two Dataframes or Files by Using PySpark

Mukesh Singh

Shared 06/06/2024

08:58

DataBricks — How to Find out Returning Customers within 7 days in PySpark

Mukesh Singh

Shared 05/06/2024

05:28

DataBricks — How to apply Data Cleansing in Dataframe By Using PySpark

Mukesh Singh

Shared 01/06/2024

06:59

DataBricks — How to Sum Up Multiple Columns in Dataframe By Using PySpark

Mukesh Singh

Shared 30/05/2024

07:30

DataBricks — Transpose OR Pivot OR Rows to Columns in Dataframe By Using PySpark

Mukesh Singh

Shared 29/05/2024

14:23

PySpark - How to Add Or Update Multiple Columns in Dataframe

Mukesh Singh

Shared 27/05/2024

08:12

Python - How to Update Multiple Columns in Dataframe

Mukesh Singh

Shared 25/05/2024

05:31

Python - How to Add Multiple Columns in DataFrame

Mukesh Singh

Shared 24/05/2024

14:59

AWS - Write Event-Driven Lambda Function To Read CSV Files from S3 | Easy to Go Example

Mukesh Singh

Shared 20/05/2024

12:08

NH 24 is live

Mukesh Singh

Shared 18/05/2024

08:51

AWS - How to Write Your First AWS Lambda Function | Easy to Go Example

Mukesh Singh

Shared 15/05/2024

07:39

AWS - Introduction of Lambda Function and Key Features

Mukesh Singh

Shared 14/05/2024

19:56

SSRS - How to use LookUp, LookupSet and MultiloopUp functions

Mukesh Singh

Shared 13/05/2024

03:10

Microsoft Fabric - Introduction of Lakehouse and It's Limitations

Mukesh Singh

Shared 12/05/2024

01:46

Microsoft Fabric - Quick Intro of Power BI as Business Intelligence

Mukesh Singh

Shared 12/05/2024

04:08

Microsoft Fabric - Introduction Data Science and Real-Time Analytics

Mukesh Singh

Shared 12/05/2024