課程信息
4.8
9,632 ratings
1,659 reviews
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....
Stacks
Globe

100% 在線課程

立即開始,按照自己的計劃學習。
Calendar

可靈活調整截止日期

根據您的日程表重置截止日期。
Clock

建議:5 weeks of study, 2-3 hours/week

完成時間大約為10 小時
Comment Dots

English

字幕:English

您將學到的內容有

  • Check
    Explain the basics of Object Oriented Python
  • Check
    Understand how data is stored across multiple tables in a database
  • Check
    Use the Create, Read, Update, and Delete operations to manage databases
  • Check
    Utilize the Google Maps API to visualize data

您將獲得的技能

Python ProgrammingDatabase (DBMS)SqliteSQL
Stacks
Globe

100% 在線課程

立即開始,按照自己的計劃學習。
Calendar

可靈活調整截止日期

根據您的日程表重置截止日期。
Clock

建議:5 weeks of study, 2-3 hours/week

完成時間大約為10 小時
Comment Dots

English

字幕:English

教學大綱 - 您將從這門課程中學到什麼

1

章節
Clock
完成時間為 2 小時

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....
Reading
8 個視頻(共 64 分鐘), 4 個閱讀材料, 2 個測驗
Video8 個視頻
Unicode Characters and Strings17分鐘
14.1 - Object Oriented Definitions and Terminology8分鐘
14.2 - Our First Class and Object7分鐘
14.3 - Object Life Cycle8分鐘
14.4 - Object Inheritance6分鐘
Bonus: Interview - Software Engineering - Bertrand Meyer11分鐘
Bonus: Office Hours - London1分鐘
Reading4 個閱讀材料
Help us learn more about you!10分鐘
Python Textbook10分鐘
Coming from Python 2 - Encoding Data in Python 310分鐘
Notice for Auditing Learners: Assignment Submission10分鐘
Quiz2 個練習
Using Encoded Data in Python 310分鐘
Object Oriented Programming22分鐘

2

章節
Clock
完成時間為 4 小時

Basic Structured Query Language

We learn the four core CRUD operations (Create, Read, Update, and Delete) to manage data stored in a database....
Reading
7 個視頻(共 77 分鐘), 3 個測驗
Video7 個視頻
15.2 - Using Databases12分鐘
15.3 - Single Table CRUD16分鐘
Worked Example: Counting Email in a Database13分鐘
Bonus: Office Hours Zagreb, Croatia3分鐘
Interview: Elizabeth Fong - The Early Years of SQL7分鐘
Worked Example: Twspider.py (Chapter 15)9分鐘
Quiz1 個練習
Single-Table SQL22分鐘

3

章節
Clock
完成時間為 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....
Reading
8 個視頻(共 81 分鐘), 2 個測驗
Video8 個視頻
15.5 - Representing a Data Model in Tables11分鐘
15.6 - Inserting Relational Data9分鐘
15.7 - Reconstructing Data with JOIN12分鐘
Worked Example: Tracks.py (Chapter 15)13分鐘
Bonus: Office Hours Perth, Australia1分鐘
Bonus Interview: Niklaus Wirth15分鐘
Bonus: Office Hours Barcelona2分鐘
Quiz1 個練習
Multi-Table Relational SQL20分鐘

4

章節
Clock
完成時間為 2 小時

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....
Reading
5 個視頻(共 62 分鐘), 2 個測驗
Video5 個視頻
Worked Example: roster.py (Chapter 15)11分鐘
Bonus: Office Hours Mexico, City分鐘
Bonus Interview: Andrew Tannenbaum - Minix10分鐘
Worked Example: Twfriends.py (Chapter 15)21分鐘
Quiz1 個練習
Many-to-Many Relationships and Python18分鐘
4.8
Direction Signs

31%

完成這些課程後已開始新的職業生涯
Briefcase

83%

通過此課程獲得實實在在的工作福利
Money

11%

加薪或升職

熱門審閱

突出顯示
High quality course material
(143)
Top rated instructor
(176)
創建者 MMMar 13th 2018

The course is great... You can definitely learn many things... Was kind of hard for me and i went many times back and forth through most of the lectures... However i think i learn many new things....

創建者 JGJun 17th 2016

This course was great! I enjoyed parsing different types of data: from documents and the web. This course is definitely (rudimentary) a must take course for anyone who wants to go into data science.

講師

Charles Severance

Associate Professor
School of Information

關於 University of Michigan

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....

關於 Python for Everybody 專項課程

This Specialization builds on the success of the Python for Everybody course and will introduce fundamental programming concepts including data structures, networked application program interfaces, and databases, using the Python programming language. In the Capstone Project, you’ll use the technologies learned throughout the Specialization to design and create your own applications for data retrieval, processing, and visualization....
Python for Everybody

常見問題

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

還有其他問題嗎?請訪問 學生幫助中心