Fig1: Most affected countries over time (based on Confirmed Cases)

Introduction

The largest global pandemic since the 1918 Spanish Flu is upon us today. The novel coronavirus is bringing countries to a halt and causing widespread health impacts and fatalities. The evolution of this virus is one of the most dangerous problems for society. In this article, I’ve attempted to take a closer look at the data and trends to analyze worldwide COVID-19 cases and mortality statistics across countries.

In this article, I will walk you through the steps I undertook for this analysis with code snippets and visuals. You can find the full code here: Kaggle Notebook. …


Image for post
Image for post

SQL is a declarative language where each query declares what we want, but it doesn’t say how. The how is what affects the efficiency of queries. SQL performance tuning can be an incredibly difficult task, especially when working with large-scale data where even the most minor change can have a drastic impact on the query performance. When you are dealing with such huge tables, optimization is the key. An inefficient query may pose a burden on the database’s resources, and cause slow performance or loss of service for other users if the query contains errors. …

About

Vijaya Rani

Business Intelligence Engineer @Amazon https://www.linkedin.com/in/vijayarani/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store