MySQL and Statistics for Data Analysis
Get analytical skills and proficiency in MySQL to boost your career as a data scientist or database administrator with this free course on MySQL and statistics.
MySQL is a database management system that is used in several applications depending on the need. In most cases, it is used in combination with web development and data science, which is likely the most common use of MySQL. Do you love data and want to be proficient in analytics, data science or business analysis? This course on MySQL and statistics for data analysis will set you up for an exciting journey to become a professional data scientist.
What You Will Learn In This Free Course
MySQL Basics and Introduction
In this module, basic introductions such as what MySQL is all about, its origin, its uses as well as its importance – why we need it as programming for data processing – and its advantages and disadvantages will be discussed. You will examine the basis of databases, in general, to understand their functionalities and learn to install and use MySQL.
MySQL Practical Examples and Projects
In this module, you will begin to experiment with MySQL. Starting with the basics of setting up databases, tables, importing files, etc, and advancing onto working with big data and large databases. Several case studies will be examined and projects will be practised. You will also learn to install Mongo Database.
Data and Statistics
In this module, basic introductions to data and statistics will be examined. You will learn about data types including their classifications and review several ways in which to present your data. Other topics such as standard deviation, practical statistics, data distribution, hypothesis testing, and machine learning will as well be explained.
Course assessment