Using Databases with Python
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 Everybody”.
Buy Now AED 444.99 + VAT
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 15 hours
- Course by University of Michigan
-
Offered by
About
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 Everybody". 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. This course covers Python 3.Modules
Welcome
-
2
Videos
-
4
Readings
-
1
Assignment
1
Assignment
- Using Encoded Data in Python 3
2
Videos
- Welcome to Using Databases with Python
- Unicode Characters and Strings
4
Readings
- Help us learn more about you!
- Python Textbook
- Course Syllabus
- Notice for Auditing Learners: Assignment Submission
Installing Python
-
4
Videos
4
Videos
- Windows 10: Installing Python and Writing A Program
- Windows: Taking Screen Shots
- Macintosh: Using Python and Writing A Program
- Macintosh: Taking Screen Shots
Lectures
-
4
Videos
4
Videos
- 14.1 - Object Oriented Definitions and Terminology
- 14.2 - Our First Class and Object
- 14.3 - Object Life Cycle
- 14.4 - Object Inheritance
Assessments
-
1
Assignment
1
Assignment
- Object Oriented Programming
Bonus
-
2
Videos
2
Videos
- Bonus: Interview - Software Engineering - Bertrand Meyer
- Bonus: Office Hours - London
Lectures
-
4
Videos
4
Videos
- 15.1 Relational Databases
- 15.2 - Using Databases
- 15.3 - Single Table CRUD
- Worked Example: Counting Email in a Database
Assessments
-
2
ExternalTool
-
1
Assignment
1
Assignment
- Single-Table SQL
2
External Tool
- Our First Database
- Counting Email in a Database
Bonus
-
2
Videos
2
Videos
- Bonus: Office Hours Zagreb, Croatia
- Interview: Elizabeth Fong - The Early Years of SQL
Lectures
-
5
Videos
5
Videos
- 15.4 - Designing a Data Model
- 15.5 - Representing a Data Model in Tables
- 15.6 - Inserting Relational Data
- 15.7 - Reconstructing Data with JOIN
- Worked Example: Tracks.py (Chapter 15)
Assessments
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Multi-Table Relational SQL
1
External Tool
- Multi-Table Database - Tracks
Bonus
-
3
Videos
3
Videos
- Bonus: Office Hours Perth, Australia
- Bonus Interview: Niklaus Wirth
- Bonus: Office Hours Barcelona
Lectures
-
2
Videos
2
Videos
- 15.8 - Many-to-Many Relationships
- Worked Example: roster.py (Chapter 15)
Assessments
-
1
ExternalTool
-
1
Assignment
1
Assignment
- Many-to-Many Relationships and Python
1
External Tool
- Many Students in Many Courses
Bonus
-
2
Videos
2
Videos
- Bonus: Office Hours Mexico, City
- Bonus Interview: Andrew Tannenbaum - Minix
Lectures
-
1
Videos
1
Videos
- 16.1 - Geocoding
Assessment
-
1
Videos
-
1
Readings
-
1
ExternalTool
1
External Tool
- Databases and Visualization (peer-graded)
1
Videos
- Worked Example: Geodata (Chapter 16)
1
Readings
- Peer Graded Assignment - Instructor Input
Bonus
-
3
Videos
-
2
Readings
3
Videos
- Bonus: Office Hours - Amsterdam
- Bonus Interview: Richard Stallman - Free Software Foundation
- Bonus Interview: Brian Behlendorf - Apache Foundation
2
Readings
- Please Rate this Course on Class-Central
- Post-Course Survey
Charles Russell Severance