<![CDATA[SQL Explained - Medium]]> https://medium.com/sql-explained?source=rss----2d48444cb72e---4 https://cdn-images-1.medium.com/proxy/1*TGH72Nnw24QL3iV9IOm4VA.png SQL Explained - Medium https://medium.com/sql-explained?source=rss----2d48444cb72e---4 Medium Sun, 24 May 2026 02:12:12 GMT <![CDATA[Stored Procedures for Data Engineers & SQL Developers]]>

Stored Procedures

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/stored-procedures-for-data-engineers-sql-developers-6bc7a6198900?source=rss----2d48444cb72e---4 https://medium.com/p/6bc7a6198900 Fri, 24 Oct 2025 17:32:20 GMT 2025-10-24T17:32:17.138Z <![CDATA[Advanced SQL Tutorial Part 5 — SQL PIVOTING ]]>

Pivoting involves rotating a table by converting unique values from a single column into multiple columns. This rearrangement turns rows…

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/advanced-sql-tutorial-part-5-sql-pivoting-7d949fced317?source=rss----2d48444cb72e---4 https://medium.com/p/7d949fced317 Sat, 04 Oct 2025 19:40:38 GMT 2025-10-04T19:40:34.729Z <![CDATA[Advanced SQL Tutorial Part 4 — SELF JOINS & SQL SET OPERATIONS]]>

SQL SELF-JOINS 🤝 SQL UNION 🙏

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/advanced-sql-tutorial-part-4-8514a3e72ab8?source=rss----2d48444cb72e---4 https://medium.com/p/8514a3e72ab8 Thu, 11 Sep 2025 20:08:34 GMT 2025-09-11T20:09:09.943Z <![CDATA[Advanced SQL Tutorial : CTE vs Subquery]]>

CTE vs. SUBQUERY

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/advanced-sql-tutorial-cte-vs-subquery-a1328de1d788?source=rss----2d48444cb72e---4 https://medium.com/p/a1328de1d788 Tue, 09 Sep 2025 19:02:35 GMT 2025-09-09T19:06:20.527Z <![CDATA[Intermediate SQL Topics-Part 6]]>

SQL JOINS ⚙️,DATE FUNCTIONS 📅

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-6-d4f5cd9f8d25?source=rss----2d48444cb72e---4 https://medium.com/p/d4f5cd9f8d25 Tue, 27 May 2025 18:10:14 GMT 2025-05-27T18:10:14.001Z <![CDATA[Intermediate SQL Topics-Part 5]]>

SQL CASE 💼, SQL NULL 🚫

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-5-ffa92f6b536b?source=rss----2d48444cb72e---4 https://medium.com/p/ffa92f6b536b Mon, 26 May 2025 17:12:37 GMT 2025-05-27T12:02:26.454Z <![CDATA[Intermediate SQL Topics-Part 4 ]]>

SQL Math Functions: ABS, CEIL, FLOOR, ROUND Examples MATH FUNCTIONS

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-4-6f3bc903512e?source=rss----2d48444cb72e---4 https://medium.com/p/6f3bc903512e Sun, 25 May 2025 22:28:59 GMT 2025-05-25T22:28:59.742Z <![CDATA[Intermediate SQL Topics-Part 3⭐‍♀️]]>

SQL DISTINCT , SQL Arithmetic Operators , SQL arithmetic Functions

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-3-%EF%B8%8F-2fccd38b181c?source=rss----2d48444cb72e---4 https://medium.com/p/2fccd38b181c Sat, 26 Apr 2025 19:38:03 GMT 2025-04-26T19:38:03.368Z <![CDATA[Intermediate SQL Topics-Part 2]]>

SQL Group BY and HAVING

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-2-3f99585b0548?source=rss----2d48444cb72e---4 https://medium.com/p/3f99585b0548 Thu, 17 Apr 2025 06:56:21 GMT 2025-04-17T06:56:21.384Z <![CDATA[Intermediate SQL Topics-Part 1 ⚙‍♀️]]>

SQL Aggregate Functions ⚙️📊

Continue reading on SQL Explained »

]]> https://medium.com/sql-explained/intermediate-sql-topics-part-1-%EF%B8%8F-dac0de7d6290?source=rss----2d48444cb72e---4 https://medium.com/p/dac0de7d6290 Wed, 16 Apr 2025 20:32:16 GMT 2025-04-17T06:56:50.857Z