<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Zubair Siddique 🧐 on Medium]]></title>
        <description><![CDATA[Stories by Zubair Siddique 🧐 on Medium]]></description>
        <link>https://medium.com/@techbooster19?source=rss-05ab6d2d0662------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*lEBcQSjivLWOAwY7uMl2XQ.jpeg</url>
            <title>Stories by Zubair Siddique 🧐 on Medium</title>
            <link>https://medium.com/@techbooster19?source=rss-05ab6d2d0662------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 23:50:25 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@techbooster19/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[The EC2 Advantage: Transforming Healthcare Infrastructure Beyond Kubernetes]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@techbooster19/the-ec2-advantage-transforming-healthcare-infrastructure-beyond-kubernetes-6d2780e8c517?source=rss-05ab6d2d0662------2"><img src="https://cdn-images-1.medium.com/max/1314/1*hpiWodpQmgcJ9lJS5Dxk6w.png" width="1314"></a></p><p class="medium-feed-snippet">Migrating to EC2 would be a game changer to make your environment more cost effective and highly scalable with less configurations.</p><p class="medium-feed-link"><a href="https://medium.com/@techbooster19/the-ec2-advantage-transforming-healthcare-infrastructure-beyond-kubernetes-6d2780e8c517?source=rss-05ab6d2d0662------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@techbooster19/the-ec2-advantage-transforming-healthcare-infrastructure-beyond-kubernetes-6d2780e8c517?source=rss-05ab6d2d0662------2</link>
            <guid isPermaLink="false">https://medium.com/p/6d2780e8c517</guid>
            <category><![CDATA[aws]]></category>
            <category><![CDATA[iaac]]></category>
            <category><![CDATA[ec2]]></category>
            <category><![CDATA[cloud-services]]></category>
            <category><![CDATA[kubernetes]]></category>
            <dc:creator><![CDATA[Zubair Siddique ]]></dc:creator>
            <pubDate>Mon, 17 Feb 2025 04:48:52 GMT</pubDate>
            <atom:updated>2025-02-17T04:48:52.105Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Creating and Packaging The Conda Virtual Environment]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@techbooster19/creating-and-packaging-the-conda-virtual-environment-a85cb5f6834f?source=rss-05ab6d2d0662------2"><img src="https://cdn-images-1.medium.com/max/600/1*4WV4WcCET9KV0ACf0_CxNA.png" width="600"></a></p><p class="medium-feed-snippet">Is your virtual environment is shareable&#xA0;? Check this out&#xA0;..</p><p class="medium-feed-link"><a href="https://medium.com/@techbooster19/creating-and-packaging-the-conda-virtual-environment-a85cb5f6834f?source=rss-05ab6d2d0662------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@techbooster19/creating-and-packaging-the-conda-virtual-environment-a85cb5f6834f?source=rss-05ab6d2d0662------2</link>
            <guid isPermaLink="false">https://medium.com/p/a85cb5f6834f</guid>
            <category><![CDATA[anaconda]]></category>
            <category><![CDATA[python-programming]]></category>
            <category><![CDATA[conda-environment]]></category>
            <category><![CDATA[virtual-environment]]></category>
            <category><![CDATA[packaging]]></category>
            <dc:creator><![CDATA[Zubair Siddique ]]></dc:creator>
            <pubDate>Mon, 10 Feb 2025 19:36:08 GMT</pubDate>
            <atom:updated>2025-02-10T19:36:08.211Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[The DML Operations You Know In Snowflake]]></title>
            <link>https://medium.com/@techbooster19/the-dml-operations-you-know-in-snowflake-40b8a5d1eb6a?source=rss-05ab6d2d0662------2</link>
            <guid isPermaLink="false">https://medium.com/p/40b8a5d1eb6a</guid>
            <category><![CDATA[snowflake]]></category>
            <category><![CDATA[database-development]]></category>
            <category><![CDATA[snowflake-data-cloud]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Zubair Siddique ]]></dc:creator>
            <pubDate>Sat, 08 Feb 2025 22:07:26 GMT</pubDate>
            <atom:updated>2025-02-08T22:07:26.654Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PztwnX65Dlu6nL11wwKYUQ.png" /></figure><p>You want to update something or fix which you forgot to do.<br>Let me help you understand the key <strong>Data Manipulation Language (DML)</strong> operations in Snowflake by breaking them down with practical examples and explanations.</p><p><strong>INSERT Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/484/1*mlFXGzXphxPqlcVNL38mPw.png" /><figcaption>Insert Operations Types</figcaption></figure><p>— This is how we add new data to tables<br> — The basic INSERT adds one row at a time<br> — Multi-row INSERT is more efficient for bulk operations<br> — You can also INSERT data from other tables using SELECT</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/335/1*18tMptOw_k8I1ZDgDcF3Ug.png" /><figcaption>Pros and Cons of using Insert DML</figcaption></figure><pre>-- INSERT Operations<br>-- Basic single row insert<br>INSERT INTO employees (employee_id, first_name, last_name, hire_date)<br>VALUES (1, &#39;John&#39;, &#39;Doe&#39;, CURRENT_DATE());<br><br>-- Multi-row insert<br>INSERT INTO employees (employee_id, first_name, last_name, hire_date)<br>VALUES <br>    (2, &#39;Jane&#39;, &#39;Smith&#39;, CURRENT_DATE()),<br>    (3, &#39;Bob&#39;, &#39;Johnson&#39;, CURRENT_DATE());<br><br>-- Insert from another table (using SELECT)<br>INSERT INTO active_employees<br>SELECT * FROM employees <br>WHERE status = &#39;ACTIVE&#39;;</pre><p><strong>UPDATE Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/896/1*dWjYu3VLlFHR5tW084oAIg.png" /><figcaption>Update Operations</figcaption></figure><p>— Used to modify existing data<br> — Can update single or multiple columns<br> — Supports complex conditions and calculations<br> — Can use subqueries to get update values</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/416/1*3Vw1M65m8DmrKgoa7oAztQ.png" /></figure><pre>-- UPDATE Operations<br>-- Basic update<br>UPDATE employees <br>SET salary = 50000<br>WHERE employee_id = 1;<br><br>-- Update with calculated values<br>UPDATE employees <br>SET salary = salary * 1.10<br>WHERE department = &#39;Sales&#39;<br>AND performance_rating &gt; 4;<br><br>-- Update using subquery<br>UPDATE employees e<br>SET department_name = (<br>    SELECT department_name <br>    FROM departments d <br>    WHERE d.department_id = e.department_id<br>);</pre><p><strong>DELETE Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/346/1*ZWAAQsy7edvzO2aKUddvwQ.png" /><figcaption>Deletion requires attention</figcaption></figure><p>— Removes rows from tables<br> — Can delete based on conditions<br> — Supports subqueries in WHERE clause<br> — Complete table deletion (alternative to TRUNCATE)</p><pre>-- DELETE Operations<br>-- Basic delete<br>DELETE FROM employees<br>WHERE employee_id = 1;<br><br>-- Delete with subquery<br>DELETE FROM employees<br>WHERE department_id IN (<br>    SELECT department_id <br>    FROM departments <br>    WHERE location = &#39;New York&#39;<br>);<br><br>-- Delete all records (truncate alternative)<br>DELETE FROM employees;</pre><p><strong>MERGE Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/537/1*A5mseslSZUilnd0AlQ5wWg.png" /><figcaption>Know Merge Better</figcaption></figure><p>— Combines INSERT, UPDATE, and DELETE in one statement<br> — Useful for synchronizing tables<br> — Can handle complex business logic<br> — More efficient than separate operations</p><pre>-- MERGE Operations<br>MERGE INTO target_employees t<br>USING source_employees s<br>ON t.employee_id = s.employee_id<br>WHEN MATCHED AND t.salary &lt; s.salary THEN<br>    UPDATE SET t.salary = s.salary,<br>               t.last_updated = CURRENT_TIMESTAMP()<br>WHEN NOT MATCHED THEN<br>    INSERT (employee_id, first_name, last_name, salary, hire_date)<br>    VALUES (s.employee_id, s.first_name, s.last_name, s.salary, s.hire_date);</pre><p><strong>COPY Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/596/1*Hwf18c2g8xurJ0J2cdHa0g.png" /><figcaption>Copy Operations</figcaption></figure><p>— Bulk loads data from external sources<br> — Supports various file formats<br> — Can handle errors gracefully<br> — More efficient than INSERT for large datasets</p><pre>-- COPY Operations<br>-- Copy data into table from stage<br>COPY INTO employees<br>FROM @my_stage/employee_data<br>FILE_FORMAT = (TYPE = CSV)<br>ON_ERROR = CONTINUE;</pre><p><strong>TRUNCATE Operation</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/543/1*qTMRi_E35SZViIAnOM619g.png" /><figcaption>Truncate vs Delete</figcaption></figure><p>— Quickly removes all rows from a table<br> — Cannot be rolled back<br> — Doesn’t trigger row-level triggers<br> — More efficient than DELETE for full table cleanup</p><pre>-- TRUNCATE Operation<br>TRUNCATE TABLE employees;</pre><p><strong>Advanced Operations</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/417/1*rAs6goSRrKZlopZP351Qag.png" /><figcaption>Advance Operations</figcaption></figure><p>— Conditional logic using CASE<br> — Multi-table operations<br> — Window functions<br> — Complex MERGE scenarios</p><pre>-- Advanced Operations<br>-- Conditional Insert using CASE<br>INSERT INTO employee_bonuses (employee_id, bonus_amount)<br>SELECT <br>    employee_id,<br>    CASE <br>        WHEN performance_rating = 5 THEN salary * 0.15<br>        WHEN performance_rating = 4 THEN salary * 0.10<br>        ELSE salary * 0.05<br>    END as bonus_amount<br>FROM employees<br>WHERE status = &#39;ACTIVE&#39;;<br><br>-- Multi-table Update<br>UPDATE employees e<br>SET salary = salary * 1.15<br>FROM performance_reviews p<br>WHERE e.employee_id = p.employee_id<br>AND p.rating &gt; 4<br>AND p.review_date &gt;= DATEADD(month, -6, CURRENT_DATE());<br><br>-- Bulk Delete with Window Functions<br>DELETE FROM sales<br>WHERE sale_id IN (<br>    SELECT sale_id<br>    FROM (<br>        SELECT <br>            sale_id,<br>            ROW_NUMBER() OVER (PARTITION BY customer_id <br>                              ORDER BY sale_date DESC) as rn<br>        FROM sales<br>    )<br>    WHERE rn &gt; 10  -- Keep only last 10 sales per customer<br>);<br><br>-- MERGE with Multiple Actions and Conditions<br>MERGE INTO employee_status t<br>USING (<br>    SELECT <br>        e.employee_id,<br>        e.status,<br>        p.performance_score,<br>        s.salary<br>    FROM employees e<br>    JOIN performance p ON e.employee_id = p.employee_id<br>    JOIN salaries s ON e.employee_id = s.employee_id<br>) s<br>ON t.employee_id = s.employee_id<br>WHEN MATCHED <br>    AND s.performance_score &lt; 3 <br>    AND s.salary &gt; 100000 THEN<br>    UPDATE SET <br>        status = &#39;REVIEW_NEEDED&#39;,<br>        last_updated = CURRENT_TIMESTAMP()<br>WHEN MATCHED <br>    AND s.performance_score &gt; 4 <br>    AND s.salary &lt; 50000 THEN<br>    UPDATE SET <br>        status = &#39;PROMOTION_REVIEW&#39;,<br>        last_updated = CURRENT_TIMESTAMP()<br>WHEN NOT MATCHED THEN<br>    INSERT (employee_id, status, last_updated)<br>    VALUES (s.employee_id, &#39;NEW&#39;, CURRENT_TIMESTAMP());</pre><p><strong><em>Some key points to remember</em></strong></p><p><strong>1. Performance Considerations:</strong><br> — Use multi-row INSERT over single-row when possible<br> — MERGE is more efficient than separate DML operations<br> — TRUNCATE is faster than DELETE for full table cleanup</p><p><strong>2. Transaction Management:</strong><br> — All these operations (except TRUNCATE) can be rolled back<br> — They can be part of larger transactions<br> — They maintain data consistency</p><p><strong>3. Best Practices:</strong><br> — Always use WHERE clauses with UPDATE and DELETE<br> — Test complex MERGE statements thoroughly<br> — Consider using COPY for large data loads</p><p>Thanks for reading this blog. Please follow me for more in depth reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=40b8a5d1eb6a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>