<?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 KAUSTAV MONI BASUMATARY on Medium]]></title>
        <description><![CDATA[Stories by KAUSTAV MONI BASUMATARY on Medium]]></description>
        <link>https://medium.com/@engorgia?source=rss-79c4aa6f9399------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*_d49lbNYqTNFID9L8ZVvVw.jpeg</url>
            <title>Stories by KAUSTAV MONI BASUMATARY on Medium</title>
            <link>https://medium.com/@engorgia?source=rss-79c4aa6f9399------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 09:52:53 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@engorgia/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 Ultimate PostgreSQL SQL Revision Sheet for Data Engineer Interviews (5 YOE)]]></title>
            <link>https://engorgia.medium.com/the-ultimate-postgresql-sql-revision-sheet-for-data-engineer-interviews-5-yoe-fd18bcb07831?source=rss-79c4aa6f9399------2</link>
            <guid isPermaLink="false">https://medium.com/p/fd18bcb07831</guid>
            <dc:creator><![CDATA[KAUSTAV MONI BASUMATARY]]></dc:creator>
            <pubDate>Tue, 26 May 2026 18:13:19 GMT</pubDate>
            <atom:updated>2026-05-26T18:16:24.279Z</atom:updated>
            <content:encoded><![CDATA[<p>Complete SQL revision guide for Data Engineers preparing for product-based companies, startups, and big-tech interviews.</p><h3>Introduction</h3><p>If you have around <strong>5 years of experience as a Data Engineer</strong>, SQL interviews are no longer about basic SELECT queries.</p><p>Interviewers expect you to:</p><ul><li>write production-quality SQL</li><li>solve analytical problems quickly</li><li>optimize queries</li><li>understand execution plans</li><li>work with event streams</li><li>handle large-scale datasets</li><li>think like a warehouse engineer</li></ul><p>This article is a compact but comprehensive PostgreSQL SQL revision sheet covering the most important concepts required for Data Engineer interviews.</p><h3>1. SQL Query Execution Order</h3><p>Most candidates know syntax. Fewer understand execution order.</p><pre>SELECT name, COUNT(*)<br>FROM employees<br>WHERE salary &gt; 50000<br>GROUP BY name<br>HAVING COUNT(*) &gt; 1<br>ORDER BY name;</pre><p>Actual execution order:</p><pre>FROM<br>WHERE<br>GROUP BY<br>HAVING<br>SELECT<br>ORDER BY<br>LIMIT</pre><p>This explains:</p><ul><li>why aliases cannot be used in WHERE</li><li>why aggregation works only after grouping</li><li>why HAVING exists</li></ul><h3>2. Filtering Data</h3><h3>WHERE Clause</h3><pre>SELECT *<br>FROM employees<br>WHERE salary &gt; 100000;</pre><h3>IN Operator</h3><pre>WHERE department IN (&#39;HR&#39;, &#39;IT&#39;, &#39;Finance&#39;)</pre><h3>BETWEEN</h3><pre>WHERE salary BETWEEN 50000 AND 100000</pre><h3>LIKE vs ILIKE</h3><pre>WHERE name LIKE &#39;A%&#39;<br>WHERE name ILIKE &#39;john%&#39;</pre><p>ILIKE is PostgreSQL-specific and case-insensitive.</p><h3>NULL Handling</h3><pre>WHERE manager_id IS NULL<br>WHERE manager_id IS NOT NULL</pre><p>Never use:</p><pre>WHERE manager_id = NULL</pre><h3>3. CASE WHEN</h3><p>One of the most important SQL patterns.</p><pre>SELECT<br>    employee_id,<br>    CASE<br>        WHEN salary &gt; 100000 THEN &#39;High&#39;<br>        WHEN salary &gt; 50000 THEN &#39;Medium&#39;<br>        ELSE &#39;Low&#39;<br>    END AS salary_band<br>FROM employees;</pre><p>Used heavily in:</p><ul><li>transformations</li><li>categorization</li><li>KPIs</li><li>reporting</li><li>feature engineering</li></ul><h3>4. Joins</h3><p>Joins are foundational.</p><h3>INNER JOIN</h3><pre>SELECT *<br>FROM orders o<br>JOIN customers c<br>ON o.customer_id = c.customer_id;</pre><p>Returns matching records only.</p><h3>LEFT JOIN</h3><pre>SELECT *<br>FROM customers c<br>LEFT JOIN orders o<br>ON c.customer_id = o.customer_id;</pre><p>Keeps all left-side rows.</p><h3>FULL OUTER JOIN</h3><pre>SELECT *<br>FROM a<br>FULL OUTER JOIN b<br>ON a.id = b.id;</pre><h3>SELF JOIN</h3><pre>SELECT<br>    e.employee_name,<br>    m.employee_name AS manager<br>FROM employees e<br>LEFT JOIN employees m<br>ON e.manager_id = m.employee_id;</pre><h3>5. Aggregations</h3><h3>GROUP BY</h3><pre>SELECT<br>    department,<br>    COUNT(*) AS total_employees,<br>    AVG(salary) AS avg_salary<br>FROM employees<br>GROUP BY department;</pre><h3>HAVING</h3><pre>SELECT department<br>FROM employees<br>GROUP BY department<br>HAVING COUNT(*) &gt; 10;</pre><p>Difference:</p><ul><li>WHERE filters rows</li><li>HAVING filters groups</li></ul><h3>6. Window Functions (Most Important Topic)</h3><p>Window functions are heavily tested in Data Engineer interviews.</p><p>If you master this section, you outperform most candidates.</p><h3>ROW_NUMBER()</h3><pre>SELECT *,<br>       ROW_NUMBER() OVER (<br>           PARTITION BY department<br>           ORDER BY salary DESC<br>       ) AS rn<br>FROM employees;</pre><p>Used for:</p><ul><li>deduplication</li><li>latest records</li><li>top-N problems</li></ul><h3>RANK vs DENSE_RANK</h3><pre>RANK()<br>DENSE_RANK()</pre><p>Example:</p><p>SalaryRankDense Rank10011100119032</p><h3>LAG() and LEAD()</h3><pre>SELECT<br>    employee_id,<br>    salary,<br>    LAG(salary) OVER (<br>        ORDER BY joining_date<br>    ) AS previous_salary<br>FROM employees;</pre><p>Critical for:</p><ul><li>fraud detection</li><li>repeated events</li><li>time-series analysis</li><li>sessionization</li><li>trend comparison</li></ul><h3>Running Totals</h3><pre>SELECT<br>    order_date,<br>    amount,<br>    SUM(amount) OVER (<br>        ORDER BY order_date<br>    ) AS running_total<br>FROM orders;</pre><h3>Moving Average</h3><pre>SELECT<br>    sale_date,<br>    AVG(sales) OVER (<br>        ORDER BY sale_date<br>        ROWS BETWEEN 6 PRECEDING AND CURRENT ROW<br>    ) AS moving_avg<br>FROM sales;</pre><h3>7. Common Table Expressions (CTEs)</h3><p>CTEs improve readability.</p><h3>Basic CTE</h3><pre>WITH high_salary AS (<br>    SELECT *<br>    FROM employees<br>    WHERE salary &gt; 100000<br>)</pre><pre>SELECT *<br>FROM high_salary;</pre><h3>Multiple CTEs</h3><pre>WITH a AS (<br>    ...<br>),<br>b AS (<br>    ...<br>)</pre><pre>SELECT *<br>FROM b;</pre><h3>8. Subqueries</h3><h3>Scalar Subquery</h3><pre>SELECT *<br>FROM employees<br>WHERE salary &gt; (<br>    SELECT AVG(salary)<br>    FROM employees<br>);</pre><h3>EXISTS</h3><pre>SELECT *<br>FROM customers c<br>WHERE EXISTS (<br>    SELECT 1<br>    FROM orders o<br>    WHERE c.customer_id = o.customer_id<br>);</pre><p>EXISTS is often faster than IN for large datasets.</p><h3>9. Set Operations</h3><h3>UNION</h3><p>Removes duplicates.</p><pre>SELECT city FROM customers<br>UNION<br>SELECT city FROM suppliers;</pre><h3>UNION ALL</h3><p>Keeps duplicates and is faster.</p><pre>UNION ALL</pre><h3>INTERSECT</h3><pre>SELECT id FROM a<br>INTERSECT<br>SELECT id FROM b;</pre><h3>EXCEPT</h3><pre>SELECT id FROM a<br>EXCEPT<br>SELECT id FROM b;</pre><h3>10. Date &amp; Time Functions</h3><p>Extremely important for Data Engineers.</p><h3>Current Timestamp</h3><pre>CURRENT_DATE<br>NOW()<br>CURRENT_TIMESTAMP</pre><h3>Date Arithmetic</h3><pre>SELECT NOW() - INTERVAL &#39;7 days&#39;;</pre><h3>DATE_TRUNC()</h3><pre>SELECT DATE_TRUNC(&#39;month&#39;, order_date)<br>FROM orders;</pre><p>Common granularities:</p><ul><li>day</li><li>week</li><li>month</li><li>quarter</li><li>year</li></ul><h3>EXTRACT()</h3><pre>SELECT EXTRACT(YEAR FROM order_date);</pre><h3>11. String Functions</h3><pre>UPPER(name)<br>LOWER(name)<br>TRIM(name)<br>LENGTH(name)<br>SUBSTRING(name, 1, 3)<br>REPLACE(name, &#39;a&#39;, &#39;b&#39;)</pre><h3>12. NULL Handling</h3><h3>COALESCE()</h3><pre>SELECT COALESCE(phone, &#39;NA&#39;)<br>FROM customers;</pre><h3>NULLIF()</h3><pre>NULLIF(a, b)</pre><h3>13. PostgreSQL FILTER Clause</h3><p>A powerful PostgreSQL-specific feature.</p><pre>SELECT<br>    COUNT(*) FILTER (WHERE gender = &#39;M&#39;) AS male_count,<br>    COUNT(*) FILTER (WHERE gender = &#39;F&#39;) AS female_count<br>FROM employees;</pre><p>Cleaner than multiple CASE WHEN statements.</p><h3>14. Pivoting Data</h3><p>Classic interview problem.</p><pre>SELECT<br>    product_id,<br>    SUM(sales) FILTER (WHERE month=&#39;Jan&#39;) AS jan_sales,<br>    SUM(sales) FILTER (WHERE month=&#39;Feb&#39;) AS feb_sales<br>FROM sales<br>GROUP BY product_id;</pre><h3>15. JSON Functions (Very Important)</h3><p>Modern Data Engineering heavily uses semi-structured data.</p><h3>Extract JSON Fields</h3><pre>SELECT data-&gt;&gt;&#39;name&#39;<br>FROM users;</pre><h3>Build JSON Objects</h3><pre>SELECT json_build_object(<br>    &#39;name&#39;, name,<br>    &#39;salary&#39;, salary<br>)<br>FROM employees;</pre><h3>JSON Aggregation</h3><pre>SELECT json_agg(name)<br>FROM employees;</pre><h3>16. Arrays in PostgreSQL</h3><pre>ARRAY[1,2,3]</pre><h3>UNNEST()</h3><pre>SELECT unnest(ARRAY[1,2,3]);</pre><h3>17. Temporary Tables</h3><pre>CREATE TEMP TABLE temp_sales AS<br>SELECT *<br>FROM sales;</pre><p>Useful in:</p><ul><li>ETL pipelines</li><li>debugging</li><li>staging transformations</li></ul><h3>18. Views and Materialized Views</h3><h3>View</h3><pre>CREATE VIEW sales_view AS<br>SELECT *<br>FROM sales;</pre><h3>Materialized View</h3><pre>CREATE MATERIALIZED VIEW mv_sales AS<br>SELECT *<br>FROM sales;</pre><p>Refresh manually:</p><pre>REFRESH MATERIALIZED VIEW mv_sales;</pre><h3>19. Indexes (Critical for 5 YOE)</h3><h3>Create Index</h3><pre>CREATE INDEX idx_orders_customer<br>ON orders(customer_id);</pre><h3>Composite Index</h3><pre>CREATE INDEX idx_multi<br>ON orders(customer_id, order_date);</pre><h3>EXPLAIN ANALYZE</h3><pre>EXPLAIN ANALYZE<br>SELECT *<br>FROM orders<br>WHERE customer_id = 101;</pre><p>Understand:</p><ul><li>Seq Scan</li><li>Index Scan</li><li>Hash Join</li><li>Nested Loop</li><li>Bitmap Heap Scan</li></ul><h3>20. Partitioning</h3><p>Major Data Engineering topic.</p><pre>CREATE TABLE sales (<br>    id INT,<br>    sale_date DATE<br>)<br>PARTITION BY RANGE (sale_date);</pre><p>Benefits:</p><ul><li>faster queries</li><li>partition pruning</li><li>easier archival</li></ul><h3>21. UPSERT</h3><p>Very common ETL requirement.</p><pre>INSERT INTO employees(id, name)<br>VALUES (1, &#39;John&#39;)<br>ON CONFLICT (id)<br>DO UPDATE<br>SET name = EXCLUDED.name;</pre><h3>22. Transactions</h3><pre>BEGIN;</pre><pre>UPDATE accounts<br>SET balance = balance - 100<br>WHERE id = 1;</pre><pre>COMMIT;</pre><p>Rollback:</p><pre>ROLLBACK;</pre><h3>23. Constraints</h3><pre>PRIMARY KEY<br>FOREIGN KEY<br>UNIQUE<br>NOT NULL<br>CHECK<br>DEFAULT</pre><h3>24. Advanced SQL Patterns</h3><p>These differentiate senior candidates.</p><h3>Deduplication</h3><pre>SELECT *<br>FROM (<br>    SELECT *,<br>           ROW_NUMBER() OVER (<br>               PARTITION BY user_id<br>               ORDER BY updated_at DESC<br>           ) AS rn<br>    FROM users<br>) t<br>WHERE rn = 1;</pre><h3>Top-N Per Group</h3><pre>ROW_NUMBER()<br>RANK()<br>DENSE_RANK()</pre><h3>Sessionization</h3><p>Uses:</p><ul><li>LAG()</li><li>timestamps</li><li>conditional grouping</li></ul><p>Very common in analytics companies.</p><h3>Gaps and Islands</h3><p>Advanced but frequently asked.</p><p>Used for:</p><ul><li>consecutive login streaks</li><li>uptime analysis</li><li>event grouping</li></ul><h3>25. PostgreSQL-Specific Features</h3><h3>DISTINCT ON</h3><p>Very important PostgreSQL feature.</p><pre>SELECT DISTINCT ON (customer_id)<br>*<br>FROM orders<br>ORDER BY customer_id, order_date DESC;</pre><p>Gets latest row per customer.</p><h3>FILTER Clause</h3><pre>COUNT(*) FILTER (WHERE status=&#39;active&#39;)</pre><h3>GENERATED AS IDENTITY</h3><p>Preferred over SERIAL.</p><pre>id BIGINT GENERATED ALWAYS AS IDENTITY</pre><h3>26. Data Warehousing Concepts</h3><p>Expected for Data Engineer roles.</p><h3>Fact vs Dimension Tables</h3><h3>Fact Table</h3><p>Contains:</p><ul><li>metrics</li><li>transactions</li><li>measures</li></ul><p>Examples:</p><ul><li>orders</li><li>clicks</li><li>payments</li></ul><h3>Dimension Table</h3><p>Contains:</p><ul><li>descriptive attributes</li></ul><p>Examples:</p><ul><li>customer</li><li>product</li><li>geography</li></ul><h3>Slowly Changing Dimensions (SCD)</h3><p>Know:</p><ul><li>SCD1</li><li>SCD2</li><li>SCD3</li></ul><p>Especially SCD2 implementation logic.</p><h3>27. Most Important SQL Interview Problems</h3><p>You should practice:</p><ol><li>Second highest salary</li><li>Nth highest salary</li><li>Duplicate records</li><li>Running totals</li><li>Consecutive events</li><li>Sessionization</li><li>Top N per group</li><li>Funnel analysis</li><li>Retention cohorts</li><li>Moving averages</li><li>Fraud detection</li><li>Pivoting</li><li>Event stream analysis</li><li>SCD Type 2</li><li>Incremental loads</li></ol><h3>28. Performance Optimization</h3><p>Expected at 5 years experience.</p><p>Interviewers love asking:</p><blockquote><em>“How would you optimize this query?”</em></blockquote><p>Know:</p><ul><li>indexing</li><li>partition pruning</li><li>avoiding SELECT *</li><li>join optimization</li><li>hash joins</li><li>sort costs</li><li>vacuum/analyze</li><li>parallel execution</li><li>query planning</li></ul><h3>29. Real Interview Expectations at 5 YOE</h3><p>Interviewers expect:</p><ul><li>clean SQL</li><li>scalable thinking</li><li>optimization awareness</li><li>edge-case handling</li><li>analytical problem solving</li><li>warehouse modeling knowledge</li><li>ETL/ELT understanding</li></ul><p>The biggest separator is usually:</p><ul><li>strong window function knowledge</li><li>event stream problem solving</li><li>performance tuning understanding</li></ul><h3>Best Platforms for Practice</h3><ul><li><a href="https://leetcode.com/problemset/database/?utm_source=chatgpt.com">LeetCode SQL</a></li><li><a href="https://datalemur.com/?utm_source=chatgpt.com">DataLemur</a></li><li><a href="https://www.stratascratch.com/?utm_source=chatgpt.com">StrataScratch</a></li><li><a href="https://datapathsala.com/?utm_source=chatgpt.com">DataPathShala</a></li></ul><h3>Final Thoughts</h3><p>For Data Engineer interviews, SQL is not just a querying language anymore.</p><p>It is:</p><ul><li>an analytical tool</li><li>a transformation engine</li><li>a performance engineering skill</li><li>a data modeling language</li></ul><p>Master:</p><ul><li>window functions</li><li>joins</li><li>aggregations</li><li>event processing</li><li>optimization</li></ul><p>…and you will clear a significant percentage of SQL interview rounds confidently.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fd18bcb07831" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Joining The Bitcoin Frenzy- The Future of Cryptocurrencies]]></title>
            <link>https://medium.com/thecapital/joining-the-bitcoin-frenzy-the-future-of-cryptocurrencies-cb98980bef68?source=rss-79c4aa6f9399------2</link>
            <guid isPermaLink="false">https://medium.com/p/cb98980bef68</guid>
            <category><![CDATA[cryptocurrency]]></category>
            <category><![CDATA[bitcoin]]></category>
            <category><![CDATA[blockchain]]></category>
            <category><![CDATA[economy]]></category>
            <category><![CDATA[finance]]></category>
            <dc:creator><![CDATA[KAUSTAV MONI BASUMATARY]]></dc:creator>
            <pubDate>Wed, 17 Feb 2021 07:03:37 GMT</pubDate>
            <atom:updated>2021-02-19T00:28:23.735Z</atom:updated>
            <content:encoded><![CDATA[<p>With the advent of cryptocurrencies into the mainstream financial system, it’s not strange anymore when you can see that the front page of a business newspaper contains the headlines, “Bitcoin is the best asset class of 2020,” “Investors flock to Dogecoin after Elon Musk’s tweet” or “Tesla will now accept Bitcoins as payment.” A combination of various financial constraints and favors as well as the support of a mighty few have helped in lifting up the price of these currencies to unprecedented heights. While writing this, Bitcoin is just shy of reaching an all-time high of 50,000 US dollars, which I believe, it can easily touch given the current euphoria continues on. But does the current mandate of many investors that provides cryptocurrencies such high valuations justifiable, or is it just another bubble ready to burst? In this article, I will try to declutter some of the mist and present the true scenario. So, let’s get started.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*LRci3xxbM0lxGDzx" /><figcaption>Photo by <a href="https://unsplash.com/@bermixstudio?utm_source=medium&amp;utm_medium=referral">Bermix Studio</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Before we know how Bitcoin or cryptocurrencies as a whole are intertwined with the economy, it is prudent to understand how Bitcoin works and how it is created. Basically, Bitcoin is based on blockchain technology. In simple terms, it’s kind of like a network where the data shared or transaction details between any two nodes of the network are stored in the form of blocks. These blocks are then connected by chains or links, which shows the continuity between the blocks. These blocks are decentralized, and hence it is not stored at a particular node or location. When Satoshi Nakamoto created Bitcoin or the blockchain network as a whole, certain protocols were implemented, which ensures that the transactions in the blocks can never be altered, and the issue resolving mechanisms would ensure that there is no inconsistency between the transaction information in one node with the other. Hence, the transactions done through a blockchain are immutable, irreversible, and safe. Now, new Bitcoins enter into the system via Bitcoin mining. Certain nodes in the network have to perform the function of verifying the transactions within the network. In order to verify the transaction, a mathematical puzzle is to be solved, which requires a lot of computing power and energy. These nodes are then rewarded with new bitcoins for every block that is verified or created. This is known as bitcoin mining.</p><p>The price of a bitcoin has risen by about 800% from its low in March 2020. Since then, it has not turned back and has been continuously increasing at an unbelievable rate. Well, it reminds me of a similar story in 2017, where the price of a bitcoin rose by about 1500% in a single year. But then, in early 2018, a huge fall of 65% wiped out most of the value from the currency. It took almost 2 years for the price to reach the highest level from 2018, and now after breaking all resistances, is still continuing on its northward trajectory. One major difference between the rise of 2017 and 2020 is that Bitcoin has now received backing from established investors from Wall Street and beyond. Hence, retail investors are more than willing to confidently invest in Bitcoin as an asset class. Billionaire Elon Musk who is quite optimistic about the future of cryptocurrencies has added fuel to this optimism by even promoting currencies such as “Dogecoin,” which was created only for fun as a meme. But one of the profound thing which worries many is that most of the people are buying these cryptocurrencies as an asset class and not as a means of transaction. This means that people are either only trading in these currencies as speculation and technical analysis or are viewing it as gold for a long-term investment. However, most of the transactions in bitcoin or other cryptocurrencies that are being done are usually for illegal activities like child trafficking, illegal arms sale, terrorist activities, etc. Since the government or the central bank does not control the transactions in bitcoins, it is usually viewed as a safe haven for such criminal transactions. However, bitcoin has been able to detach itself from the stigma as the criminal coin by making itself accessible to the masses and with the ease of transaction by the crypto exchanges.</p><p>Now, the question which arises is this “Will the governments of different countries allow the bitcoin to take the place of fiat currency?”. Will it be a currency that will be completely out of control of the government and the central bank and, as such, will be regulated only in terms of demand and supply as must be for an ideal capitalistic society? Well, the possibility that any government will give away its sovereignty to only market forces and, as a result, rescind its power of regulating the financial and economic aspects of the world is highly unlikely in the near future. According to the protocols set by bitcoin’s founder, there can only be a fixed number of bitcoins i.e., 21 million, that can ever exist in this world. This is regulated by decreasing the rewards given to the bitcoin miners every year. Now, since the supply of bitcoins is limited and the demand for it is ever increasing, ceteris paribus, the value or price of bitcoins should definitely shoot up. Many renowned economists are comparing bitcoin with gold. Well, there are indeed many parallels between gold and bitcoin. Both are appreciating assets, as the demand for them is ever-increasing, but the supply is limited.</p><p>Many economists have pointed to the return to the Bretton Woods system, which existed from 1944 to 1971, where every country was required to maintain gold reserves, which were equivalent to the currency in circulation. This was helpful in the way that it prevented the countries from printing an unlimited supply of money. This even helped the US dollar to become the world’s reserve currency while other countries could work on rebuilding their economy. Hence, bitcoin or any other cryptocurrency can act as gold in this case which will be pegged to the currencies of different countries. However, in 1971, US President Nixon unilaterally announced the suspension of the convertibility of the US dollars with gold, and then the US dollar became a free-float currency. Other countries followed suit, and the Bretton Woods system came to an end. This, however, gave unilateral power to the government or the central bank of a country to print money according to their will and even devalue their currency for their own benefits without having to worry about maintaining a gold reserve. The whole currency conversion rate was based on demand and supply as well as the government’s decisions. This system has worked until now, but there is a growing suspicion among many economists and financial experts about the government’s decision to print money according to will and then accumulating an insane amount of debt by issuing government bonds.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3E7XfSYEC0f_vwza" /><figcaption>Photo by <a href="https://unsplash.com/@someguy?utm_source=medium&amp;utm_medium=referral">Andy Feliciotti</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Last year, because of the Covid-19 pandemic, the Federal Reserve decided to pump in almost 3 trillion dollars into the economy by supplying new money. This money is usually in the form of debts or securities that the Federal Reserve buys from the government or other private entities. However, this has provided a steroid to the ailing economy and artificially flooding the market with new dollars. As a result, the newly created dollars have pushed the Dow Jones Industrial Average and S&amp;P 500 to all-time highs, even though the economy and the earnings of the companies do not substantiate such a rally. But still, the dollar has maintained its relative stability. If other countries would have tried to print such an insane amount of money, it would have caused inflation and a huge drop in the value of their currency. Since the US dollars is the world’s reserve currency and because of the trust in the stability in the US government, the US can accumulate such an insane amount of debts and still not face any immediate repercussions. Many countries are buying up dollars from the open market as foreign exchange and artificially increasing the value of the dollar. This leads to a decrease in the supply of dollars in the market and hence the value of the dollar increases. Countries like China, Japan, Switzerland, Russia, and India have huge foreign reserves denominated in terms of dollars. Since the value of the dollar shoots up, it leads to a devaluation in the currency of the other countries. As a result, it becomes cheaper to produce goods in that country, which leads to an increase in the export of such goods.</p><p>There have been recent talks of currency manipulation and warfare. Now, many countries have been stocking up dollars. If somehow, any country decides to release these dollars into the market, a huge fall in the value of the dollar would occur and would disrupt the whole economic system as we know it. But an action such as this will also harm the country which released the dollars unless they have devised some method to shield their own currency from the fallout. Now, back to cryptocurrencies. Hence, many economists are of the notion that since the cryptocurrencies are created by algorithms, and hence we can predict the amount that will be created at a given stretch of time, it will lead to the countries becoming more responsible and hence withhold themselves from printing huge amount of money and also prevent economic warfare between countries. Like bitcoin, the supply of gold was limited, but the amount of gold that could be mined could never be predicted accurately. This created an advantage to the countries which had huge gold reserves, as they are the ones who may control the whole money flow in the world.</p><p>Jumping back to an asset-backed monetary system would mean that the people are also willing to bear the consequences. This will read to a decrease in the freedom of the central bank to implement strict and immediate measures when the economy is in turmoil or recession. In 2020, even though many countries went into recession and it was thought that it will have a lasting effect, the central bank came to the rescue. With the decrease in the interest rates as well as the increase in the supply of money, the central bank was able to do all these without having to worry about maintaining a reserve of gold which may have to be imported from some other country.</p><p>Now, what if we replace the dollar and instead use bitcoin as the international currency for inter-country transactions? This may seem to be a good prospect for many bitcoin investors, but any international currency must have two important features. First, it should be relatively stable, and we all know how stable bitcoin is. Any person working in the export-import business as of now will ever come into a contract whereby he or she may not even be sure of the actual amount that will be received if the payments are delayed by a month. Second, trust. The US dollar is used for almost all international transactions because of the trust that the people around the world have in the US government. They believe that the US government and economy will never allow itself to go bankrupt, or even will not undertake any mischievous actions. But look at bitcoin, we do not even know who the founder actually is. We have nowhere to go if something fraudulent happens with us. We have no one to blame and no one to regulate. For bitcoin to be successful, we all have to trust each other. But, the regulating action of the central bank is also put into question when people think about the 2008 financial crisis. But still, the central bank came to the rescue during both 2008 and 2020 to lift the economy back on its track.</p><p>Many countries, including India, have begun to mull to ban private cryptocurrencies and are thinking of a cryptocurrency of their own. Blockchain as a technology can completely revolutionize the banking industry. India has begun thinking of creating a digital currency which may implement blockchain technology. The NPCI (National Payments Corporation of India) has already introduced the platform “Vajra,” which is based on blockchain distributed ledger technology for safe transactions. China has also begun to issue “Digital Renminbi” currency which will be pegged to the physical renminbi but it will be issued by the central government. However, this currency will be centrally controlled like that of the present currency and will not implement blockchain technology. Countries like India and China will not easily give away their autonomy. Hence, it’s very unlikely that bitcoin will be used as a legal tender anytime sooner in these countries. However, these countries may implement blockchain technology to facilitate transactions.</p><p>While concluding it, I would like to say that bitcoin as of now, with its relative instability will not be regarded as a currency for international transactions or even act as a reserve currency. However, if the governments of different countries unite together to create a cryptocurrency that will be relatively stable and also be trusted, then there is a hope that one day, this currency may replace the US dollar as the world’s reserve currency. Private cryptocurrencies may be accepted in the developed countries as a means of transaction because of the ever-decreasing yields from other asset classes, but the governments in developing countries will not allow private cryptocurrencies to become legal tender money. However, the governments in these countries may allow trading and investing in these currencies via registered crypto exchanges because it will just act as an asset class that has been given value by the people who believe in it. In the future, the governments will definitely adopt the blockchain technology for different purposes, but it will ensure that the ledgers in the network are registered and trusted but may deter from accepting cryptocurrencies as a whole.</p><p>By the time I finished writing this, bitcoin has already touched the $ 50,000 mark. Let’s just hope that it isn’t just another Souk Al-Manakh story.</p><p><strong>Check out our new platform </strong>👉<strong> </strong><a href="https://thecapital.io/"><strong>https://thecapital.io/</strong></a></p><p><a href="https://twitter.com/thecapital_io">https://twitter.com/thecapital_io</a></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fupscri.be%2Ff%2F3c1144%3Fas_embed%3Dtrue&amp;dntp=1&amp;display_name=Upscribe&amp;url=https%3A%2F%2Fupscri.be%2F3c1144&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=upscri" width="800" height="400" frameborder="0" scrolling="no"><a href="https://medium.com/media/3b6b127891c5c8711ad105e61d6cc81f/href">https://medium.com/media/3b6b127891c5c8711ad105e61d6cc81f/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cb98980bef68" width="1" height="1" alt=""><hr><p><a href="https://medium.com/thecapital/joining-the-bitcoin-frenzy-the-future-of-cryptocurrencies-cb98980bef68">Joining The Bitcoin Frenzy- The Future of Cryptocurrencies</a> was originally published in <a href="https://medium.com/thecapital">The Capital</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Vengeance]]></title>
            <link>https://engorgia.medium.com/vengeance-440ddbd65098?source=rss-79c4aa6f9399------2</link>
            <guid isPermaLink="false">https://medium.com/p/440ddbd65098</guid>
            <category><![CDATA[poetry]]></category>
            <category><![CDATA[haiku]]></category>
            <category><![CDATA[japan]]></category>
            <category><![CDATA[poem]]></category>
            <dc:creator><![CDATA[KAUSTAV MONI BASUMATARY]]></dc:creator>
            <pubDate>Fri, 05 Jun 2020 07:52:15 GMT</pubDate>
            <atom:updated>2020-06-05T07:52:15.561Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Pgxi3kzu2bhvD7XJ" /><figcaption>Photo by <a href="https://unsplash.com/@peter_forster?utm_source=medium&amp;utm_medium=referral">Peter Forster</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Shudder through the mind<br>Brief thought on the vengeful way<br>No glory stowed away</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=440ddbd65098" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[8 things you wish you knew before you entered into the stock market]]></title>
            <link>https://engorgia.medium.com/8-things-you-wish-you-knew-before-you-entered-into-the-stock-market-905633a418f7?source=rss-79c4aa6f9399------2</link>
            <guid isPermaLink="false">https://medium.com/p/905633a418f7</guid>
            <category><![CDATA[stocks]]></category>
            <category><![CDATA[financial-freedom]]></category>
            <category><![CDATA[market-analysis]]></category>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[stock-market]]></category>
            <dc:creator><![CDATA[KAUSTAV MONI BASUMATARY]]></dc:creator>
            <pubDate>Thu, 04 Jun 2020 17:04:43 GMT</pubDate>
            <atom:updated>2020-06-05T07:28:15.135Z</atom:updated>
            <content:encoded><![CDATA[<h3>8 Things you wish you knew before you entered into the stock market</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7VnP2dRBubtOgCwKi46IWA.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@energepic-com-27411?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">energepic.com</a> from <a href="https://www.pexels.com/photo/blue-and-yellow-graph-on-stock-market-monitor-159888/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>I am a 21 year old guy and its been just six months since I entered into the world of stock market. So this article would be written from the viewpoint of a novice. When I entered into the market I really didn’t know anything about it except that stocks are kind of like company ownership that you receive by paying a price and you can sell that ownership later on for a higher price than that at which you purchased them. Even after 6 months, I believe I have just gathered an iota of the basic notion of financial freedom and the working of the corporate world.</p><p>Well, as promised, here the key things that you should know before you enter the stock market</p><ol><li>Learn the fundamentals of the company before investing. Learn about the company, the way they earn revenue, the way they earn profit, the future prospect, whether the company is under some stress or not. It is always advisable to check the management of the company. Always check whether the company is under debt or not. Even if it is under debt, whether it is in a good position to repay the debt. Ask yourself what products of the company you use. Whether the products the company produces are liked by its customers or not. Most of the information stated above are easily obtained when the company publishes it quarterly results. If a company has some competitive advantage over its peers, buy its stocks. If it runs a monopoly business, buy its stocks.</li><li>Classify yourself if you are a trader or an investor. An investor is someone who invests in the company believing that the value of the company will increase over many years. Warren Buffet is a prime example of who an investor is. If you are a trader, you will buy a stock and then sell the stock quite frequently maybe within less than a year, two or three months or even sell it the same day. Read the recent news about the company and the stock you selected. After checking the fundamentals of the company, if you you find it worthy of your investment, invest in it and only look back at it after a year if you are an investor.</li><li>If you want quick profits, you can opt to be a trader. The basic fundamental principle of a trader should be to buy low and sell high and it is up to the trader to determine what the fair price should be that he deems fit at which he wants to buy or sell the price. Some of the methods to know the fair price are listed in the subsequent points.</li><li>You should have at least some idea of technical analysis. Now, many investors would disagree with me at this point because stocks invested for the long term would be considered to generate the same return. Well, it may be true that a 2% less return may not be a big deal for some people, but its still a significant number. So, to know the correct price and time to enter and exit the market, one should have at least some idea of the different strategies or techniques available such as Bollinger Bands, MACD ( Moving Average Convergence Divergence, MFI (Money Flow Index), RSI (Relative Strength Index) etc. These indicators are simple to use and are already inbuilt in many trading platforms. A fair knowledge of these indicators would definitely aid in knowing the direction of the market and to know whether a stock is in the correct price range to buy or not.</li><li>Learn to manage your money. Keep track of the money that you are using for buying and selling stocks. Be clear about the different charges that are levied by the broker and the exchange. Sometimes, if your capital is less, the profit you earned by selling the stocks would be far less than the brokerage you need to pay and you would be under the false notion that you earned a profit even though in reality you didn’t.</li><li>Be ready for huge falls or gains in a day. Yes, sometimes market remains very volatile and may fall 5 to 6% in a day. Some stocks would even tank 10%. Such kind of reactions from the market is expected and is quite normal for some special occasions. It may be a decision by the government to increase or decrease taxes, a decision by the central bank to reduce or increase interest rates or the COVID-19 pandemic. New investors should be ready for all such eventualities and not be intimidated by it. With experience such huge falls and gains would eventually seem normal.</li><li>If possible join some peer groups to discuss about the stock market. It may be a virtual online group or a group among your friends who are as interested as you in the stock market. This will help you in widening your horizon and look into every aspect of a stock before buying it.</li><li>At last, don’t buy a stock on someone’s recommendation. Listen to what the person thinks about the stock and then use your own analysis to check the credibility of the argument put forward by the person. Only invest when you are utterly sure of the provided argument or logic.</li></ol><p>Well, I wish you the best of luck for your future journey in the stock market. It’s a huge opportunity and it’s a great leap towards becoming more financially independent. As a young trader cum investor, I can only advise you to start as early as possible in the stock market. It will definitely help you in getting a better insight into how the world is actually working and increase your financial freedom.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=905633a418f7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[THE ECONOMIC PROSPECTS OF INDIA AFTER THE COVID-19 PANDEMIC]]></title>
            <link>https://engorgia.medium.com/the-economic-prospects-of-india-after-the-covid-19-pandemic-cdfc5be045d0?source=rss-79c4aa6f9399------2</link>
            <guid isPermaLink="false">https://medium.com/p/cdfc5be045d0</guid>
            <category><![CDATA[india]]></category>
            <category><![CDATA[asia]]></category>
            <category><![CDATA[economy]]></category>
            <category><![CDATA[covid19]]></category>
            <dc:creator><![CDATA[KAUSTAV MONI BASUMATARY]]></dc:creator>
            <pubDate>Wed, 03 Jun 2020 17:28:13 GMT</pubDate>
            <atom:updated>2020-06-05T06:56:23.398Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*uOXKCDl5hUqEL-Az" /><figcaption>Photo by <a href="https://unsplash.com/@naveedahmed?utm_source=medium&amp;utm_medium=referral">Naveed Ahmed</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Well I hope everyone reading this is in good health. The COVID-19 pandemic which originated in China is indeed one of the greatest challenges mankind has to deal with in all its existence on the face of this earth. But a great peril awaits us, an economic shock unprecedented in history. Most of the countries in the world are in total lock-down now. A self induced coma which is supposed to decrease the R-naught (basic reproductive rate ) factor of the nCov seems to be working. The world is healing itself. We may one day even achieve herd immunity. But in the midst of all these, it is equally important to talk about the economic impact that will be caused by this lock-down.</p><p>Let us come to the context of India. Well the country went into a total lock-down on 25 March 2020 and is still continuing. Though the lock-down has been eased from 1 June 2020, it is still strongly implemented in the various containment zones. But still, India is opening its economy slowly and steadily and everyone is hoping that India will be up and running in no time. Though the lock-down is being eased, Mumbai, being the most hardly affected city in India has still a vast area of it designated as containment zones. Similar is the case with Delhi. One can hardly think of this country running without its largest cities, one of them the financial capital and the other the political capital. But it is still hoped that India will triumph. A large part of India is still inside containment zones and there are indeed success stories such as the Bhilwara model , which has been seen as the best example of the competency of the Indian system.</p><p>The tourism industry and the aviation industry are some of the most affected industries during this lock-down. They had almost zero revenues earned during this lock-down. Oil plummeted to history’s lowest but no one to buy it. The government has announced various measures in its 20 lakh crore economic package which primarily focused on the MSMEs and the welfare of the poor people. But experts are of the opinion that this economic package is heavily skewed towards solving mainly the supply side of the equation, the demand side is still lacking.</p><p>The next two years are going to be gloomy not just for India but almost all the countries of this world. But India may be well poised now more than ever to be a leading manufacturer in the world, the tag which is currently held by China. It is clearly evident that most of the countries are quite angry at China and WHO for being late in announcing the gravity of the situation to the world. The US is thinking of economically sanctioning China. Japan has already offered huge incentives to their companies to shift their manufacturing bases out of China. South Korea may also plan to do the same. So a large number of companies may be asked to shift their manufacturing bases out of China by their respective countries even though they may not be willing to do so. China may threaten the companies with sanctions or even seize their assets, but the companies will be compelled to leave. Now the obvious alternative that can be sought by the countries is to shift their manufacturing base to a country where the wages are low, where its easy to do business and have a fair infrastructure and connectivity. Now the list comes down to South East Asian countries like Vietnam and South Asian countries like India and Bangladesh. Though Vietnam is closer to the Pacific and China (which is a large market), there are certain advantages of shifting their bases to India. India will provide them with an easy access to the vast market of South Asia, South East Asia, Australia, Africa , Middle East and Europe. The world’s wealth is shifting very rapidly towards the east and it is evident that the western companies have realized it. So they will definitely try to capture this huge market which have enough capacity to accommodate all of them.</p><p>Many rating agencies have expected India’s growth rate to slow down these two coming years. But think about the third year, when the manufacturing bases are complete and the economy is starting to boom. A large number of people will loose jobs these two years but the new jobs generated from the third year will be ready to absorb them. I remain positive in this aspect. The government is also trying their best to lure the companies to come to India. India is offering a land size twice that of Luxembourg for companies that want to come to India. Some states are even offering ready-made offices. The government is trying to completely strengthen the base of our country i.e. the MSMEs( Medium,Small and Micro Enterprises) so that they can take up a greater role in the upcoming days. The government is in talks with industrial experts and the representatives from the industries to suggest them policies which would help them increase the business friendliness in the country. There will be indeed strong repercussions against India from the Chinese side but India will not succumb to such tactics and India is more than able to counter any such threats.We have come a long way from the LPG (Liberalization, Privatization and Globalization ) reforms of 1991. Surely, India will succeed. Even the citizens of this country are awakening to the call of this land to bring India unto the stage of Vishwa Guru.</p><p>We may miss the 5 trillion dollar GDP mark by 2024, but we will surely be closer to it. If sources are to be believed, many agencies believe India’s GDP to grow by 2% in 2020. Its a small growth, but its still a growth. Imagine if India grows with such a low rate, what will happen to the developed western countries. There will be an economic turmoil. India already had an initial high growth rate to offset the recession. Everyone will surely feel its effects, but India will rise. The next year India will rise by 4 or 5%, that’s a good start. By this time I am assuming that the world will get a hold of their economy and so will India. The manufacturing bases are completed. India has maintained good relations with the US and Europe which sees India as a counter to the rising hegemony of the Chinese. The Chinese are angry at India for stealing their jobs but they can’t openly say it. The next year i.e 2022 will be the golden year for India, the growth rate would be as high as 7 or 8% as the reforms which have been set forth by the governments have come to fruition. The economic engine is looking for its zenith. By now , most of the people who lost their jobs due to the lock-down will get new jobs. The new investments will bring thousand of opportunities for them, helping them to earn far more than they earned before. By now India’s GDP will be 3.5 to 4 trillion dollars. The 75th year of independence will mark the vast leap that India has taken to mark its place on the global stage once again. The country will inaugurate its first bullet train. It will have sent men to space, becoming the fourth country to do so. India’s vyomnauts will be highly respected. By 2024, India will very much come close to its 5 trillion dollar mark but there is a high probability that it will miss it. But by the beginning of 2025, India will achieve the status and may even surpass Japan, if Japan goes into recession to become the third largest economy by GDP in nominal terms. And if this growth continues, and we achieve growth rates as high as Brazil achieved during the first decade of this century India can surely become a 10 trillion dollar economy by 2030.</p><p>All this while it is expected that China’s economy will start to cool off because of the loss of investments from other countries and the generally deteriorating ties with them. As a result it will be more easier to reach China’s level than it was 3 or 4 years back. The GDP of India is currently 2.8 trillion dollars, China had that GDP in 2006. Hence, we can assume that China is 13 or 14 years ahead of India and it will take almost 10 to 12 years for India to reach to the level that China is now.</p><p>All the data and projections above are considered from the point of view of the best possible case scenario. I am deeply sorry if it has hurt someone’s sentiment. The views written above are purely my own and the projections may not be accurate.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cdfc5be045d0" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>