|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-an-introduction-for-beginners/
课程评论：没有评论
课程名称：MySQL：初学者入门 课程概述： MySQL是一种基于SQL（结构化查询语言）的关系型数据库管理系统，广泛应用于数据仓储、电子商务和日志应用等多个领域。作为全球最受欢迎的开源数据库，MySQL用于存储可通过查询进行操作的数据，特别在网页开发等多个行业中使用频繁。课程将覆盖MySQL的基础知识，帮助学员编写自己的查询，从数据库中提取所需数据。MySQL目前由数据库巨头Oracle公司拥有和支持，此外，还有可购买的商业许可版本，提供高级支持。MySQL是一个受到众多公司和机构广泛使用的可靠且可扩展的关系型数据库管理系统，例如社交网络网站Pinterest和美国宇航局（NASA）等。 在本课程中，我们将介绍一般关系型数据库管理系统的概念，并特别说明它们与MySQL的关系。学员将学习到以下内容： - MySQL的安装 - MySQL数据类型 - 基础的CRUD操作 - MySQL访问权限 - MySQL表连接 - 聚合函数 - MySQL子句 此外，MySQL Workbench是一款集成的可视化工具，专为数据库架构师、开发人员和数据库管理员（DBA）设计，提供数据建模、SQL开发以及综合管理工具，用于服务器配置、用户管理、备份等。MySQL Workbench支持Windows、Linux和Mac OS X，帮助DBA、开发人员或数据架构师进行可视化设计、建模、生成和管理数据库，具有创建复杂实体关系（ER）模型、数据库的正向和反向工程等功能，同时为复杂的变更管理和文档任务提供关键特性，帮助提高效率。
MySQL is a relational database management system based on SQL - Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications.The MySQL is the world's most popular open source database.The MySQL relational database is used to store data that can be manipulated using queries. It is used a lot in web development and other areas. In this course we are only covering the basics which should enable you write your own queries to get data from a database.MySQL is currently owned and supported by the database giant Oracle. There is a commercial licensed version of MySQL that can be purchased that comes with premium support MySQL is a popular ,reliable and scalable relational database management system that is used by lots of companies and establishments all over the world. For example the social networking site Pinterest and The Space company Nasa just to mention a couple. In this basic beginners course, we'll introduce the concepts of relational database management systems in general, and how they relate to MySQL in particular.Here is what you will learn:MySQL InstallationMySQL Data Types.Basic CRUD OperationsMySQL Access PrivilegesMySQL Table JoinsAggregate FunctionsMySQL ClausesMySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modelling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
