|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-database-admin-dba-for-beginners/
课程评论：没有评论
课程名称：MySQL数据库管理 - 初学者指南 课程概述：MySQL是全球最受欢迎的开源数据库。本课程将教您如何开始使用这个极其流行的MySQL数据库，并在此过程中获得实用技能。通过学习MySQL，您将全面了解关系数据库。此外，您将通过学习SQL来利用这项强大功能，构建数据库、填充数据，并通过大量的实践进行查询。您还将学习如何使用MySQL Workbench，这是一款功能强大的管理工具，包含许多实用功能，可帮助您执行MySQL服务器安装上的各种管理任务。 学习内容包括： - MySQL服务器的安装和配置 - 创建数据库 - 创建表 - 创建视图 - 创建存储过程 - 使用子查询 - 管理用户和权限 - 执行备份和恢复 - 检查客户端连接 - 检查服务器状态 - 执行表连接 - 探索和使用MySQL Workbench - 使用MySQL命令行客户端 - 执行常见MySQL命令 - 查询数据库 - 更新数据库 - 删除记录 - 执行聚合函数 - 使用SQL编辑器 SQL（结构化查询语言）是用来与数据库（例如MySQL等）交互的语言，并成为了美国国家标准协会（ANSI）和国际标准化组织（ISO）的标准语言。SQL的功能包括： - 执行数据库查询 - 从数据库中检索数据 - 在数据库中插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新数据库和新表 - 创建存储过程和视图 - 对表、程序和视图设置权限 尽管SQL是一项ANSI/ISO标准，但不同版本的SQL语言存在差异。本课程将全面深入地介绍与MySQL相关的各种内容，适合初学者学习。
The MySQL is the world's most popular open source database.This course will teach you a lot to start using this incredibly popular MySQL database and gain useful skills in the process. In learning about MySQL you will also gain an understanding of relational databases in general. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.You will learn how to use the MySQL Workbench which is a very powerful administrative tool that contains a lot of useful features that will enable you perform various administrative tasks on MySQL Server installations.What You will learn includes:Installation and configuration of MySQL ServerCreating DatabasesCreating TablesCreating ViewsCreating Stored ProceduresUsing subqueriesManaging users and proviledgesPerforming backups and restoreChecking client connectionsChecking Server StatusPerform table joinsExplore and use MySQL WorkbenchUse MySQL Command line clientExecute Common MySQL CommandsQuery databasesUpdate databasesDelete recordsPerform aggregate functionsUsing SQL EditorsSQL is the language used to interact with databases like MySQL and othersSQL is a standard language for accessing and manipulating databases.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsSQL is a Standard - BUT....Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.
