In this course, you’ll focus on developing the skills needed to work with complex business logic using Data Query Language (DQL) in MariaDB.
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
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