MySQL for Advanced Analytics: Tips, Tricks, & Techniques

Go to class
Write Review

Free Online Course: MySQL for Advanced Analytics: Tips, Tricks, & Techniques provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. MySQL for Advanced Analytics: Tips, Tricks, & Techniques is taught by Kumaran Ponnambalam.

Overview
  • Discover how to use MySQL to perform common data science tasks. Learn tips and tricks that can help you get more out of MySQL—and write less code in the process.

Syllabus
  • Introduction

    • Welcome
    • Why MySQL for advanced analytics?
    1. Data Ingestion and Transformation
    • Loading large data sets
    • Data cleansing
    • Creating indicator variables
    • Binning data
    2. Data Analytics
    • Transposing data
    • Descriptive statistics
    • Finding IQR and median
    • Computing peak sessions
    • Centering and scaling
    3. Linking with Excel
    • Importing MySQL data into Excel
    • Working with MySQL data
    • Updating from Excel
    Conclusion
    • Next steps