To master any Relational Database Management System (RDBMS), it is important to learn the elements of data manipulation, and MariaDB is one of the most sophisticated relational databases in the RDBMS world.
In this course, MariaDB Data Manipulation Playbook, you’ll gain the ability to work with complex business logic using the Data Manipulation Language (DML) of MariaDB.
First, you’ll learn how to add new records into tables with the INSERT statement.
Next, you’ll discover how to change existing records with the UPDATE statement.
Finally, you’ll explore how to remove records with the DELETE and TRUNCATE statements.
When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data manipulation language of MariaDB to bring out meaningful results from your database.
Software required: MariaDB
Course Overview Hi, everyone. My name is Pinal Dave, welcome to my course, MariaDB Data Manipulation Playbook. I'm a SQL Performance Expert at sqlauthority.com. MariaDB is the world's most widely used free and open source database. This course gives you a comprehensive view of major components of MariaDB Data Manipulation. This course requires no prior experience with databases. Some of the major topics that we will cover include understanding the data manipulation language, adding new records into tables with the INSERT statement, changing existing records with the UPDATE statement, removing records with DELETE and TRUNCATE statements. And finally, we will summarize all this in the final module of the summary. Many of the modules contain additional learning resources to strengthen your further learning. By the end of this course, you will have a solid foundation to get started with data manipulation with MariaDB. I hope you will join me on this journey to learn MariaDB with the MariaDB Data Manipulation Playbook course, at Pluralsight.