Об этом курсе: 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.
Для кого этот курс: Students with interest, but no experience in structured query language (SQL) or database design
Автор: University of Michigan
Преподаватели: Charles Severance, Associate Professor
School of Information
| Основные сведения | Course 2 of 4 in the Web Applications for Everybody Specialization |
| Уровень | Intermediate |
| Выполнение | 8-10 hours per week |
| Язык | English |
| Требования к аппаратным средствам | The typical student will use a laptop or desktop computer running MacOX, Windows, or Linux. |
| Как пройти курс | Чтобы пройти курс, выполните все оцениваемые задания. |
| Оценки пользователей |
Программа курса
НЕДЕЛЯ 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 видео, 3 материалов для самостоятельного изучения
- Leyendo: Textbook & Course Resources
- Видео: Welcome to the Course
- Видео: Installing MAMP on a Macintosh
- Видео: Installing MAMP on Windows 10
- Видео: 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
- Видео: Bonus: Office Hours in the Hague
НЕДЕЛЯ 2
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
6 видео, 1 материал для самостоятельного изучения, 1 practice quiz
- Видео: Overview of Databases
- Видео: Basic SQL Operations
- Видео: Data Types in SQL
- Видео: Database Keys and Indexes
- Видео: Bonus: Liz Fong - Standardizing SQL
- Cuestionario de práctica: SQL Queries
- Видео: Bonus: Office Hours Orlando, Florida
- Leyendo: Assignment Specifications: Single-Table SQL
Оцениваемый: Autograder: Single-table SQL (Users)
НЕДЕЛЯ 3
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
6 видео, 1 материал для самостоятельного изучения, 1 practice quiz
- Видео: Relational Database Design
- Видео: Normalization and Foreign Keys
- Видео: Building a Physical Data Schema
- Видео: Relational Database Design #4
- Cuestionario de práctica: Database Models
- Leyendo: Assignment Specifications
- Видео: Bonus: Office Hours Houston, TX
- Видео: Fun: Dr. Chuck gets a Educational Technology Tattoo
Оцениваемый: Peer Grader: Multi-Table Databases (Tracks)
НЕДЕЛЯ 4
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
2 видео, 1 материал для самостоятельного изучения
- Видео: Many-to-Many Relationships
- Leyendo: Assignment Specifications: Many-to-Many Databases
- Видео: Bonus: Office Hours Portland, Oregon
Оцениваемый: Autograder: Many-to-Many Databases
Часто задаваемые вопросы
Как это работает
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.
Авторы
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.
Стоимость
| Приобрести курс | |
|---|---|
| Получить доступ к материалам курса | Доступен |
| Получить доступ к оцениваемым материалам курса | Доступен |
| Получить итоговую оценку | Доступен |
| Earn a shareable Course Certificate | Доступен |
Рейтинги и отзывы
Great course for an introduction to SQL. Chuck goes into detail and combines the lessons with humour to make the lessons enjoyable. He also provides additional website and sources for further SQL knowledge (the website does this too). Additionally, the teachers are helpful and answer questions on the discussions forums promptly.
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.
Interesting lecture easy to follow
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
This is a very nice course. Thank you doctor chuck for the wonderful time.