|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-creating-and-managing-relational-databases/
课程评论：没有评论
**课程名称：** MySQL 创建与管理关系型数据库 **课程概述：** 本课程专为初次接触 SQL 语言但希望学习关系型数据库操作的学习者而设计。课程内容全面，从基础知识入手，涵盖了 SQL 的定义、在本地计算机上安装和运行 MySQL 服务器，以及如何通过控制台和 MySQL Workbench 等工具使用 SQL。 课程深入讲解了 CRUD（创建、读取、更新、删除）操作，并详细阐述了文本函数和聚合函数，帮助您掌握修改数据库查询结果的方法。此外，课程还会教授如何构建具有逻辑层的查询，并通过条件语句控制查询结果的生成。 最后，课程将重点介绍关系模型，包括关系类型、创建、调用、处理方法以及使用触发器激活事件。在课程的最后部分，将通过一个包含多个相关联数据表的数据集进行实践操作。 课程的每个章节都配有额外的练习题，以帮助您巩固知识和技能，并提供总结性笔记。
The course is designed for people who have not had contact with the SQL language yet, but want to learn how to work with relational databases. In the course, we discuss all the necessary issues, work with examples and exercises, starting from the basics: what is SQL and how to install and run a local MySQL server on your home computer, how to use SQL itself from both the console and MySQL Workbench. Then we discuss the topic of CRUD: Create, Read, Update, Delete where we discuss all these activities in detail. The next stage will be text and aggregate functions where you will learn to modify the results of database queries. Next, an important step will be learning how to create queries with a logic layer and calling the appropriate conditions that will make the query result dependent on their fulfillment. Finally, we discuss the topic of relations - their types, how to create and invoke, handle them or activate events with triggers. At the end of the course, we will work on the data set in several tables connected by relations. In each section you will also find additional exercises that will allow you to check your knowledge and skills as well as notes summarizing the issues discussed.
