From the course: SQL for Finance Professionals
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Case study: Detecting fraud - SQL Tutorial
From the course: SQL for Finance Professionals
Case study: Detecting fraud
- [Instructor] One of the most common applications of predictive modeling in finance is using anomaly detection to deduct fraudulent credit card transactions. SQL comes in handy when finance professionals have vast amounts of transaction data to work with in creating their fraud detection models. But in practice, SQL is not the only tool they use. Python or R are two other coding languages that many consider essential in building predictive models. This is because they come with built-in packages or libraries that are open-source and specifically designed for the purpose of machine learning. In this case study, we'll walk through what building fraud detection models look like in the context of all these tools together. SQL is likely the first tool you'll encounter in the process of building your fraud detection model. The engineers who have built the data pipelines used to retrieve the transaction data most likely have the data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.