How to create Pivot Table in MySQL using Group Concate | Triggers in MySQL | Sreya Basak

Through the video you vill be able to learn and understand the application of MySQL to create Pivot Table using a data. Also, the video will help in you in understanding Trigger functions of SQL. Perform data manipulation & analysis using SQL queries and how to extract Insights to help the stakeholders in making better decisions.

0:00 Introduction
0:30 Importing Data Set
0:49 About The Data Set and Initial Analysis
4:06 Create Pivot Table Using Group Concat
7:21 Triggers

Liked the video? Check out below more playlists on Data Science and Data Engineering learning tutorial, alumni interview experiences, live data science case studies,etc:

For more updates on courses and tips don’t forget to follow us on:

#ivyproschool #datawithivypro #dataanalytics #analytics

#pivottable #mysql #triggers #concate

[DanielGaravito]

Thanks for this amazing tutorial :) I have a question, when I try to define the variable with the group_concat, they always return the defalut value, they never update it, any suggestion?