INF 385T - Special Topics in Information Science: Data Wrangling from Excel to SQL & Beyond

Fall 2016
Unique ID: 28215
Syllabus:   Syllabus
Prof:  Howison, James
Room: UTA 1.210A
Days:  Mon Wed
Time: 9:00 am - 10:30 am

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.

Topic Description:
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
as needed
- 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.

View all classes with this course number

glqxz9283 sfy39587stf02 mnesdcuix8