MariaDB: MariaDB 10.5 intermediate
Technology:
Expertise:
- 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
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
Assessment
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
Assessment
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
Assessment
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 RevealedCovering 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.
1h 32m
By Daniel Bartholomew
Book
Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more AccessibleThis 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.
8h 13m
By Adam Aspin
BOOKS INCLUDED
Book
MariaDB and MySQL Common Table Expressions and Window Functions RevealedCovering 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.
1h 32m
By Daniel Bartholomew
Book
Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more AccessibleThis 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.
8h 13m
By Adam Aspin
BOOKS INCLUDED
Book
MariaDB and MySQL Common Table Expressions and Window Functions RevealedCovering 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.
1h 32m
By Daniel Bartholomew
Book
Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more AccessibleThis 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.
8h 13m
By Adam Aspin
