Querying Data from MariaDB

Focused View

Pinal Dave

59:44

55 View

1. Course Overview

1. Course Overview.mp4

01:14

2. Understanding Data Query Language (DQL)

1. Version Check.mp4

00:15

2. Introduction.mp4

00:45

3. Comparison of Structured Query Language (SQL).mp4

01:41

4. Data Query Language (DQL).mp4

02:04

5. Demo - Data Query Language (SELECT).mp4

08:18

6. Summary.mp4

00:43

3. Retrieve Specific Column Data from Table

1. Introduction.mp4

01:18

2. Why Avoid SELECT.mp4

02:56

3. Real World Scenario.mp4

03:55

4. Demo - Retrieve Selected Columns.mp4

05:07

5. Demo - Self Join.mp4

07:48

6. Summary.mp4

00:51

4. Retrieve Specific Row Data from Table

1. Introduction.mp4

01:00

2. 2 Important Components of DQL.mp4

01:13

3. A Real World Scenario.mp4

03:18

4. Demo - SELECT Statement and WHERE Condition.mp4

07:03

5. Demo - SELECT Statement and Pattern Matching.mp4

05:41

6. Summary.mp4

01:03

5. Summary

1. Summary.mp4

03:31

Description

In this course, you’ll focus on developing the skills needed to work with complex business logic using Data Query Language (DQL) in MariaDB.

What You'll Learn?

Querying meaningful data is the primary task for any relational engine, and MariaDB is one of the most sophisticated relational databases in the RDBMS world. In this course, Querying Data from MariaDB, you’ll gain the ability to work with complex business logic using Data Query Language (DQL) in MariaDB. First, you'll learn how to retrieve specific column data from a table using the SELECT statement. Next, you’ll discover how to retrieve specific rows of data from a table using various keywords in the WHERE clause. Finally, you’ll explore how to use advanced search and pattern matching using the LIKE keyword. When you’re finished with this course, you’ll have the skills and knowledge of various elements of the data query language of MariaDB to bring 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.