|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-mysql-tutorial-learning-16-complex-queries/
课程评论：没有评论
**Coursera MySQL 教程 + 16 个复杂查询学习课程总结** 本课程旨在教授如何使用 MySQL 数据库管理系统。课程适合完全的初学者，但随着学习的深入，您将熟悉复杂的概念，积累经验，提升专业技能，并熟练掌握 MySQL 和处理大型数据库。 **课程内容分为三个部分：** **第一部分：MySQL 基础入门** * **数据库概念：** 熟悉 MySQL 数据库，理解数据库的简单功能定义。 * **环境搭建：** 学习如何设置工作环境以开始使用 MySQL。 * **数据库与表创建：** 创建您的第一个数据库和表。 * **表结构分析：** 学习分析已创建表的结构。 * **数据操作：** * 添加唯一键和列到数据库表。 * 检索数据库表中的简单数据。 * 从数据库表中删除数据。 * 使用简单和复杂的 UPDATE 命令更新表。 * **表间关系：** * 理解外键的概念以及如何在表之间建立连接。 * 学习如何连接表以获取更复杂的数据。 * **视图：** 了解视图及其在复杂查询中作为子查询的应用。 **第二部分：电子商务数据库实践** * **数据库介绍：** 熟悉一个中型电子商务应用程序数据库。 * **表间关系：** 学习可以在数据库表之间创建的各种关系。 * **电子商务数据库操作：** 创建电子商务数据库表并执行简单查询。 **第三部分：高级查询与数据处理** * **数据准备：** 为电子商务数据库准备海量数据。 * **复杂查询：** 学习并执行 16 种不同且复杂的数据库表查询。
Purpose of this course is to teach you how to use Mysql database management system. This course is created for complete beginner developers but as you progress you will become familiar with complicated matters, increase your experience and automatically enhance your level of expertise and become proficient in using Mysql and dealing with large databases. This course is made up of three sections.In section one: You will become familiar with Mysql database and get a simple and functional definition of database. You will learn how to set up environment to start work with Mysql You will create first database and table You will learn how to analyze structure of created table You will add unique key and columns to database table You will learn how to retrieve simple data form database table You will learn how to delete data from database table You will learn how to use simple and complex update command to update your tables You will learn concept of foreign key and how to establish connection between tables You will learn how to join tables and get more complex data You will learn about views and how to use them as sub queries in complex queriesIn section two: You will become familiar with a medium sized e-commerce application database You will learn different relationships which can be created between database tables You will create e-commerce database tables and execute simple queries on themIn section three: You will prepare your e-commerce database with massive data You will learn and execute 16 different and complex queries on database tables
