Об этом курсе: 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 видео, 4 материала для самостоятельного изучения
- Reading: Textbook & Course Resources
- Reading: Help Us Learn More About You!
- Видео: Installing MAMP on a Macintosh
- Видео: Installing MAMP on Windows 10
- Видео: 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
- Видео: 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 тренировочный тест
- Видео: Basic SQL Operations
- Видео: Data Types in SQL
- Видео: Database Keys and Indexes
- Видео: Bonus: Liz Fong - Standardizing SQL
- Practice Quiz: SQL Queries
- Видео: Bonus: Office Hours Orlando, Florida
- Reading: 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 тренировочный тест
- Видео: Normalization and Foreign Keys
- Видео: Building a Physical Data Schema
- Видео: Relational Database Design #4
- Practice Quiz: Database Models
- Reading: 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 видео, 2 материала для самостоятельного изучения
- Reading: Assignment Specifications: Many-to-Many Databases
- Видео: Bonus: Office Hours Portland, Oregon
- Reading: Post-Course Survey
Оцениваемый: Autograder: Many-to-Many Databases
Часто задаваемые вопросы
Как это работает
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.
Авторы
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 | Доступен |
Рейтинги и отзывы
Coursera делает лучшее в мире образование доступным каждому, предлагая онлайн-курсы от ведущих университетов и организаций.
© Coursera Inc., 2018 Все права защищены.
