- Platform
- Coursera
- Provider
- University of Michigan
- Effort
- 3-5 hours per week
- Length
- 4 weeks
- Language
- English
- Credentials
- Paid Certificate Available
- Part of
- Course Link
Overview
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.
Taught by
Charles Severance
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.
Syllabus
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.
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
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.
Introduction to Structured Query Language (SQL)
We learn about single table queries and the basic syntax of the SQL language.
Database Design
Covering database design with multiple tables, foreign keys, and the JOIN operation..
Many-To-Many
We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
Taught by
Charles Severance