MySQL for Advanced Analytics: Tips, Tricks, & Techniques
Offered By: LinkedIn Learning
Course Description
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?
- Loading large data sets
- Data cleansing
- Creating indicator variables
- Binning data
- Transposing data
- Descriptive statistics
- Finding IQR and median
- Computing peak sessions
- Centering and scaling
- Importing MySQL data into Excel
- Working with MySQL data
- Updating from Excel
- Next steps
Taught by
Kumaran Ponnambalam
Related Courses
Problem Solving with ExcelPwC via Coursera Data Cleansing with Data Quality Services (DQS)
Microsoft via edX Data Analytics for Decision Making
Queen Mary University of London via FutureLearn Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera Excel 2013 Tips and Tricks
LinkedIn Learning