Learn SQL by stepping into the role of a data scientist for two fictional companies.
Congratulations! You are now the data scientist for two fictional companies: a retail company (Monday Boots) and a software-as-a-service (SaaS) company. Throughout this course you will face real-world challenges that will require you to pull reports and manipulate databases in order to help your colleagues make well informed business decisions.
In this course you will explore topics, such as: Query basics, Logical operators: AND, OR, LIKE, IN, & BETWEEN, Aggregate functions: MAX, MIN, COUNT, SUM, & AVG, CASE statements, Joining datasets, Window functions: LAG, LEAD, & FIRST_VALUE ... and much more!
No prior experience is required to complete this course.