Professor Shawn Mankad is an assistant professor of operations, technology, and information management at the Johnson Graduate School of Management, where his research focuses on the intersection between data analytics and economic decision making using machine learning techniques. His studies aim to create and apply data mining, machine learning, and visualization techniques for economic modeling with unstructured and complex structured data. His research has been featured in journals and over a dozen media outlets, including the Wall Street Journal and the Chicago Tribune. Prior to joining Johnson in 2015, Professor Mankad was an assistant professor in the Robert H. Smith School of Business at the University of Maryland. He was a consultant with the U.S. Commodity Futures Trading Commission and also worked at the Federal Reserve Board on characterizing market activity with visual analytic tools. His undergraduate degree is from Carnegie Mellon University, and he received his PhD in statistics from the University of Michigan.
Many different business applications rely on SQL as a backend process to communicate with and manipulate databases, which provides the information and statistics required for related business operations.
In this course, you will practice integrating and analyzing data from multiple tables. You will discover how to fully utilize the structure of relational databases and apply that knowledge to understand how highly complex business questions are answered. Along the way, you will identify how to systematically approach queries using an assortment of new clauses, thereby expanding your problem-solving capacity and ability to deliver varied outputs of your own choosing.
The following courses are required to be completed before taking this course:
- Exploring Data
Key Course Takeaways
- Build a query using JOIN statements and understand the schema of databases
- Create summary statistics of joined data to map business objectives to a desired result
- Use SELF JOINs and subqueries to answer complex questions
- Write a query using set operations to extract information from multiple entities
How It Works
Who Should Enroll
- Business analysts
- Professionals who work with databases or data warehouses
- Managers using data insights to make business decisions
- Marketing analysts
- Product analysts