SQL Programming with MariaDB: Analyzing Relational Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
1.3

Lesson Objectives

SQL Programming with MariaDB: Analyzing Relational Data

  • discover the key concepts covered in this course
  • use the following constraints: NOT, NULL, and UNIQUE
  • run a few basic SELECT-FROM-WHERE queries
  • use UNIQUE constraints in an in-depth and applied way
  • use 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 work
  • use subqueries in their most fundamental application
  • constrain a child table from having any values in a column that are not in a specified column of the parent table using foreign key constraints
  • recognize and use the BETWEEN, LIMIT, and ORDER BY keywords
  • summarize the key concepts covered in this course
  • Course Number:
    it_dasqpmdj_02_enus

    Expertise Level
    Intermediate