Crypto Case Study Through SQL

Step into the world of Cryptocurrencies, analyze the price and market share trends for some of the top crypto currencies

Learn the following SQL Concepts:

• How to get N rows of data in SQL
• How to use Mathematical Functions in SQL
• How to apply a date filter in SQL
• How to sort data and limit number of rows in SQL
• How to create new columns using mathematical functions on existing columns in SQL
• How to apply multiple conditional filters in SQL
• How to use Statistical Functions in SQL
  • Mean, Range, Standard Deviation etc.
• How to use Date Functions in SQL
  • How to extract parts of date from a column in SQL
• How to do time-series analysis of a metric in SQL
• How to use Window Functions in SQL
  • How to find Change from last value using the LAG OVER() Function in SQL
• How to use Aggregate Functions in SQL
  • Count, Count Distinct, Sum, Maximum, Minimum etc.
• How to Group data and aggregate in SQL
• How to combine Grouping and Sorting in SQL

Learn the following Concepts about Crypto Currencies:

• What are the various crypto currencies in the dataset and their daily prices
• What is market capitalization of a crypto currency
• How to analyze top crypto currencies based on their market capitalization
• Understand what is circulating supply for crypto currencies
• How to analyze crypto currencies above certain values of market capitalization
• How to find the most/least expensive crypto currency on a particular day
• How to analyze the price movements of Bitcoin
  • Find Mean, Range, and Volatility of Bitcoin Prices
• How to analyze the monthly/weekly/daily trend of Bitcoin Prices
  
  • How to analyze the month-on-month change in Bitcoin Prices
    
• How to analyze the price movements of any crypto currency
  • Find Mean, Range, and Volatility of any crypto currency
• How to analyze the monthly/weekly/daily trend of any crypto currency
  
  • How to analyze the month-on-month change in any crypto currency