Company: Linkedin Learning Author: Kumaran Ponnambalam Full Title: MySQL For Advanced Analytics: Tips, Tricks, & Techniques Year: 2018 Language: English Genre: Educational: Databases Skill Level: Intermediate Price: €20.65 - Files: MP4 (+ Exercise Files, Subtitles .SRT) Time: 00:41:58 Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 300 kbps Audio: AAC at 160 Kbps, 2 channels, 48.0 KHz 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. Lessons: 1. Introduction 01. Welcome 02. Why MySQL for advanced analytics? 2. Data Ingestion and Transformation 03. Loading large data sets 04. Data cleansing 05. Creating indicator variables 06. Binning data 3. Data Analytics 07. Transposing data 08. Descriptive statistics 09. Finding IQR and median 10. Computing peak sessions 11. Centering and scaling 4. Linking with Excel 12. Importing MySQL data into Excel 13. Working with MySQL data 14. Updating from Excel 5. Conclusion 15. Next steps Our members see more. Join us! ------------- Our members see more. Join us!
