MySQL for Advanced Analytics: Tips, Tricks, & Techniques

( 0 Reviews )

Created by: Kumaran Ponnambalam

Produced in 2018

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

MySQL is an excellent database for advanced analytics, but few analysts use it that way because they aren't fully aware of its capabilities in this area. Analysts end up writing code to perform common tasks- "which can be time-consuming- "rather than using MySQL to do the same work. In this course, learn tips and techniques for using MySQL for advanced data analytics. Kumaran Ponnambalam walks through the different stages of analytics, from data ingestion and transformation to generating statistics. In each stage, Kumaran focuses on letting MySQL do the heavy lifting rather than writing code in Java or Python. Discover how to perform data cleansing through MySQL update commands, find peak usage of any resource, perform centering and scaling of data to prepare for machine learning, and more. Plus, Kumaran shows how you can link MySQL with Microsoft Excel to get the best of both worlds.

Intermediate Level

Time: 41m 58s

Instructor Details

Kumaran Ponnambalam

0.0 Rating
0 Reviews

Kumaran Ponnambalam has been working with data for more than 20 years.

He has built enterprise and cloud applications that ingest data to produce meaningful insights for its consumers. Data has always intrigued Kumaran and he has always searched for ways to mine, manage, and master it. Using analytics to solve business problems is his key interest domain. Of late, he has taken a keen interest in building quality courses for people to understand and use data. Big data analytics is fast growing, but quality education, especially in application areas, is lacking and he wants to contribute to it.