|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-mastery-beginners-guide-to-mysql-essentials/
课程评论：没有评论
课程名称：SQL 精通：MySQL 基础指南 课程概述：本课程旨在为初学者提供坚实的 MySQL 基础，MySQL 是广泛使用的开源关系数据库管理系统。这是一门专门为绝对初学者设计的课程。 MySQL 是什么？MySQL 是由 Oracle 开发的关系数据库管理系统（RDBMS），基于结构化查询语言（SQL）。数据库是结构化的数据集合，可以是简单的购物清单、图片库或用于存储公司网络中大量信息的地方。关系数据库作为一种数字存储，按照关系模型组织数据，其中表由行和列组成，数据元素间的关系遵循严格的逻辑结构。RDBMS 是实现、管理和查询数据库的工具集合。 MySQL 是开源的，任何个人或企业都可以自由使用、修改、发布和扩展 Oracle 的开源 MySQL 代码库。软件根据 GNU 通用公共许可证（GPL）发布。需要将 MySQL 代码集成或包含在商业应用中的企业（或者如果开源软件不是优先考虑事项），可以从 Oracle 购买商业许可证版本。这些选项为组织在选择使用 MySQL 时提供了额外的灵活性。开源发布的公共和社区基础特性丰富了 MySQL 的文档和在线支持文化，同时确保持续或新开发的能力始终贴近用户需求。 MySQL 使用简单。尽管 MySQL 的关系特性和严格的存储结构可能看起来有限制，但表格范式是最直观的，这最终提高了可用性。MySQL 支持广泛的数据结构类型，包括标准的逻辑、数值、字母数字、日期和时间类型，以及更高级的 JSON 或地理空间数据。除了数据类型和丰富的内置功能外，MySQL 生态系统还包括多种工具，简化从服务器管理到报告和数据分析的所有过程。无论 RDBMS 的总体架构如何，用户总能找到 MySQL 的功能，以便以自己希望的方式建模和编码数据。MySQL 是学习和使用最简单的数据库技术之一。 先修知识：本课程不要求具备数据库或 SQL 的先前知识。建议具备基本的计算机操作能力，并熟悉命令行界面或图形用户界面（GUI）的使用。
Course Overview: This course is designed to provide beginners with a solid foundation in MySQL, a widely used open-source relational database management system. It's a course for absolute beginners only.What is MySQL?MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or a place to hold the vast amounts of information in a corporate network. In particular, a relational database is a digital store collecting data and organizing it according to the relational model. In this model, tables consist of rows and columns, and relationships between data elements all follow a strict logical structure. An RDBMS is simply the set of software tools used to actually implement, manage, and query such a database.MySQL is open-sourceAny individual or enterprise may freely use, modify, publish, and expand on Oracle's open-source MySQL code base. The software is released under the GNU General Public License (GPL).For MySQL code needing to be integrated or included in a commercial application (or if open-source software is not a priority), enterprises can purchase a commercially licensed version from Oracle.Again, these options provide organizations with additional flexibility if deciding to work with MySQL. The public and community-based nature of open-source releases enriches MySQL's documentation and online support culture, while also ensuring that sustained or newly-developed capabilities never stray too far from current user needs.MySQL is easy to useThough MySQL's relational nature and the ensuing rigid storage structures might seem restrictive, the tabular paradigm is perhaps the most intuitive, and ultimately allows for greater usability.In fact, MySQL makes many concessions to supporting the widest possible variety of data structures, from the standard but rich logical, numeric, alphanumeric, date, and time types, to more advanced JSON or geospatial data. Beyond mere data types and an expansive built-in feature set, the MySQL ecosystem also includes a variety of tools, easing everything from server management to reporting and data analysis.Regardless of the RDBMS's overarching architecture, users can invariably find a MySQL feature allowing them to model and codify data how they wish. MySQL remains one of the most straightforward database technologies to learn and use.Prerequisites: No prior knowledge of databases or SQL is required for this course. Basic computer literacy and familiarity with working in a command-line interface or graphical user interface (GUI) is recommended.
