MySQL Tutorial for Beginners | SQL for Data Engineering | Community Webinar

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 -- Presentation slides: https://info.datasciencedojo.com/hubfs/MySQL%20up%20and%20running%2030%20minutes.pdf -- For more captivating community talks featuring renowned speakers, check out this playlist: https://youtube.com/playlist?list=PL8eNk_zTBST-EBv2LDSW9Wx_V4Gy5OPFT For further tutorials on the fundamentals of machine learning, check out this exclusive playlist: https://youtube.com/playl