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 | Intermediate |
| 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, 3 readings
- Reading: Textbook & Course Resources
- Vídeo: Welcome to the Course
- Vídeo: Installing MAMP on a Macintosh
- Vídeo: Installing MAMP on Windows 10
- Vídeo: 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
- 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 reading, 1 practice quiz
- Vídeo: Overview of Databases
- Vídeo: Basic SQL Operations
- Vídeo: Data Types in SQL
- Vídeo: Database Keys and Indexes
- Vídeo: Bonus: Liz Fong - Standardizing SQL
- Practice Quiz: SQL Queries
- Vídeo: Bonus: Office Hours Orlando, Florida
- Reading: 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 reading, 1 practice quiz
- Vídeo: Relational Database Design
- Vídeo: Normalization and Foreign Keys
- Vídeo: Building a Physical Data Schema
- Vídeo: Relational Database Design #4
- Practice Quiz: Database Models
- Reading: 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, 1 reading
- Vídeo: Many-to-Many Relationships
- Reading: Assignment Specifications: Many-to-Many Databases
- Vídeo: Bonus: Office Hours Portland, Oregon
Calificado: Autograder: Many-to-Many Databases
Preguntas Frecuentes
Cómo funciona
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.
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
Interesting lecture easy to follow
good for the beginner
Professor Charles is awesome.
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.
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.