|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/database-structures-and-management-with-mysql
课程评论：没有评论
课程名称：MySQL数据库结构与管理 课程概述：本课程旨在帮助学员掌握MySQL数据库管理系统（DBMS）的基本知识，学习数据创建、查询和操作等技能。通过本课程，您将深入了解SQL语句、子句和数据类型。 课程目标： - 利用MySQL DBMS构建和修改关系型数据库。 - 向MySQL数据库添加记录。 - 对数据库记录进行复杂的查询，使用过滤和分组。 - 在数据库中创建简单的联接和并集。 - 使用主键和外键在表之间建立关系。 - 展示完成功能规范化项目的能力。 您将获得的工具和软件经验包括： - MySQL DBMS - 联接和并集 - SQL语句、子句和数据类型 - 主键和外键 - 数据库规范化 课程大纲： 1. **MySQL简介**：学习使用MySQL DBMS构建、修改和查询关系型数据库。 2. **更新数据库及使用视图**：掌握如何更新数据库并使用视图。 3. **函数与MySQL存储过程**：探索不同类型的函数，并学习如何使用MySQL存储过程。 4. **评估模块**：回顾所学内容，识别个人优势以及需要进一步学习的主题。 本课程为想要深入了解MySQL数据库管理的学习者提供了系统化的学习路径。
Name:Intro to MySQL
Description:In this module, you will learn to use the MySQL DBMS to build, modify and query relational databases with SQL.
Name:Updating databases and working with views
Description:In this module you'll learn how update databases and work with views.
Name:Functions and MySQL stored procedures
Description:In this third module, you'll explore different types of functions and learn how to work with MySQL stored procedures.
Name:Graded assessment
Description:In this module, you’ll have an opportunity to recap what you learned and identify your strengths as well as target topics that you would like to revisit in this course.
Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ability to complete a database normalization project You’ll gain experience with the following tools and software: - MySQL DBMS - Joins and Unions - SQL statements, clauses and data types - Primary and foreign keys - Database normalization
