The main difference between the introductory and intermediate levels in SQL is between:

• Knowing how to write basic SQL queries

AND

• Knowing how to use SQL to solve common business problems.

The medium level course teaches you how to deal with common analytics and metrics directly with SQL. After this course, you should be able to use SQL to build most of the reports and dashboards needed for financial or business analytics.

Some examples of intermediate SQL problems are:

• How can you get the number of daily, weekly, and monthly active users for a platform across different locations?
• How can you calculate customer churn for different products?
• How can you track the evolution of a variable across different time frames?

To be able to do this, you will learn a few more SQL clauses that will allow you to:

• Write complex queries by combining simple subqueries.
• Obtain conditional values by using CASE WHEN clauses.
• Learn how to deal with NULL values.
• Learn SQL generally useful datatypes and functions, such as DATETIME, LIKE, or window functions.

In summary, working up to a medium SQL level will allow you to perform financial and business analytics directly in SQL.

This course will let you perform most of the business analytics others do with Excel or Pandas, but directly with SQL. After this, you’ll be able to provide valuable insights over large datasets - without worrying that your computer will crash.