-
Course
- Data
Managing MySQL Databases and Stored Procedures
MySQL is one of the most widely used open-source relational database management systems. This course will enable you to kick-start your journey with MySQL and introduce you to various MySQL functionalities to store, retrieve, and manipulate data.
What you'll learn
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.
Table of contents
About the author
Biswanath is a Data Scientist having nine years of industry experience. He is also a freelance educator. He holds a Master's degree in Computer Science from the Indian Institute of Science.
More Courses by Biswanath