关于此课程： 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 ） |
| 级别 | 中级 |
| 承诺学习时间 | 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 个视频, 4 个阅读材料
- Reading: Textbook & Course Resources
- Reading: Help Us Learn More About You!
- 视频: 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 个练习测验
- 视频: 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 个练习测验
- 视频: 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 个视频, 2 个阅读材料
- Reading: Assignment Specifications: Many-to-Many Databases
- 视频: Bonus: Office Hours Portland, Oregon
- Reading: Post-Course Survey
已评分: 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.
价格
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
评分和审阅
The assignments in the class was pretty challenging at first to be honest but I was able to learn a lot and figure out how to do the homeworks through watching videos and by reading power point slides.
Great course with practical advice given!
This is the most amazing course in SQL, i've dealt with SQL before and i enrolled in different courses about SQL, but none of those could describe and explain SQL like the instructor here, appreciate your work
straight forward course, the correct amount of learning for someone who is a beginner