À 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 : University of 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 | Anglais, Sous-titres : Serbe |
| 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
- Reading: Textbook & Course Resources
- Reading: 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
- Reading: Installing LAMP On Linux
- Discussion Prompt: Your Database Experience
- Reading: Assignment Specifications: Installing PHP/MySQL
- LTI Item: 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
- Reading: 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
- Reading: 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
- Reading: Assignment Specifications: Many-to-Many Databases
- Vidéo: Bonus: Office Hours Portland, Oregon
- Reading: 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
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.
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
Charles Severance is a great teacher, it was a pleasure to be a part of that amazing course. It provides confidence doing first steps with SQL. HIGLY RECOMMENDED!
This is a great course! Just what I was looking for in order to have an understanding of how SQL really works.
Nice approach and good setup.
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.
RS
I am starting today and waiting for Financial Aid i have applied. I am from Pakistani Middles-class family can't afford fees to getting good education from reputable university