MySQL for Advanced Analytics
Tips, Tricks, & Techniques
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.
Contents:
- Introduction
- 1. Data Ingestion and Transformation
- 2. Data Analytics
- 3. Linking with Excel
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 41m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Kumaran Ponnambalam |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking Data Science Programming |
Tags | IT Databases Big Data MySQL Database Development |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Writing Tutor, Writing Center $55k
Code Inspector 2 $56k
Code A Expediter $57k
Writing Tutor, Writing Center Fellow $61k
Code enforcement official $65k
SUB-CODE OFFICIAL $70k
Code Administration Officer $72k
Code Compliance $77k
Writing Instructor (University Writing) $80k
Owner Code Monkey $89k
Senior Code Monkey $106k
Writing Center Coordinator and Writing Professor $112k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 41m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Kumaran Ponnambalam |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | IT & Networking Data Science Programming |
Tags | IT Databases Big Data MySQL Database Development |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course