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.

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.