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
- Overview 1m
- Introduction to Relational Databases 3m
- Types of Relationships between Tables 3m
- Integrity Constraints 3m
- Data Types in MySQL 6m
- Integrity Constraints and Sequences 3m
- Create a Database Using MySQL 4m
- Create Tables Using MySQL 6m
- Insert Data Using MySQL 6m
- Creating and Using Temporary Tables in MySQL 3m
- Update and Delete Data Using MySQL 6m
- Summary 2m
- Overview 1m
- Stored Procedures in MySQL 4m
- Create Stored Procedures in MySQL 5m
- Variables and Conditional Control Statements 4m
- Cursor, Loops, and Error Handlers 6m
- Stored Procedures Using Cursors, Loops, and Error Handlers 4m
- Stored Functions in MySQL 5m
- List and Delete Stored Procedures and Functions 1m
- Summary 2m
About the author
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