I ranked every Intro to Data Science course on the internet, based on thousands of data points
David Venturi

I see you mentioned a couple of courses from the Johns Hopkins/Coursera offering, but those are only two pieces of the entire specialization. If you look at the Data Science Specialization (10 courses in all) from Johns Hopkins on Coursera (https://www.coursera.org/specializations/jhu-data-science) you’ll see it covers all of your required points above. Yes, I completed the specialization, and have a very strong foundation in data science because of it.