INF 385T - Special Topics in Information Science: Data Wrangling from Excel to SQL & Beyond
Graduate standing. Additional prerequisites may vary with the topic.
Study of the properties and behavior of information. Technology for information processing and management.
Three lecture hours a week for one semester.
May be repeated for credit when the topics vary.
Data Wrangling from Excel to SQL & Beyond
This course, "Data Wrangling" will enable you to:
- design database schemas for efficient data representation
- implement database schemas using MySQL
- navigate data management issues in organizations
- learn the basics of programming in Python
- import and export data to/from CVS and Excel, changing schemas
- conduct basic analyses in Excel
- prepare a project workflow that imports data from different
sources and produces reports
There are no prerequisites for this course; it is appropriate
even if you've never done any programming or behind the scenes
work with computers. I'll address each topic "from scratch". If
you do have significant, recent, experience, or training with
programming and databases this is not the course for you; you
will find it too introductory. In this case I require you to drop
the course and welcome you to audit parts that you think will
extend your knowledge. In particular this course is not suitable
as a interdisciplinary course for Computer Science students.