YoVDO

MySQL for Advanced Analytics: Tips, Tricks, & Techniques

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Data Science Courses Data Analysis Courses MySQL Courses Descriptive Statistics Courses Data Transformation Courses Advanced Analytics Courses Data Cleansing Courses Data Ingestion Courses

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?
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

Taught by

Kumaran Ponnambalam

Related Courses

Interprofessional Healthcare Informatics
University of Minnesota via Coursera Data Science at Scale - Capstone Project
University of Washington via Coursera Implementing ETL with SQL Server Integration Services
Microsoft via edX Introduzione a R
University of Modena and Reggio Emilia via EduOpen Практики работы с данными средствами Power Query и Power Pivot
Saint Petersburg State University via Coursera