Informações sobre o 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 quem é direcionado este curso: Students with interest, but no experience in structured query language (SQL) or database design
Desenvolvido por: University of Michigan
Ministrado por: Charles Severance, Associate Professor
School of Information
| Informações básicas | Curso 2 de 4 no Web Applications for Everybody Specialization |
| Nível | Intermediário |
| Compromisso | 8-10 hours per week |
| Idioma | English |
| Requisitos de hardware | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Como ser aprovado | Seja aprovado em todas as tarefas para concluir o curso. |
| Classificação do usuário |
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 leituras
- Reading: Textbook & Course Resources
- Reading: 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
- 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 leituras, 1 teste para praticar
- 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
Nota atribuída: Autograder: Single-table SQL (Users)
SEMANA 3
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
6 videos, 1 leituras, 1 teste para praticar
- 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
Nota atribuída: 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 leituras
- Reading: Assignment Specifications: Many-to-Many Databases
- Vídeo: Bonus: Office Hours Portland, Oregon
- Reading: Post-Course Survey
Nota atribuída: Autograder: Many-to-Many Databases
Perguntas frequentes
Como 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.
Desenvolvedores
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.
Custo
| Comprar curso | |
|---|---|
| Acesso aos materiais do curso | Disponível |
| Acesso a materiais valendo nota | Disponível |
| Receba uma nota final | Disponível |
| Obtenha um Certificado de Curso compartilhável | Disponível |
Classificações e avaliações
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
i hope you can´t make a more advance course, and probably focusing in other things like data science
O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.
© 2018 Coursera Inc. Todos os direitos reservados.
great teaching!