Startups Case Study Through SQL

In this case study we will wear the Venture Capital hat & analyze top VC-backed companies globally, their industry trends, and the amount of funding raised.

Learn the following SQL Concepts:

• How to write Select statement in SQL
• How to get N rows of data in SQL
• How to select specific columns in SQL
• How to use aliasing in SQL and rename columns
• How to use conditional filtering in SQL
  
• How to use multiple conditional filtering in SQL
  
• How to use AND and OR conditional filtering in SQL
• How to use the Between operator in SQL
• How to use Mathematical Functions 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 use numbered aliasing in SQL for grouping and sorting
• How to Sort data in SQL
• How to use String Functions in SQL
  • How to Calculate the Length of a string in SQL
    
  • How to Extract characters from a string in SQL
  • How to Clean string columns in SQL
  • How to concatenate different strings in SQL
  • How to use the Like function to filter data in SQL
• How to use Date Functions in SQL
  • How to extract parts of date from a column in SQL

Learn the following Concepts about Startups:

• How to Get all startups from a particular country
• How to find startups which raised more than 1 Billion Dollars
• How to get startups from a specific category
• How to analyze various funding rounds for startups
• How to find out total startup funding raised for a startup, country, or category
• How to find out total startups in a country, or a category
• How to find the top countries or categories which raised the most startup funding
• How to analyze names of companies
  
• How to standardize category codes
• How to analyze the founding date for these startups