SQL – MySQL & Statistics for Data Analysis Bootcamp 2021 – Udemy

(10 customer reviews)




What you’ll learn

  • SQL – MySQL for Data science.
  • Write complex SQL queries across multiple tables.
  • Relational databases versus non relational databases.
  • Learn how to code in SQL
  • Sampling distribution with practical simulation apps and answering of important technical questions.
  • Confidence level and Confidence interval.
  • Distinguish and work with different types of distributions .
  • Inferential and Descriptive statistics with collection of important quizzes and examples .
  • One sample mean t test .
  • Two sample means t test .
  • How to calculate P value using manual and direct method ?
  • What is after data analysis ?
  • Null hypothesis and alternative hypothesis .
  • Understand What is P value ?
  • Data types and Why we need to study data types ?
  • What is Type one error ?
  • Relationship between Type one error and Alpha ( non confident probability )
  • Is Normal distribution and t distributions are cousins ?
  • Projects like Estimation of goals in premier league ( using confidence interval ) , and more .. and more to learn it
  • What is “double edged sword of statistics” ?
  • Practical significance versus statistical significance , and more and more to learn it

Show moreShow less

300+ Lectures/Articles lectures include real life practical projects and examples for people need to learn SQL – MySQL  for data science and statistics
Enjoy practice  15 Apps/Projects in SQL – MySQL for data
analytics and learn Statistics  for data science .

This is the Complete 2021 Bootcamp , Two courses in ONE COURSE .

Do you like jobs in MySQL for data science ?
Do you like jobs in Machine learning ?
Do you like jobs in Marketing analyst ?
Do you like jobs in Programming for data science ?
Do you like jobs in Business analysis and business intelligence ?

If the answer is yes , then all of the above needs MySQL and Statistics for data science .

Who prepared this course material ?

This course material is prepared from highly experienced engineers worked in a leader companies like Microsoft , Facebook and google .

After hard working from five months ago we created 300+ Lectures/Articles to cover everything related to SQL – MySQL  & statistics for data science  .     
In no time with simple and easy way you will learn and love  SQL for data science and statistics .
We stress in this course to make it very spontaneous to make all students love SQL and statistics for data science

Who’s teaching you in this course ?

I’m senior developer and chief data science engineer  . i worked for many projects related to expert systems and artificial intelligence .
Also i worked as Tutor and consultant trainer with a leader international companies located in USA and UK .

I spent over five  months  of hard working to create 300+ Lectures/Articles  in super high quality  to make all students enjoy and love  SQL for data science and statistics.   
I’m sharing a lot of practical experience from my own work with you in this  course .

Why learn MySQL  or SQL ? 

MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with web development and data science . You hear “it’s easy to work with” a lot in relation to computer languages, but MySQL truly is simple.

For instance, someone with little to no knowledge of MySQL can easily establish a database .
Of course, a lot of hosting providers make this process even simpler by handling all the necessary tasks for new website administrators, but it doesn’t detract from the point that MySQL is relatively easy to use.
I could not imagine data science without databases .

What is my final goal after my students enroll in this course ? 

My final goal is to make all students and engineers  love SQL for data science and statistics .
My big challenge in this course is to make it professional course at the same time it should be very easy and simple for all People .
Therefore you will notice that i used a lot of  graphics and imaginary ideas to make you LOVE SQL for data science and statistics

So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!

What is course contents ?

  • Starting introduction to data science and data analysis .

  • Understand programming basics for data science 

  • learn SQL – MySQL basics .

  • Write all the SQL joins

  • Create Foreign key and primary key in MySQL databases . 

  • Learn how to start and stop MySQL server .

  • Analyze data using Aggregate Functions .

  • Read and import external CSV files into MySQL database .

  • Export MySQL database table contents into CSV file .
    Awesome Projects and examples like :

    1. How Mr. Genie helped us to find all fishes in the sea ?

    2. Mr. Genie power versus statistics power

    3. The double edged sword of statistics

    4. Help fisherman to catch Tuna using sampling distribution

    5. Ice Cola example with student’s t distribution .

    6. Estimation of goals in premier league ( using confidence interval ) .


  • One sample mean t test .

  • Two sample mean t test .

  • Null hypothesis and alternative hypothesis .

  • What is P value ?

  • How to calculate P value using manual and direct method ?

  • Two mini stories for TWO PROJECTS  related to hypothesis testing 

    1. Project one is how Sarah used “one sample mean  t test” for Ice Cola factory  to prove that her brother Ibrahim is innocent ?

    2. Project two how Sarah used “two sample mean t test” for Ice Cola factory to help her brother Ibrahim to increase Ice Cola sales in winter ?

  • … more and more

  • …. and more and more course contents

