Acerca de este curso: 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.
Para quién es esta clase: Students with interest, but no experience in structured query language (SQL) or database design
Creada por: University of Michigan
Enseñado por: Charles Severance, Associate Professor
School of Information
| Información básica | Curso 2 de 4 en Web Applications for Everybody Specialization |
| Nivel | Intermedio |
| Compromiso | 8-10 hours per week |
| Idioma | English |
| Requerimientos de hardware | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Cómo aprobar | Aprueba todas las tareas calificadas para completar el curso. |
| Calificaciones del usuario |
Programa
SEMANA 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 videos, 4 lecturas
- 阅读: Textbook & Course Resources
- 阅读: Help Us Learn More About You!
- Vídeo: Installing MAMP on a Macintosh
- Vídeo: Installing MAMP on Windows 10
- Vídeo: Installing XAMPP on Windows 10
- 阅读: Installing LAMP On Linux
- 讨论提示: Your Database Experience
- 阅读: Assignment Specifications: Installing PHP/MySQL
- LTI 项目: Peer Graded: Installing PHP/MySQL
- Vídeo: Bonus: Office Hours in the Hague
SEMANA 2
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
6 videos, 1 lecturas, 1 cuestionarios de práctica
- Vídeo: Basic SQL Operations
- Vídeo: Data Types in SQL
- Vídeo: Database Keys and Indexes
- Vídeo: Bonus: Liz Fong - Standardizing SQL
- 练习测验: SQL Queries
- Vídeo: Bonus: Office Hours Orlando, Florida
- 阅读: Assignment Specifications: Single-Table SQL
Calificado: Autograder: Single-table SQL (Users)
SEMANA 3
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
6 videos, 1 lecturas, 1 cuestionarios de práctica
- Vídeo: Normalization and Foreign Keys
- Vídeo: Building a Physical Data Schema
- Vídeo: Relational Database Design #4
- 练习测验: Database Models
- 阅读: Assignment Specifications
- Vídeo: Bonus: Office Hours Houston, TX
- Vídeo: Fun: Dr. Chuck gets a Educational Technology Tattoo
Calificado: Peer Grader: Multi-Table Databases (Tracks)
SEMANA 4
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
2 videos, 2 lecturas
- 阅读: Assignment Specifications: Many-to-Many Databases
- Vídeo: Bonus: Office Hours Portland, Oregon
- 阅读: Post-Course Survey
Calificado: Autograder: Many-to-Many Databases
Preguntas Frecuentes
Cómo funciona
课程作业
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
来自同学的帮助
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
证书
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
Creadores
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.
Tarifa
| Comprar curso | |
|---|---|
| Accede a los materiales del curso | Disponible |
| Accede a los materiales con calificación | Disponible |
| Recibe una calificación final | Disponible |
| Obtén un Certificado de curso para compartir | Disponible |
Calificaciones y revisiones
great teaching!
Its an really good overview of SQL. I have ready about Joins statements a lots of time, but forgot. However after taking this course, I have a clear vision about Joins.
Heavy
Coursera brinda acceso universal a la mejor educación del mundo, al asociarse con las mejores universidades y organizaciones, para ofrecer cursos en línea.
© 2018 Coursera Inc. Todos los derechos reservados.
So far, the best SQL course.