Course
AdvancedLearn how to conduct an analysis of customer behavior for your business using T-SQL queries. In this online course, you'll find out how to measure the acquisition, conversion, sales, and churn using SQL Server.
This online course benefits analysts, data scientists, IT students, business developers, anyone with an interest in SQL Server, and more. The prerequisite is understanding the basics of T-SQL, such as how to JOIN tables and WHERE, GROUP BY, ORDER BY and HAVING clauses (we introduce these elements in our SQL Basics in SQL Server course.)
We all know that customers are essential for every business. This simple fact is why companies usually put a lot of effort into understanding customer behavior. In this online course, you will learn how to perform customer behavior analysis using T-SQL.
Throughout the online course, we'll be working on an imaginary dataset of an online supermarket that sells groceries and everyday products. You'll learn how to analyze customer behavior and the entire customer lifecycle: from acquisition, conversion, sales up to customer churn.
Through 73 exercises, you'll teach yourself how to write universal queries and reports in SQL Server. Moreover, you'll find out how to apply your SQL skills and analysis of customer behavior to other business models, not just e-stores. Therefore, if you wish your knowledge of SQL is more practical than theoretical, this online course is for you!
The knowledge we present in our online course is applicable to a wide range of industries—from grocery stores to insurance companies. You'll be able to analyze customer behavior in a wide variety of scenarios. Click the "Start for free" button and see it yourself!
Course progress
Exercises completed
1.
Get to know the data model and discover how to analyze customer registration.
2.
Find out how to analyze customer conversion data and create conversion reports.
3.
Define "good customers" and learn ways to identify them.
4.
Find out how you can analyze customer churn.
5.
How much you do remember from this course?