À 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
- 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
- Practice Quiz: 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
- Practice Quiz: 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
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.
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
Very Useful
straight forward course, the correct amount of learning for someone who is a beginner
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.
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.
EK
CREATE TABLE Review (
rating INT ,
NAME VARCHAR(452) ,
INSERT INTO Review (NAME, RATING) VALUES ('GREAT PROFESSOR CHARLES SEVERANCE',5 );
) ENGINE = GOOD BYE CHARACTER SET = coursera