|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/intro-sql
课程评论：没有评论
课程名称：结构化查询语言（SQL）入门 课程概述：在本课程中，您将学习如何安装文本编辑器、MAMP或XAMPP（或同类工具）并创建MySQL数据库。您将掌握单表查询及SQL语言的基本语法，还将学习涉及多个表的数据库设计，包括外键和JOIN操作。最后，您将学习如何建模多对多关系，这对于表示用户、角色和课程等内容至关重要。 课程大纲： 1. 名称：安装PHP和SQL 描述：首先的技术任务是完成包括安装文本编辑器、MAMP或XAMPP（或同类工具）、创建MySQL数据库的安装步骤。 2. 名称：结构化查询语言（SQL）简介 描述：学习单表查询和SQL语言的基本语法。 3. 名称：数据库设计 描述：涵盖多个表的数据库设计，包括外键和JOIN操作。 4. 名称：多对多关系 描述：学习如何建模多对多关系，这对于表示用户、角色和课程等内容是非常重要的。
Name:Installing PHP and SQL
Description: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.
Name:Introduction to Structured Query Language (SQL)
Description:We learn about single table queries and the basic syntax of the SQL language.
Name:Database Design
Description:Covering database design with multiple tables, foreign keys, and the JOIN operation..
Name:Many-To-Many
Description:We learn how to model many-to-many relationships like those needed to represent users, roles, and courses.
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.
