|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-and-mysql-workbench-for-beginners/
课程评论：没有评论
课程名称：初学者的MySQL和MySQL Workbench 课程概述：MySQL Workbench是一款统一的可视化工具，专为数据库架构师、开发人员和数据库管理员（DBA）设计。它提供了数据建模、SQL开发和全面的管理工具，涵盖服务器配置、用户管理、备份等众多功能。MySQL Workbench可在Windows、Linux和Mac OS X上使用，能够帮助DBA、开发者或数据架构师直观地设计、建模、生成和管理数据库。 MySQL Workbench包含数据建模所需的一切，支持创建复杂的ER模型、前向和反向工程，且具备执行困难的变更管理和文档任务的关键特性，通常这些任务需要耗费大量时间和精力。它还提供可视化工具用于创建、执行和优化SQL查询，SQL编辑器具备语法高亮、自动完成功能、SQL片段重用和执行历史等功能。数据库连接面板使开发者能够轻松管理标准数据库连接，包括MySQL Fabric。对象浏览器则提供对数据库架构及对象的即时访问。 MySQL Workbench提供了可视化控制台，方便管理员轻松管理MySQL环境并获得更好的数据库可视性。开发者和DBA可以利用可视化工具配置服务器、管理用户、执行备份与恢复、检查审计数据并查看数据库健康状况。 MySQL是一种开源的关系数据库管理系统（RDBMS），名字来源于共同创始人Michael Wideness的女儿“My”。MySQL是最受欢迎的开源关系SQL数据库管理系统之一，也是开发各种基于Web的软件应用程序的最佳RDBMS之一，能够帮助用户存储、组织和检索数据。 （注：本课程大纲未提供具体课程内容）
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, 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.MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Wideness's.MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL helps users store, organize, and retrieve data.
