À propos de ce cours : 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.
Les destinataires de ce cours : Students with interest, but no experience in structured query language (SQL) or database design
Créé par : Université du Michigan
Enseigné par : Charles Severance, Associate Professor
School of Information
| Informations de base | Cours 2 de 4 dans Web Applications for Everybody Specialization |
| Niveau | Intermédiaire |
| Engagement | 8-10 hours per week |
| Langue | English |
| Matériel requis | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Comment réussir | Réussissez tous les devoirs notés pour terminer le cours. |
| Notes des utilisateurs |
Programme de cours
SEMAINE 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 vidéos, 4 lectures
- Leyendo: Textbook & Course Resources
- Leyendo: Help Us Learn More About You!
- Vidéo: Installing MAMP on a Macintosh
- Vidéo: Installing MAMP on Windows 10
- Vidéo: Installing XAMPP on Windows 10
- Leyendo: Installing LAMP On Linux
- Cuadro de aviso de la discusión: Your Database Experience
- Leyendo: Assignment Specifications: Installing PHP/MySQL
- Elemento LTI: Peer Graded: Installing PHP/MySQL
- Vidéo: Bonus: Office Hours in the Hague
SEMAINE 2
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
6 vidéos, 1 lecture, 1 quiz pour s'exercer
- Vidéo: Basic SQL Operations
- Vidéo: Data Types in SQL
- Vidéo: Database Keys and Indexes
- Vidéo: Bonus: Liz Fong - Standardizing SQL
- Cuestionario de práctica: SQL Queries
- Vidéo: Bonus: Office Hours Orlando, Florida
- Leyendo: Assignment Specifications: Single-Table SQL
Noté: Autograder: Single-table SQL (Users)
SEMAINE 3
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
6 vidéos, 1 lecture, 1 quiz pour s'exercer
- Vidéo: Normalization and Foreign Keys
- Vidéo: Building a Physical Data Schema
- Vidéo: Relational Database Design #4
- Cuestionario de práctica: Database Models
- Leyendo: Assignment Specifications
- Vidéo: Bonus: Office Hours Houston, TX
- Vidéo: Fun: Dr. Chuck gets a Educational Technology Tattoo
Noté: Peer Grader: Multi-Table Databases (Tracks)
SEMAINE 4
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
2 vidéos, 2 lectures
- Leyendo: Assignment Specifications: Many-to-Many Databases
- Vidéo: Bonus: Office Hours Portland, Oregon
- Leyendo: Post-Course Survey
Noté: Autograder: Many-to-Many Databases
FAQ
Comment cela fonctionne
Trabajo del curso
Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.
Ayuda de tus compañeros
Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.
Certificados
Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.
Créateurs
Université du 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.
Tarification
| Acheter le cours | |
|---|---|
| Accéder au contenu du cours | Disponible |
| Accéder au contenu noté | Disponible |
| Recevoir une Note Finale | Disponible |
| Obtenir un Certificat de Cours partageable | Disponible |
Notation et examens
Great, Everyone new to SQL should start with this course.
Rock solid class. Not fancy, but it gets the point across very succinctly.
the instruction is easy to follow
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2018 Coursera Inc. Tous droits réservés.
TC
Great introduction to SQL. The best thing to do during the course would be to create and test your own work to ensure the concept is fully grasped at the end of each unit.