- ----------------------------------------------------------------------------------------------------------
- SQL
- ---------------------------------------------------------------------------------------------------------
- 81 ) SQL : Constraints in sql
- 79 ) sql queries to write
- 162 ) Normalization with eg (1nf, 2nf , 3nf )
- 161 ) SSMS : Delete Duplicate Records
- 160 ) Find the 4th Highest Salary
- 159 ) ) Query to find duplicate rows of loan id...
- 158 )Find users session durations
- 155 ) SQL Query - best practices
- 154 ) SQL Concept questions
- 232 ) SQL : find sales trend
- 215 ) query : Customers Purchasing the Same Produc...
- 173 ) 14 ) Query to find duplicate rows of loan i...
- 172 ) 13 . SQL : query to show Total salary of ea...
- 171 ) 12 . show team size of each employee in t...
- 170 ) 10 ) customers Historical addresses
- 169 ) 9 ) query to find the customer who ordered m...
- 168 ) 8) Department-Wise Sum of Salaries and Max S...
- 167 ) 7) Most Sold Product by Each State
- 166 ) 6) Customers Purchasing the Same Product in ...
- 165 ) 5) SSMS - Cumulative Salary of Each Employee...
- 165 ) 4) Count Number of Subjects per Student (Com...
- 164 ) 3) Department wise -Highest Salary of Each
- ---------------------------------------------------------------------------------------------------------
- -- AZURE qsns
- ----------------------------------------------------------------------------------------------------------
- 236 ) Azure insurance migration project
- 235 ) Azure migration Problems and solutions
- 230 ) Azure project to migrate : SSMS TO AZURE CLOud
- 231 ) FAQ AZURE interview qsns
- 60 ) AZURE project based questions
- 95 ) Azure Solution Architect project
- 145 ) Which Azure features and project did you wor...
- ----------------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------------
-- AWS qsns
- ----------------------------------------------------------------------------------------------------------
- --- Challenges
- ----------------------------------------------------------------------------------------------------------
- 87 ) Pharma Data Modeling (DM) Project Challenges...
- 86 ) Food Delivery Data Modeling (DM) Project Chal...
- 85 ) Insurance model challenges
- 84 ) Challenges - Banking DM project Challenges :
- --------------------------------------------------------------------------------------------------------
- best practices
- ----------------------------------------------------------------------------------------------------------
- 83 ) Best Practices for SQL Queries
- 82 ) Best practices of Data modeling
- ----------------------------------------------------------------------------------------------------------
- Data vault
- ----------------------------------------------------------------------------------------------------------
- 80 ) Data vault modeling steps
- 216 ) Data vault qsns
- 223 ) list of core Data Vault benefits,
- 61) Data vault modeling qsns
- 123 ) Data vault FAQS
- ----------------------------------------------------------------------------------------------------------
- Project questions
- ----------------------------------------------------------------------------------------------------------
- 78 ) Hospital mgt data model project
- 77 ) waste mgt project
- 76 ) Food delivery project
- 75 ) Banking data model - explaination
- 74 ) insurance project - data model explaination
- ---------------------------------------------------------------------------------------------------------
- Optimization and tuning
- ----------------------------------------------------------------------------------------------------------
- 73 ) Sql Query optimization steps
- 72 ) Performance tuning - for oracle
- 71 ) Performance tuning for - MY SQL
- 70) Performance tuning - SQL SERVER
- 163 ) Tree of questions
- 157 ) Snowflake Administrator Interview Questions ...
- ----------------------------------------------------------------------------------------------------------
- 156 ) Why do we need Data warehouse
- ----------------------------------------------------------------------------------------------------------
- ALL QUESTIONS BLOGS
- ----------------------------------------------------------------------------------------------------------
- 229 ) If you have 500 million rows and queries fil...
- 228 ) oltp data model, enterprise data model, dime...
- 227 ) How did you design the dimensional model you...
- 226 ) How to design tables with SCDs: Applied to C...
- 225 )Data Profiling and Handling Data Anomalies (I...
- 224 ) Steps to delete a column from a table from SSMS
- 223 ) list of core Data Vault benefits,
- 222 )in medallion arch a invoice is shared as a pd...
- 221) Insurance project all tables list
- 219 ) Canonical Data Model : Life Insurance Sales
- 218 ) Explain a sample data model -for LOANS DATAB...
- index page
- 217 ) All questions post
- 216 ) Data vault qsns
- 215 ) query : Customers Purchasing the Same Produc...
- 214 ) Daily log
- 212 What is Medallion Architecture?
- 211 ) How do you calculate the size of each table
- 210) Did you work on NOSQL database
- 222 )in medallion arch a invoice is shared as a pd.. a pdf with tables .... do we save it as pdf only how to read that data later ?
- 221) Insurance project all tables list ..
- 219 ) Canonical Data Model : Life Insurance Sales
- 218 ) Explain a sample data model -for LOANS DATAB.ase..
- 212 What is Medallion Architecture?
- 211 ) How do you calculate the size of each table
- 210) Did you work on NOSQL database
- 209 Views and materialized views
- 208 ) roles of data architect and responsibilities
- 207 What are roles of data modeler
- 205 ) What are ACID Properties?
- 204 ) Which tools used for Data profiling tools ...
- 203 ) Normalization with examples and problems
- 202 ) what is use of Surrogate key is a
- 201 ) OLAP & OLTP diff
- 200 ) what is ODS( operational data store)
- 199 ) Why do we need Data warehouse, when OLTP app...
- 198 ) What is Data Mart
- 197) Types of Dimensions
- 196 ) star and snowflake
- 195 ) logical data model vs. physical data model diff
- 194 ) Grain and granularity
- 193 ) Types of Fact tables amnd facts
- 192 ) Ralph kimball & inmon approaches
- 191 )How to add a completely new metric to an exi...
- 190 ) How do you handle missing or unknown Dimensi...
- 189 ) How do you deal with duplicate records into ...
- 188 ) Additive, Semi-Additive, and Non-Additive Fact?
- 187 ) How to handle (Slowly Changing Dimensions)
- 186 ) Late arriving dims & factless fact tables
- 185 ) How to ingest fact table a weekly, monthly...
- 183 ) Data modeling excel questions
- 184 ) How to merge, add, or delete columns or add ...
- 182 ) why we need OLAP when we can query with OLTP
- 181 ) How to handle volume - Dimensional Data War...
- 180 ) Best practices
- 179 ) Project based qsns
- 178 ) Cloud qsns
- 177 ) Performance tuning qsns
- 176 ) Warehouse concepts ( pipeline , lakehouse , ...
- 175 ) Challenges you faced in DM projects
- 174 ) Dimensional modeling questions
- 152 ) Explain Gdpr & Hipaa in data governance?
- 151 ) find the employees with sal more than manager
- 150 ) Data model - Optimization
- 149 ) EDM with on (core subject areaas ) insurance...
- 148 ) ETL & ELT = when to suggest
- 147 ) Diff between Data lake and Data Lakehouse
- 147 ) Working with NO SQL Databases
- 144 ) What are ACID Properties?
- 143 ) What are Data Quality Checks?
- 142 ) Types of Dimensions
- 115 ) about my background and exp
- 141 ) Roles and Responsibilities of a Data Architect
- 140 ) Roles and Responsibilities of a Data Modeler
- 139 ) Schema comparision tools
- 138 ) Data profiling tools
- 137 ) Surrogate keys
- 136 ) Types of indexes
- 135 ) Possible Reasons for Slow SQL Queries
- 134 ) when should customer prefer - dwh tools sn...
- 133 ) compare DWH Databases - Snowflake, Synapse, ...
- 131 ) using fivetran to move data ETL from oracle/...
- 130 ) KP & RACKSPACE QSNS
- 129 ) Oracle to Redshift - Migration steps Overview
- 128 ) Cognizant qsns - 21jul26
- 127 ) Diagrams - All sample data model diagrams
- 126 ) faqs on Snowflake DB DWH
- 125 ) All FAQ ( Questions only )
- 124 ) Data modeling excel questions
- 122 ) Data governance FAQs
- 121 ) Performance tuning questions
- 120 ) ETL questions
- 119 ) Data architect training topics
- 118 ) Data architect FAQ
- 117 ) KPMG questions
- 116 ) popular data warehousing tools
- 114 ) Data model tuning to improve the tables perf...
- 113 ) how to find the - grain and granularity
- 112 ) where should we apply SCD 1 , SCD 2 , SCD 3
- 111 ) Microsoft Fabric for Data Warehousing
- 110 ) Snowflake Data Cloud
- 109 ) ER/Studio features
- 108 ) erwin Data Modeler features
- 107 ) Source to target mapping document ( STTM )
- 106 ) Data goveranance projects
- 105 ) Data lake projects
- 104 ) Data warehouse project
- 1020 ) Requirement Gathering qsns
- 101 ) DATA PROFILING
- 100 ) data lake house - databricks
- 99 ) Data lineage project
- test post
- 98 ) Data Dictionary Documentation
- 97 ) Metadata Management Solution Architect -banki...
- 94 ) Data pipeline
- 93 ) DATA MESH
- 92 ) Slowly Changing Dimensions (SCD) Types
- 91 ) Differences Between OLTP and OLAP
- 90 ) Types of Facts and Dimensions
- 89 ) How to choose Star vs. Snowflake Schema
- 88 ) Types of Data Models
- ----------------------------------------------------------------------------------------------------------
- 69 ) Data architect FAQ
- 68 ) steps for Dimensional Modeling steps
- 67) Types of Tables in Databases
- blog 59 ) converting grain to fact tables
- 21may26- Hospital Data modeling - erd
- 21may26 - all data models
- 12may26 - challenges in data modeling
- 12may26- Mistakes in data modeling
- how to join customer (scd2 ) with transaction fact...
- 29jan26 - Physical model without a Logical one?
- 25jan26 - how to do profilng in which tool and how
- 23 jan 26 - Data Modeling - ALL STEPS - With KP...
- 22jan26 - when to use snowflake model
- 22jan26 - Surrogate keys - when to use and not use
- 22jan26 - Food Delivery Business – Data Modeling f...
- 22JAN26 - Best practices for Data modeling 1
- 20JAN26 - Enterprise Data Model (EDM) Steps
- Dimensional Data Modeling Steps
- EDM vs OLTP are both the same
- 23feb26 - cab service project -data modeling project
- 23feb26 - Bus ticket : Data model
a
- Steps for Optimizing a data model
- gathering requirements for a banking dimensional d...
- How to Choose The Right Database for Your Applicat...
- ETL TESTING TRAINING - notes
- 181 ) How to handle volume - Dimensional Data Warehouse -
- 182 ) why we need OLAP when we can query with OLTP
- 184 ) How to merge, add, or delete columns or add new dimensions in data model Later
- 134 ) Types of indexes
- 212 What is Medallion Architecture?
- 211 ) How do you calculate the size of each table
- 210 Did you work on NOSQL database
- 209 Views and materialized views
- 208 ) roles of data architect and responsibilities
- 207 What are roles of data modeler
- 205 ) What are ACID Properties?
- 204 ) Which tools used for Data profiling tools ...
- 203 ) Normalization with Examples
- 202 ) what is use of Surrogate key is a
- 201 ) OLAP & OLTP diff
- 200 ) what is ODS( operational data store)
- 199 ) Why do we need Data warehouse, when OLTP app...
- 198 ) What is Data Mart
- 197) Types of Dimensions
- 196 ) star and snowflake
- 195 ) logical data model vs. physical data model diff
- 194 ) Grain and granularity
- 193 ) Types of Fact tables amnd facts
- 192 ) Ralph kimball & inmon approaches
- 191 )How to add a completely new metric to an exi...
- 190 ) How do you handle missing or unknown Dimensi...
- 189 ) How do you deal with duplicate records into ...
- 188 ) Additive, Semi-Additive, and Non-Additive Fact?
- 187 ) How to handle (Slowly Changing Dimensions)
- 186 ) Late arriving dims & factless fact tables
- 185 ) How to ingest fact table a weekly, monthly...
- Why do we need Data Warehouse
- Enterprise data modeling - Insurance project OLTP
- Types of data models
- star or snowflake schemas ( how to chose)
- Types of facts and dimensions
- OLTP & OLAP diff
- SCD types and implementation
- Experience in Metadata management MDM
- Data dictionary✅
- STTM
-------------------
- ---------------------------------------------------------------------------------------------------------
No comments:
Post a Comment