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