关于此课程： In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
此课程适用人群： Students with interest, but no experience in structured query language (SQL) or database design
制作方： University of Michigan
教学方： Charles Severance, Associate Professor
School of Information
| 基本信息 | 课程 2（共 4 门，Web Applications for Everybody Specialization ） |
| 级别 | Intermediate |
| 承诺学习时间 | 8-10 hours per week |
| 语言 | English |
| 硬件要求 | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| 如何通过 | 通过所有计分作业以完成课程。 |
| 用户评分 |
授课大纲
第 1 周
Installing PHP and SQL
Our first technical task is to work through the installation steps including installing a text editor, installing MAMP or XAMPP (or equivalent), creating a MySql Database, and writing a PHP program.
5 视频, 3 阅读材料
- Reading: Textbook & Course Resources
- 视频: Welcome to the Course
- 视频: Installing MAMP on a Macintosh
- 视频: Installing MAMP on Windows 10
- 视频: Installing XAMPP on Windows 10
- Reading: Installing LAMP On Linux
- Discussion Prompt: Your Database Experience
- Reading: Assignment Specifications: Installing PHP/MySQL
- LTI Item: Peer Graded: Installing PHP/MySQL
- 视频: Bonus: Office Hours in the Hague
第 2 周
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
6 视频, 1 阅读材料, 1 练习测试
- 视频: Overview of Databases
- 视频: Basic SQL Operations
- 视频: Data Types in SQL
- 视频: Database Keys and Indexes
- 视频: Bonus: Liz Fong - Standardizing SQL
- Practice Quiz: SQL Queries
- 视频: Bonus: Office Hours Orlando, Florida
- Reading: Assignment Specifications: Single-Table SQL
已评分: Autograder: Single-table SQL (Users)
第 3 周
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
6 视频, 1 阅读材料, 1 练习测试
- 视频: Relational Database Design
- 视频: Normalization and Foreign Keys
- 视频: Building a Physical Data Schema
- 视频: Relational Database Design #4
- Practice Quiz: Database Models
- Reading: Assignment Specifications
- 视频: Bonus: Office Hours Houston, TX
- 视频: Fun: Dr. Chuck gets a Educational Technology Tattoo
已评分: Peer Grader: Multi-Table Databases (Tracks)
第 4 周
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
2 视频, 1 阅读材料
- 视频: Many-to-Many Relationships
- Reading: Assignment Specifications: Many-to-Many Databases
- 视频: Bonus: Office Hours Portland, Oregon
已评分: Autograder: Many-to-Many Databases
常见问题解答
运作方式
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.
制作方
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.
价格
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
评分和审阅
Great course for an introduction to SQL. Chuck goes into detail and combines the lessons with humour to make the lessons enjoyable. He also provides additional website and sources for further SQL knowledge (the website does this too). Additionally, the teachers are helpful and answer questions on the discussions forums promptly.
Charles Severance makes jumping in and learning new programming languages and ways of thought painless. I highly recommend any course he teaches. (I'm currently enrolled in three others.)
His organization, materials, and presentation are all top-notch. Online education that actually meets the potential of the idea.
Interesting lecture easy to follow
This is a very nice course. Thank you doctor chuck for the wonderful time.