Image for post
Image for post

SQL or Structured Query Language is one of the most in-demand skills that you require whether you’re applying for a data analyst, a business intelligence engineer, a data scientist or a data engineer role. Today, SQL is the standard means of manipulating and querying data in relational databases. In this article, I will be walking you through the best SQL courses, blogs, tutorials, & books for learning SQL.

Learning SQL can be hard enough without navigating through thousands of articles & websites. …


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…


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. …

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