#SQL #MySQL #MySQL-for-data-science #SQL-for-Data-science

Who this course is for:

  • People interested to learn programming and SQL for data science
  • Beginners in programming
  • Beginners in data science
  • Beginners in MySQL databases for data science
  • Anyone needs to learn statistics from beginner to advanced level .
  • Statistics for data science
  • Statistics for data analysis
  • Marketing analyst
  • AP statistics
  • beginner in business intelligence

Course content

  • Course orientation
  • An Introduction to SQL – MySQL – Data Science
  • Your first MySQL Activity
  • App 2 ( Pele versus Maradona ) Who was better?
  • App 3 ( MySQL data types )
  • App 4 ( Select Statement in MySQL )
  • App 5 ( MySQL alter table )
  • App 6 ( primary and foreign key )
  • App 7 ( MySQL where clause )
  • App 8 ( ORDER BY clause )

10 reviews for SQL – MySQL & Statistics for Data Analysis Bootcamp 2021 – Udemy

  1. Donny Phan

    Super practical. Lessons are catered towards anyone looking to find work in this industry. It felt very comprehensive and gave me a broad understanding of the programming spectrum

  2. Madhav raj Verma

    Thanks for your great effort. i am fully satisfied with this course the way you teach and your explanation are very clear ,The content you provide in your course no one can do this at this price.

  3. Sachin Gupta

    I really didn’t want to leave a low rating as Angela is a great teacher. The 1st half of this course was terrific. The 2nd half was terrible. Under the justification of “teaching students how to figure things out on their own”, pretty much all videos and all explanations were dropped. You were just told what to do, given links to documentation and told to figure it out on your own. I understand doing that to some degree, but to revert to that entirely for nearly half the content barely makes this a course. It’s just a list of things for you to learn, then you’re left on your own to learn them. The 2nd half was so bad, especially the data science component, that I didn’t bother finishing the course.

  4. Vincent Beaudet

    Amazing 40 days course.
    Angela is a great teacher.
    The other 60 days are all about web developement, interacting with web pages, on your own with little to no explanations. I did not expect that at all. I wanted to learn more about software and scripting.
    This left me disappointed , confused and i started to doubt myself. Not a fun experience after the amount of effort i’v put in this course.

    Exercices format and explanations for the first 40 days were worth it tho.

  5. Ben K

    Not just an introduction to python, but really helps you learn fundamental aspects of python and coding in general. Some parts may require some knowledge on the subject (data science comes to mind) and there is quite some web development in the course. So, a few areas were not completely to my liking (I would have liked to see it done differently), but this course deserves the 5 stars in my opinion.

  6. Omid Alikhel

    I found the method a bit difficult when a code is written and then changed back to something different, with no enough explanation of how something happened and where it came from or a step by step explanation of why something is happening, i have no doubt in the instructors talent, but we are beginners!

  7. Devang Jain

    The course is not updated and most of the solution codes don’t work and there are no video solutions towards the end

  8. Szymon Kozak

    I think that the course tutor is really good in giving right information to learn at the right time. Thanks to this fact, my understanding of coding in python after 29 days of learning is above my expectations.

  9. Begoña Ruiz Diaz

    Ha sido la mejor elección que podría haber hecho.

  10. Vaibhav Sachdeva

    I want to thank Angela for making such an amazing course. It really helped me explore more things with python.

Add a review

Your email address will not be published.