SQL Programming with MariaDB: Analyzing Relational Data
MariaDB 10.5
| Intermediate
- 10 Videos | 1h 19m 11s
- Includes Assessment
- Earns a Badge
To query data with SQL, you need to know which queries and keywords to use for which operations. In this course, you'll learn to query data using the classic SQL syntax construct, the SELECT-FROM-WHERE query, and how keywords, such as LIKE, can be used to filter data based on a condition and using wildcards. You'll learn how to carry out different aspects of inserting, updating, and deleting data - such operations, along with querying, are collectively known as CRUD operations, an acronym for Create-Read-Update-Delete. Finally, you'll learn how to take advantage of another important aspect of relational database usage - the ability to impose constraints upon data. You'll work with UNIQUE, NOT NULL, and FOREIGN KEY constraints.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseuse the following constraints: NOT, NULL, and UNIQUErun a few basic SELECT-FROM-WHERE queriesuse UNIQUE constraints in an in-depth and applied wayuse update operations to update rows in tables, then create a table out of columns from another table
-
use the LIKE, NOT LIKE, IN, and NOT IN keywords workuse subqueries in their most fundamental applicationconstrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraintsrecognize and use the BETWEEN, LIMIT, and ORDER BY keywordssummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 17sUP NEXT
-
2.Using Constraints7m 29s
-
3.Implementing SELECT-FROM-WHERE queries8m 12s
-
4.Using UNIQUE Constraints9m 55s
-
5.Creating Tables from Other Tables Using Queries9m 59s
-
6.Using the LIKE, NOT LIKE, IN, and NOT IN Keywords11m 17s
-
7.Using Subqueries7m 27s
-
8.Working with FOREIGN KEY Constraints11m 50s
-
9.Using the BETWEEN, LIMIT, and ORDER BY Clauses8m 21s
-
10.Course Summary2m 23s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.