IT, Techno, Auto, Bike, Money
Preparing for the Microsoft DP-800 certification? If you’re working toward the Microsoft Certified: SQL AI Developer Associate credential… Continue reading on Medium » Preparing for the Microsoft DP-800 certification? If…
I started Week 6 on Monday. By Friday I was staring at a red ❌ and a wall of error text. Continue reading on Medium » I started Week 6…
How I used SQL Server, Excel, Power Query, Power Pivot, DAX, and Power BI to explore patient access, provider performance, and revenue… Continue reading on Medium » How I used…
This week I worked with NumPy, pandas and intermediate SQL. Continue reading on Medium » This week I worked with NumPy, pandas and intermediate SQL.Continue reading on Medium » Read…
Continue reading on Medium » Continue reading on Medium » Read More MySQL on Medium #sql
I saw fews post related this questions asked in most of the interview instead of Avg() salary. So lets dive into this. Continue reading on Medium » I saw fews…
What if the problem isn’t your SQL query, but the execution plan SQL Server chooses for it? Continue reading on Dev Genius » What if the problem isn’t your SQL…
Joins are one of those topics where everyone nods along when you explain them, then freezes up the moment they have to write one on the… Continue reading on Medium…
Joins are one of those topics where everyone nods along when you explain them, then freezes up the moment they have to write one on the… Continue reading on Medium…
This week, I spent time working with NumPy, Pandas, SQL, and databases. I explored data, worked through queries, and tackled tasks that… Continue reading on Medium » This week, I…
SECTION 1: SQL Basics Continue reading on Medium » SECTION 1: SQL BasicsContinue reading on Medium » Read More Sql on Medium #sql
A conceptual review of relational databases, NoSQL systems, development tools, data connectivity, cloud platforms, and business… Continue reading on Medium » A conceptual review of relational databases, NoSQL systems, development…
Learning to explore datasets, write better SQL queries, and solve real-world or business problems using data Continue reading on Medium » Learning to explore datasets, write better SQL queries, and…
from_json quietly nulls values and drops fields. Here is how parse_json and variant_get handle the same messy payloads, with code you can… Continue reading on Medium » from_json quietly nulls…
Introduction Continue reading on Medium » IntroductionContinue reading on Medium » Read More Sql on Medium #sql
Why SQL, RAG, and agentic workflows aren’t enough to make AI analytics reliable Continue reading on AI & Analytics Diaries » Why SQL, RAG, and agentic workflows aren’t enough to…
If you’ve been following this journey, welcome back. If you’re new here: grab a cup of coffee, because Week 6 was the week I asked myself… Continue reading on Medium…
Working with arrays, DataFrames, real database queries, weather data, joins, CTEs, and debugging cloud database access in DataraFlow… Continue reading on Medium » Working with arrays, DataFrames, real database queries,…
SQL ile çalışırken verileri çoğu zaman tek bir tablodan çekmek yeterli olmaz. Örneğin, müşterilerin hangi siparişleri verdiğini… Continue reading on Medium » SQL ile çalışırken verileri çoğu zaman tek bir…
I built a query to rank customers by the number of orders they had shipped to each city in my dataset. What left me confused was that each… Continue reading…