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 4m 48s
  • 2 Books | 9h 45m
  • 1 Course | 1h 19m 11s
  • 2 Books | 9h 45m
  • 1 Course | 2h 4m 26s
  • 2 Books | 9h 45m
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
 
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

  • 2m 25s
  • 8m 5s

GETTING STARTED

SQL Programming with MariaDB: Analyzing Relational Data

  • 2m 17s
  • 7m 29s

GETTING STARTED

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

  • 2m 49s
  • 10m 8s

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 4m 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 constraints upon data. You'll work with UNIQUE, NOT NULL, and FOREIGN KEY constraints.
10 videos | 1h 19m has Assessment available Badge

COURSES INCLUDED

SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Joins, triggers, and stored procedures are useful tools to take advantage of when working with MariaDB. In this course, you'll begin by using several types of joins, such as cross joins, inner joins, and outer joins, to combine data from multiple tables. Next, you'll use aggregate functions, such as SUM, MIN, MAX, AVERAGE, and COUNT, with the GROUP BY clause to group data in rows based on a specified column. You'll then use the HAVING clause as a way to filter the output of the GROUP BY clause. You'll move on to use the two types of generated columns - virtual and persistent, computing them on-the-fly from a function expression. Finally, you'll use triggers to perform operations whenever a condition is satisfied and stored procedures for code re-use and parameterization.
14 videos | 2h 4m has Assessment available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

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.

BOOKS INCLUDED

Book

MariaDB and MySQL Common Table Expressions and Window Functions Revealed
Covering two of the most compelling and yet underrated new features in MariaDB 10.2 and MySQL 8.0, this clear and concise book helps readers to not only know how to apply the features, but also to recognize when to apply them.
book Duration 1h 32m book Authors By Daniel Bartholomew

Book

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
This book will take you on an engaging experience to understand SQL querying from the most basic to the most expert level, using various SQL techniques to extract valuable insights from your MariaDB databases. The adventure will begin with the most basic level and end with the most professional level.
book Duration 8h 13m book Authors By Adam Aspin

BOOKS INCLUDED

Book

MariaDB and MySQL Common Table Expressions and Window Functions Revealed
Covering two of the most compelling and yet underrated new features in MariaDB 10.2 and MySQL 8.0, this clear and concise book helps readers to not only know how to apply the features, but also to recognize when to apply them.
book Duration 1h 32m book Authors By Daniel Bartholomew

Book

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
This book will take you on an engaging experience to understand SQL querying from the most basic to the most expert level, using various SQL techniques to extract valuable insights from your MariaDB databases. The adventure will begin with the most basic level and end with the most professional level.
book Duration 8h 13m book Authors By Adam Aspin

BOOKS INCLUDED

Book

MariaDB and MySQL Common Table Expressions and Window Functions Revealed
Covering two of the most compelling and yet underrated new features in MariaDB 10.2 and MySQL 8.0, this clear and concise book helps readers to not only know how to apply the features, but also to recognize when to apply them.
book Duration 1h 32m book Authors By Daniel Bartholomew

Book

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible
This book will take you on an engaging experience to understand SQL querying from the most basic to the most expert level, using various SQL techniques to extract valuable insights from your MariaDB databases. The adventure will begin with the most basic level and end with the most professional level.
book Duration 8h 13m book Authors By Adam Aspin