Chevron Left
返回到 Advanced MySQL Topics

學生對 元信息 提供的 Advanced MySQL Topics 的評價和反饋

4.3
15 個評分

課程概述

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transactions You'll gain experience with the following advanced MySQL database skills: - MySQL user defined functions - Advanced MySQL stored procedures - MySQL optimization techniques including Indexes, Transactions, CTE and JSON - MySQL triggers and events - Database analytics in MySQL - Advanced SQL queries for data analysis with JOINS, views and subqueries Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects. To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course....

熱門審閱

篩選依據:

1 - Advanced MySQL Topics 的 7 個評論(共 7 個)

創建者 Abdullah Z

2022年11月12日

創建者 Aman U R S

2022年12月6日

創建者 alfin f

2022年12月9日

創建者 Oseloka I

2022年12月5日

創建者 Ghilas b

2022年11月7日

創建者 Pranshul M

2022年11月23日

創建者 Fe c

2022年11月3日