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.
In this digital landscape, SQL and relational databases form the backbone of virtually all critical infrastructure in the United States. The organization and security of those databases, however, is dependent on the manner of their construction, which determines how data is accessed and protected. Your team's ability to construct and manage a database effectively is therefore critical.
In this course, you will approach database design from a perspective focused on data security and integrity. You will go from learning how to approach general security to understanding how to properly execute modifications so that data integrity is preserved. Along the way, you will discover how to systematically design, build, and manage databases while prioritizing data integrity and security, which will maximize their utility for your organization.
The following courses are required to be completed before taking this course:
- Exploring Data
- Integrating Data From Multiple Tables
- Extracting Insights From Data
Key Course Takeaways
- Incorporate security and access rights into database design
- Convert one type of data to another, making them usable for deeper analysis
- Troubleshoot database design issues using entity diagrams
- Modify database design to create new fields or tables
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