Mukesh Singh

@sql-datatools

Approx 14+ years of experience in all aspects of database design, web development, ETL, SSIS, SSRS, SSAS, MDX, OLAP and OLTP, Data Warehouse with SQL Server (all versions) and Azure SQL database. SSRS integration with SharePoint Server, Tableau, and Power BI. Good understanding on big data by using Hadoop and Python. Data Integrations with Talend and Pentaho. NoSQL with MongoDB.

269 posts

😍Ganpati Bappa Morya😅#ganpati #ganpatibappamorya #shorts #trending #jeenu #love #ganesh #love #like

Cute baby 🤣🫠🥰 #jeenu #shorts #tiktok #cutebaby #trending #baby #cute #lo...

भारत के शेरनी बॉक्सिंग चैंपियन दिवेश फोकट #trending #jeenu #shorts #indi... #Olympics2024Paris #Olympics2024Paris

🔱भोलेनाथ❤️भोले राम राम रे🔱#shorts #jeenu #trending #shiv #reels #bholen...

❤️मैं अव्दूत दर्शनी बाबा🔱रंग रूप देख के डर जागी🚩#shorts #jeenu #trending...

🌙जय शिव शम्भू🚩हरिद्वार❤️रेल चले से भोले की🚩#bhole #live #shorts #jeenu #...

🚩बोल बम बम भोले ❤️हर हर महादेव🚩कावड़ यात्रा❤️#bhole #live #kawadyatra #s...

❤️जय बाबा की❤️हर हर महादेव❤️कावड़ यात्रा 2024❤️#bhole #kawad #kawadyatra...

❤️जय भोले की❤️हर हर महादेव❤️कावड़ यात्रा 2024❤️#bhole #kawad #kawadyatra...

Top 5 Interview Questions for SQL Data Warehousing

Please keep in mind that these questions cover key concepts in SQL Data Warehouse design and implementation, including schema design, data modeling, and data aggregation.

#data #datascience #bigdata #datawarehouse #database #starschema #datamodeling #dataengineering #digital

SQL - How to Use Rollup Operator to Calculate SubTotal and GrandTotal

As we know, ROLLUP is an extension of the SQL GROUP BY clause, used to generate summary reports with subtotals and grand totals. It helps in aggregating data at multiple levels of granularity.

#sql #datascience #data #database #tsql #dataengineering #bigdata #database #datamodeling #snowflake #programming

SQL Interview Questions — High Cardinality Vs Low Cardinality

In SQL, understanding the cardinality of columns is crucial for database design and query optimization. High cardinality columns are ideal candidates for indexing, while low cardinality columns might not benefit as much from indexing but can be useful for categorical data analysis.

#data #datascience #datawarehouse #sql #tsql #dataengineering #dataanalytics #database #learning #programming #ai #ml #bigdata #azure #aws #gcp

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

Databricks - What are Materialized Views || Speed up your Lakeview dashb...

PySpark - Replace Accented letters with their Non-Accented letters

Orchestration- Databricks Workflow VS Azure Data Factory

DataBricks- Delta Lake Saves Your Money in many ways

Mukesh Singh @sql-datatools - Tumblr Blog | Tumgag