MySQL for Advanced Analytics: Tips, Tricks, & Techniques

MySQL for Advanced Analytics: Tips, Tricks, & Techniques
MySQL for Advanced Analytics: Tips, Tricks, & Techniques
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 41m | 126 MB

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.

Table of Contents

Introduction
1 Welcome
2 Why MySQL for advanced analytics

Data Ingestion and Transformation
3 Loading large data sets
4 Data cleansing
5 Creating indicator variables
6 Binning data

Data Analytics
7 Transposing data
8 Descriptive statistics
9 Finding IQR and median
10 Computing peak sessions
11 Centering and scaling

Linking with Excel
12 Importing MySQL data into Excel
13 Working with MySQL data
14 Updating from Excel

Conclusion
15 Next steps