MySQL Tutorial for Beginners

An overview of MySQL, tools you need to interface with the newly set up RDBMS, and a few datasets that can be used to populate a small testing environment.

While data science has evolved, one fact has remained true even in the fast-paced recent years: most of the structured data remains in various RDBMS engine instances. Therefore, in the real world, most engineers and scientists will have to face the antediluvian SQL and the classic databases and their models behind it. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well-versed in SQL, the standard language for communicating with database systems.

There are great courses on how to use SQL, but in this presentation, we want to show you how easy it is to set up a playground with a "real" MySQL database.

In this presentation, we will discuss the topics:

- Is SQL useful for data science?
- Do a quick overview of what's a relational database management system and how it's different from the perhaps more modern NoSQL databases.
- Touch on SQL a bit, but this is not a SQL-oriented webinar.
- Guide through the ways to set up a local or remote RDBMS environment using MySQL.
- Show the tools you need to interface with the newly set up RDBMS.
- Show a few datasets that can be used to populate a small testing environment.

Table of Contents:
00:00 Introduction
03:30 What is a relational database management system (RDBMS)
07:50 Is SQL useful for data science
09:40 Deploying a MySQL instance
24:00 Interfacing with MySQL
29:14 Dataset examples
51:30 QnA

--
--

--

--

Unleash your data science potential for FREE! Dive into our tutorials, events & courses today!

--

📱 Social media links

--

Also, join our communities:

_

#mysql #sql #nosqldatabases