Data skills are the cornerstone of the 21st-century workforce, and SQL is foundational for any role that involves data. Understanding and effectively using SQL can open doors to greater productivity, better decision-making capabilities, and more career opportunities in this era of digital transformation.
You might know SQL as a querying tool, but in this live training, you will see how SQL can help with predictive modeling. In this live training, we will teach you how to unlock a new dimension of your analytical power by bringing simple linear regression into SQL! Specifically, we will use a sales dataset and learn how to create a regression to find the quantity sold as a function of price. Furthermore, we will do a more sophisticated pricing anlaysis by finding the theoretical price that maximizes revenue —all within SQL.
Key Takeaways:
- Learn how to find the coefficients for a simple linear regression in SQL
- Discover how to use SQL to analyze pricing data and find the answer to an interesting optimization problem, which is finding the price that maximizes revenue
- Become good at SQL aggregate functions and common table expressions (CTEs)
