Об этом курсе: 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.
Автор: Мичиганский университет
Преподаватели: Charles Severance, Associate Professor
School of Information
| Основные сведения | Курс 4 из 5 — Python for Everybody Specialization |
| Выполнение | 5 weeks of study, 2-3 hours/week |
| Язык | English |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
Программа курса
НЕДЕЛЯ 1
Object Oriented Python
To start this class out we cover the basics of Object Oriented Python. We won't be writing our own objects, but since many of the things we use like BeautifulSoup, strings, dictionaries, database connections all use Object Oriented (OO) patterns we should at least understand some of its patterns and terminology.
8 видео, 4 материала для самостоятельного изучения
- Reading: Help us learn more about you!
- Reading: Python Textbook
- Reading: Coming from Python 2 - Encoding Data in Python 3
- Видео: Unicode Characters and Strings
- Reading: Notice for Auditing Learners: Assignment Submission
- Видео: 14.1 - Object Oriented Definitions and Terminology
- Видео: 14.2 - Our First Class and Object
- Видео: 14.3 - Object Life Cycle
- Видео: 14.4 - Object Inheritance
- Видео: Bonus: Interview - Software Engineering - Bertrand Meyer
- Видео: Bonus: Office Hours - London
Оцениваемый: Using Encoded Data in Python 3
Оцениваемый: Object Oriented Programming
НЕДЕЛЯ 2
Basic Structured Query Language
We learn the four core CRUD operations (Create, Read, Update, and Delete) to manage data stored in a database.
7 видео
- Видео: 15.2 - Using Databases
- Видео: 15.3 - Single Table CRUD
- Видео: Worked Example: Counting Email in a Database
- Видео: Bonus: Office Hours Zagreb, Croatia
- Видео: Interview: Elizabeth Fong - The Early Years of SQL
- Видео: Worked Example: Twspider.py (Chapter 15)
Оцениваемый: Single-Table SQL
Оцениваемый: Our First Database
Оцениваемый: Counting Email in a Database
НЕДЕЛЯ 3
Data Models and Relational SQL
In this section we learn about how data is stored across multiple tables in a database and how rows are linked (i.e., we establish relationships) in the database.
8 видео
- Видео: 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)
- Видео: Bonus: Office Hours Perth, Australia
- Видео: Bonus Interview: Niklaus Wirth
- Видео: Bonus: Office Hours Barcelona
Оцениваемый: Multi-Table Relational SQL
Оцениваемый: Multi-Table Database - Tracks
НЕДЕЛЯ 4
Many-to-Many Relationships in SQL
In this section we explore how to model situations like students enrolling in courses where each course has many students and each student is enrolled in many courses.
5 видео
- Видео: Worked Example: roster.py (Chapter 15)
- Видео: Bonus: Office Hours Mexico, City
- Видео: Bonus Interview: Andrew Tannenbaum - Minix
- Видео: Worked Example: Twfriends.py (Chapter 15)
Оцениваемый: Many-to-Many Relationships and Python
Оцениваемый: Many Students in Many Courses
НЕДЕЛЯ 5
Databases and Visualization
In this section, we put it all together, retrieve and process some data and then use the Google Maps API to visualize our data.
6 видео, 2 материала для самостоятельного изучения
- Видео: 16.2 - Geocoding Visualization
- Видео: Worked Example: Geodata (Chapter 16)
- Видео: Bonus: Office Hours - Amsterdam
- Видео: Bonus Interview: Richard Stallman - Free Software Foundation
- Видео: Bonus Interview: Brian Behlendorf - Apache Foundation
- Reading: Please Rate this Course on Class-Central
- Reading: Post-Course Survey
Оцениваемый: Databases and Visualization (peer-graded)
Часто задаваемые вопросы
Как это работает
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Авторы
Мичиганский университет
The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.
Стоимость
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| Получите сертификат о прохождении курса, ссылкой на который можно делиться с другими людьми | Доступен |
Рейтинги и отзывы
Superb course
very good
good
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
4 of 5 in the series of Python for Everybody. You do not learn as much Pythin in this course, but apply it to scanning the web and gathering data. I am more for the scientific uses of Python and programming from scratch than what was taught in the course. Now I must write than many students enjoyed the course and learned something new. I took the first 3 in the series (btw it is recommend that you take the first 3 course before taking this particular one. Several of the HW forces you to use that prior knowledge. So don't rush through), and was able to walk away from those courses feeling a lot more comfortable with Python. This course not so much. But hey, in this course you see how Python can be applied and if you're into Data science it is a good introduction. I am stopping here and moving on to other coursera course. Not caring to do the capstone in this series. Regards.