MySQL for Advanced Analytics: Tips, Tricks, & Techniques

  • 0
  • Less than 1 hour of material
  • LinkedIn Learning
  • English
MySQL for Advanced Analytics: Tips, Tricks, & Techniques

Course 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.

Course Circullum

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
out of 5.0
5 Star 85%
4 Star 75%
3 Star 53%
1 Star 20%

Item Reviews - 3

Submit Reviews

Free Trial Available

This Course Include:
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
  • Provider:LinkedIn Learning
  • Certificate:Certificate Available
  • Language:English
  • Duration:Less than 1 hour of material
  • Language CC:

Do You Have Questions ?

We'll help you to grow your career and growth.
Contact Us Today