MariaDB Data Manipulation Playbook

Focused View

Pinal Dave

1:34:36

50 View

1. Course Overview

1. Course Overview.mp4

01:23

2. Understanding Data Manipulation Language (DML)

1. Version Check.mp4

00:15

2. Introduction.mp4

01:00

3. SQL Components.mp4

02:03

4. Data Manipulation Language (DML).mp4

01:15

5. Transactions.mp4

02:56

6. Demo - Transactions and DML (SELECT).mp4

04:50

7. Summary.mp4

00:58

3. Adding New Records into Tables with INSERT Statement

1. Introduction.mp4

01:00

2. INSERT Statement.mp4

02:38

3. Demo - INSERT - Various Examples.mp4

11:54

4. Demo - INSERT - Table to Table.mp4

03:14

5. Demo - INSERT - Transactions and Auto Incremental Columns.mp4

05:02

6. Summary.mp4

00:53

4. Changing Existing Records with the UPDATE Statement

1. Introduction.mp4

00:49

2. Update Statement.mp4

04:33

3. Demo - UPDATE Statement - Single Table.mp4

05:37

4. Demo - UPDATE Statement - Multiple Tables.mp4

07:20

5. Demo - UPDATE Statement - IGNORE Keywords.mp4

04:48

6. Demo - UPDATE Statement - Impact of TRANSACTION.mp4

02:35

7. Summary.mp4

00:53

5. Removing Records with Delete and Truncate Statement

1. Introduction.mp4

01:06

2. DELETE Statement.mp4

03:04

3. Demo - DELETE Statement.mp4

12:50

4. TRUNCATE Statement.mp4

02:56

5. Demo - TRUNCATE Statement.mp4

04:55

6. Summary.mp4

01:21

6. Summary

1. Summary.mp4

02:28

Description

This course will focus on the ability to work with complex business logic using the Data Manipulation Language (DML) of MariaDB, and some of its critical operations.

What You'll Learn?

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 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 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.