MariaDB: MariaDB 10.5 Beginner

https://www.skillsoft.com/channel/mariadb-4bfba79a-8f36-4ad0-b56b-d09e798671f3?technologyandversion=49296&expertiselevel=49295 https://www.skillsoft.com/channel/mariadb-4bfba79a-8f36-4ad0-b56b-d09e798671f3?technologyandversion=49296&expertiselevel=49297 https://www.skillsoft.com/channel/mariadb-4bfba79a-8f36-4ad0-b56b-d09e798671f3?technologyandversion=49296&expertiselevel=49298
  • 1 Course | 1h 5m 15s
  • 1 Book | 1h 32m
  • 1 Course | 1h 19m 41s
  • 1 Book | 1h 32m
  • 1 Course | 2h 5m 8s
  • 1 Book | 1h 32m
Likes 7
 
Explore MariaDB, an open source relational database created by the original developers of MySQL.

GETTING STARTED

SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis

  • Playable
    1. 
    Course Overview
    2m 28s
    NOW PLAYING
  • Playable
    2. 
    Installing MariaDB on Windows
    8m 8s
    UP NEXT

GETTING STARTED

SQL Programming with MariaDB: Analyzing Relational Data

  • Playable
    1. 
    Course Overview
    2m 20s
    NOW PLAYING
  • Playable
    2. 
    Using Constraints
    7m 32s
    UP NEXT

GETTING STARTED

SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures

  • Playable
    1. 
    Course Overview
    2m 52s
    NOW PLAYING
  • Playable
    2. 
    Understanding Joins
    10m 11s
    UP NEXT

COURSES INCLUDED

SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis
MariaDB is a popular tool for SQL programming. To use it, you must first know how to install it on your machine and set it up for your needs. In this course, you'll learn how to install MariaDB for macOS and MS Windows. You'll then run MariaDB from a command line interface (CLI) and create a new custom user for MariaDB from the CLI -an essential step for running MariaDB from a client such as DBeaver, as connecting as root is not considered a best practice. Next, you'll work with DBeaver and recognize how it is a handy user interface to interact with a MariaDB server. Finally, you'll run a few basic MariaDB commands and queries from DBeaver.
9 videos | 1h 5m has Assessment available Badge

COURSES INCLUDED

SQL Programming with MariaDB: Analyzing Relational Data
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 const