SQL Programming with MariaDB: Analyzing Relational Data

MariaDB 10.5    |    Intermediate
  • 10 videos | 1h 19m 11s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)
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 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

IN THIS COURSE

  • 2m 17s
  • 7m 29s
    During this video, you will learn how to use the following constraints: NOT, NULL, and UNIQUE. FREE ACCESS
  • Locked
    3.  Implementing SELECT-FROM-WHERE queries
    8m 12s
    In this video, find out how to run a few basic SELECT, FROM, and WHERE queries. FREE ACCESS
  • Locked
    4.  Using UNIQUE Constraints
    9m 55s
    In this video, you will learn how to use UNIQUE constraints in an in-depth and practical way. FREE ACCESS
  • Locked
    5.  Creating Tables from Other Tables Using Queries
    9m 59s
    During this video, you will learn how to use update operations to update rows in tables, and then create a table out of columns from another table. FREE ACCESS
  • Locked
    6.  Using the LIKE, NOT LIKE, IN, and NOT IN Keywords
    11m 17s
    Learn how the LIKE, NOT LIKE, IN, and NOT IN keywords work. FREE ACCESS
  • Locked
    7.  Using Subqueries
    7m 27s
    In this video, you will learn how to use subqueries in their most basic application. FREE ACCESS
  • Locked
    8.  Working with FOREIGN KEY Constraints
    11m 50s
    In this video, find out how to 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. FREE ACCESS
  • Locked
    9.  Using the BETWEEN, LIMIT, and ORDER BY Clauses
    8m 21s
    After completing this video, you will be able to recognize and use the BETWEEN, LIMIT, and ORDER BY keywords. FREE ACCESS
  • Locked
    10.  Course Summary
    2m 23s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course DDL, DML, & Constraints
Rating 4.6 of 100 users Rating 4.6 of 100 users (100)
Course Managing Reporting Services
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)
Course SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Rating 4.7 of 27 users Rating 4.7 of 27 users (27)