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
  • 1 Book | 1h 32m
  • 1 Course | 1h 19m 11s
  • 1 Book | 1h 32m
  • 1 Course | 2h 4m 26s
  • 1 Book | 1h 32m
Likes 10 Likes 10
 
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 25s
    NOW PLAYING
  • Playable
    2. 
    Installing MariaDB on Windows
    8m 5s
    UP NEXT

GETTING STARTED

SQL Programming with MariaDB: Analyzing Relational Data

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

GETTING STARTED

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

  • Playable
    1. 
    Course Overview
    2m 49s
    NOW PLAYING
  • Playable
    2. 
    Understanding Joins
    10m 8s
    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 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

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

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

YOU MIGHT ALSO LIKE

CHANNEL RavenDB
Likes 3 Likes 3  
Likes 13 Likes 13