老程序员带您学SQL第2篇：MySQL数据库
Enroll now →
About this course
本课程是SQL系列课程第2篇：MySQL数据库。本篇包括4章内容，介绍MySQL数据库管理系统相关知识。内容包括MySQL数据库管理系统安装、日常管理、MySQL中特有的SQL语句和MySQL数据库开发。第1章 MySQL数据库管理系统安装1.1 MySQL概述1.1.1 MySQL主要特点1.1.2 MySQL主要版本 1.2 MySQL数据库安装和配置1.2.1 Windows平台安装MySQL1.2.2 Linux平台安装MySQL1.2.3 macOS平台安装MySQL第2章 MySQL数据库管理系统日常管理2.1 登录服务器2.2 常见的管理命令2.3 查看系统对象信息2.4 执行脚本文件2.5 数据库备份与恢复2.6 MySQL图形界面管理工具第3章 MySQL中特有的SQL语句3.1 自增长字段3.2 MySQL日期相关数据类型3.3 限制返回行数3.4 常用函数第4章 MySQL数据库开发4.1 存储过程4.2 存储过程参数4.3 存储函数4.4 触发器
What you'll learn
- Install and configure MySQL on Windows, Linux, and macOS
- Perform daily management tasks in MySQL
- Utilize MySQL-specific SQL statements
- Develop databases with stored procedures and triggers
Skills you'll gain
Related courses
Data Science Foundations
USD 49
Data Analytics in the Public Sector with R
USD 49
Data Science as a Field
USD 99
Geographic Information Systems (GIS)
USD 49
Statistical Methods and Data Analysis
USD 49
Enhancing Reproducible Science with GitHub and Docker
USD 49
Data Visualization & Analytics in Tableau
USD 49
Programming for Python Data Science: Principles to Practice
USD 49
Course details are provided by the platform and may change — always confirm on the provider's site. Links may be affiliate links.