Subject: Computer Software~~Educational Software
This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3. js library to do basic data visualization.
This course will cover Chapters 14-15 of the book “Python for Informatics”. To succeed in this course, you should be familiar with the material covered in Chapters 1-13 of the textbook and the first three courses in this specialization.
Week 1: Object Oriented Python
Week 2: Basic Structured Query Language
Week 3: Data Models and Relational SQL
Week 4: Many-to-Many Relationships in SQL
Week 5: Databases and Visualization
Course Accredited By: University of Michigan