|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/advanced-mysql-topics
课程评论：没有评论
课程名称：高级MySQL主题 课程概述：在本课程中，您将进一步超越简单的SQL语句，深入实际的数据库工程，并学习MySQL中的高级概念。完成本课程后，您将能够： - 利用SQL函数和数字、字符串运算符为MySQL数据库添加决策结构和功能 - 熟练掌握条件和触发器的基础知识，展示自动化的工作知识 - 使用存储过程自动化DBMS任务 - 使用子查询和事务进行优化 - 通过执行高级数据库管理任务来优化数据库 - 编写存储过程以自动化SQL，解决现实世界中的问题 您将获得如下工具和软件的经验： - MySQL函数和运算符 - 数字函数和运算符 - SQL语句 - 数据库优化工具 - MySQL优化工具 - SQL自动化 - DBMS任务 - 数据库优化 课程大纲： 1. 函数和触发器： 学习如何在MySQL中开发用户定义的函数和更复杂的存储过程，并练习在插入、更新或删除等事件发生时自动调用存储程序（过程或函数）。 2. 数据库优化： 学习数据库优化的核心规则和指南，并实践高级数据库管理任务以优化您的数据库。 3. MySQL与数据分析： 学习如何将MySQL与高级数据分析工具结合使用，并发现如何使用高级MySQL查询进行数据分析。 4. 期末项目： 通过编写存储过程以解决现实世界中的问题，实践您的SQL自动化技巧。
Name:Functions and triggers
Description:Learn how to develop user defined functions and more complex stored procedures in MySQL. You'll also practice invoking a stored program (procedure or function) automatically in response to an event such as insert, update, or delete that occurs in the associated table.
Name:Database optimization
Description:Learn the core rules and guidelines for database optimization, and practice advanced database administration tasks that will optimize your database.
Name:MySQL for data analytics
Description:Learn how to use MySQL with advanced data analytics tools and discover how to perform data analysis using advanced MySQL queries.
Name:Final project
Description:Practice your SQL automation by writing a stored procedure to solve real world problems
In this course, you’ll begin to push beyond simple SQL statements to actual functional database engineering with advanced concepts in MySQL. By the end of this course, you’ll be able to: - Add decision structures and functionality to a MySQL databases using SQL functions and operators on numbers and strings - Demonstrate a working knowledge of the foundations of automation using conditionals and triggers - Automate DBMS tasks with the use of store procedures - Utilize subqueries and transactions to perform optimizations - Optimize databases with the use of advanced database administration tasks - Automate SQL by writing a stored procedure to solve real world problems You’ll gain experience with the following tools and software: - MySQL functions and operators - Numeric functions and operators - SQL statements - Database optimization tools - MySQL optimization tools - SQL statements - SQL automation - DBMS tasks - Database optimization
