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
Author Name: Pinal Dave
Author Description:
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Table of Contents

• Course Overview
  1min
• Understanding Data Manipulation Language (DML)
  13mins
• Adding New Records into Tables with INSERT Statement
  24mins
• Changing Existing Records with the UPDATE Statement
  26mins
• Removing Records with Delete and Truncate Statement
  26mins
• Summary
  2mins