返回到 Advanced MySQL Topics
Meta

Advanced MySQL Topics

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.

状态:JSON
状态:Query Languages
中级课程小时

精选评论

CD

5.0评论日期:Nov 12, 2023

This is the content I needed to polish my SQL skills!

MA

5.0评论日期:Jan 2, 2023

Great course! in all fairness they did a very good job with this course, in my opinion that is.

AR

5.0评论日期:Mar 4, 2023

The course is very useful, the exercises are great.

YE

4.0评论日期:Aug 26, 2023

I found the content helpful and the lab environment helped me practice what learned step by step. However, the pace and tone of the instructor can be improved. I had to pause a lot to understand it.

LP

5.0评论日期:Jan 5, 2023

Thank you so much for the opportunity to learn Advanced MySql learn New things with crisp and clearly Taught Menter and Meta and Coursera thanks for help me..

AS

5.0评论日期:Dec 6, 2022

Great Course, Some advanced topics needs more explanation but overall a great course.

AD

5.0评论日期:Jun 5, 2024

Great course! Short and informative videos and interesting tasks.

KS

5.0评论日期:Aug 2, 2023

Amazing course , it goes over and beyond in teaching you practical ways of bettering your sql / mysql implementations. Thankful for this course.

KB

5.0评论日期:Apr 26, 2023

I like the way she teaches very detailed and in a simple way

SI

5.0评论日期:Dec 10, 2022

Learned a bunch of new SQL topics here.. I recommend this to anyone interested in improving their SQL skills. Don't forget to expand your understanding via any other resources out there.Good one!

YN

5.0评论日期:Dec 17, 2023

The course is very nice. The only suggestion is to have a summary document for each module.

RT

4.0评论日期:Apr 23, 2024

Its really a good course, it helped me with Advanced Topics on MYSQL

所有审阅

显示:20/68

Sidney Isoe
5.0
评论日期:Dec 10, 2022
Brent Artuch
5.0
评论日期:Jul 3, 2023
Bernard D. Rebagoda
5.0
评论日期:Jan 7, 2023
Patricia Ojonoka Idakwo
5.0
评论日期:May 10, 2023
Logeshwaran P
5.0
评论日期:Jan 6, 2023
Krish Shah
5.0
评论日期:Aug 3, 2023
Caleb Hill
4.0
评论日期:Oct 5, 2023
Brisa PR
4.0
评论日期:Apr 14, 2023
brent zitsman
4.0
评论日期:Mar 6, 2023
Eldin Fehric
4.0
评论日期:Mar 7, 2023
马镓浚
4.0
评论日期:Feb 20, 2023
Pranshul Maheshwari
3.0
评论日期:Nov 23, 2022
Carl Smith
5.0
评论日期:Dec 30, 2022
FARJAD. KHAN
5.0
评论日期:Sep 22, 2025
Abdullah Zubair
5.0
评论日期:Nov 12, 2022
Ricardo Aparecido de Sousa Freitas
5.0
评论日期:Oct 20, 2024
Manuel Alva
5.0
评论日期:Jan 2, 2023
Yaoxiang Nie
5.0
评论日期:Dec 17, 2023
aman sandhu
5.0
评论日期:Dec 6, 2022
Ahmad Dusmatov
5.0
评论日期:Jun 6, 2024