Data is the new fuel of the modern world and almost every aspect of our modern life is influenced by data-driven systems. Therefore, we need efficient database management systems to store, retrieve, and manipulate data. In this course, Managing MySQL Databases and Stored Procedures, you are going to learn how to create databases to store, retrieve, and manipulate data using MySQL. First, you’ll explore the basics of the relational data model and learn how you can design a relational database for an application that requires the storage of data. Next, you’ll get hands-on experience with various MySQL functionalities to store, retrieve, and manipulate data. Then, you’ll discover the MySQL stored procedures that can be used to write complex logic to manipulate data stored in a database. Finally, you’ll learn how to use views in MySQL to ensure data encapsulation and security. By the end of this course, you’ll have an in-depth knowledge of MySQL statements and stored procedures and you’ll also be capable of designing and managing a relational database using MySQL.
Author Name: Biswanath Halder
Author Description:
Biswanath is a Data Scientist who has around nine years of working experience in companies like Oracle, Microsoft, and Adobe. He has extensive knowledge of Machine Learning, Deep Learning, and Reinforcement Learning. He specializes in applying Machine Learning and Deep Learning techniques in complex business applications related to computer vision and natural language processing. He is also a freelance educator and teaches Statistics, Mathematics, and Machine Learning. He holds a Master’s degre… more

Table of Contents

• Course Overview
  1min
• Working with MySQL Databases
  45mins
• Introduction to MySQL Stored Procedures
  31mins
• Introduction to MySQL Triggers
  14mins
• Working with MySQL Views
  19mins