#sqltips — Public Fediverse posts

Day – 89 | Data Analyst Interview: SQL Problem Solving & Common Questions #azure #sqltips #coding

Master the most asked Data Engineer interview ... source

https://quadexcel.com/wp/day-89-data-analyst-interview-sql-problem-solving-common-questions-azure-sqltips-coding/

Day – 53 | Data Analyst Interview: SQL Problem Solving & Common Questions #azure #sqltips #coding

Master the most asked Data Engineer interview questions with real-world SQL problem solving. This series is perfect for preparing ... source

https://quadexcel.com/wp/day-53-data-analyst-interview-sql-problem-solving-common-questions-azure-sqltips-coding/

Writing SQL queries is easy — but understanding their execution order is what separates good analysts from great ones.

SQL doesn’t run top to bottom; it follows a logical order — FROM → JOIN → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT.

Master this flow to debug, optimize, and write smarter queries.

📕 ebokify.com/data-analysis

#SQL #DataAnalytics #Database #DataEngineering #LearnSQL #BusinessIntelligence #Analytics #SQLTips

SQL Anti-Patterns You Should Avoid

https://datamethods.substack.com/p/sql-anti-patterns-you-should-avoid

#HackerNews #SQL #AntiPatterns #DataManagement #BestPractices #SoftwareDevelopment #DatabaseDesign #SQLTips

SQL Anti-Patterns You Should Avoid

https://datamethods.substack.com/p/sql-anti-patterns-you-should-avoid

#HackerNews #SQL #AntiPatterns #DataManagement #BestPractices #SoftwareDevelopment #DatabaseDesign #SQLTips

SQL Anti-Patterns You Should Avoid

https://datamethods.substack.com/p/sql-anti-patterns-you-should-avoid

#HackerNews #SQL #AntiPatterns #DataManagement #BestPractices #SoftwareDevelopment #DatabaseDesign #SQLTips

SQL Anti-Patterns You Should Avoid

https://datamethods.substack.com/p/sql-anti-patterns-you-should-avoid

#HackerNews #SQL #AntiPatterns #DataManagement #BestPractices #SoftwareDevelopment #DatabaseDesign #SQLTips

What is SQL? #dataanlysis #sql #sqltips #tipsandtricks

source

https://quadexcel.com/wp/what-is-sql-dataanlysis-sql-sqltips-tipsandtricks/

SQL queries don't start with SELECT (2019)

https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/

#HackerNews #SQLQueries #SQLTips #DatabaseProgramming #TechBlog #DataAnalysis

SQL queries don't start with SELECT (2019)

https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/

#HackerNews #SQLQueries #SQLTips #DatabaseProgramming #TechBlog #DataAnalysis

SQL queries don't start with SELECT (2019)

https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/

#HackerNews #SQLQueries #SQLTips #DatabaseProgramming #TechBlog #DataAnalysis

SQL queries don't start with SELECT (2019)

https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/

#HackerNews #SQLQueries #SQLTips #DatabaseProgramming #TechBlog #DataAnalysis

Unleash your inner SQL wizard with FromSql in EF Core!
Need raw SQL power but love EF Core? FromSql lets you write handcrafted SQL like a boss while keeping all the ORM goodness.

Learn how: https://woodruff.dev/fromsql-writing-sql-like-a-boss-in-ef-core/

#EFCore #dotnet #SQLTips #DeveloperTools

Check out these 2 queries:

Query 1:

SELECT ...
FROM t1
JOIN t2 ON t1.id IN (t2.id1, t2.id2);

Query 2:

SELECT ...
FROM t1
JOIN t2 ON t1.id = t2.id1
UNION
SELECT ...
FROM t1
JOIN t2 ON t1.id = t2.id2;

They both return the same data but since most database engines struggle with OR joins, the latter will outperform the former by at least an order of magnitude.

#SQLTips #DatabaseOptimization #PerformanceTuning