MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English | Duration: 2 hours | Size: 1.03 GB

Galera Cluster Building & Executing queries on MariaDB

What you'll learn

Create Database

Select and drop database

Create Table

Drop Table

Insert Records in Table

Update Data

Delete Data

Truncate Table

WHERE Clause

LIKE Clause, ORDER BY Clause, DISTINCT Clause, FROM Clause

INNER, LEFT OUTER, RIGHT OUTER JOINS

UNION, UNION ALL OPERATORS

INTERSECT

COUNT, SUM , MIN, MAX, MAX, AVG functions

EXPORT

CREATE PROCEDURE etc..

Requirements

The course assumes your familiarity with relational database management systems, querying languages, MySQL, and general programming.

It also assumes familiarity with typical database operations in an application.

Description

This course provides basic and advanced concepts of MariaDB. This course is designed for beginners and professionals both.

MariaDB is a community based project of the MySQL relational database management system. It is open source and relational database technology. It is a great replacement of MySQL.

This course includes all topics of MariaDB such as what is mariadb, features, installation, heidisql, syntax, datatypes, connection, Datatabase, create database, select database, tables, crud operation, insert, limit, update, delete, statement, clauses, operators, aggregate function, sum, avg, MariaDB conditions, MariaDB join etc.

This course targets novice developers and those new to MariaDB. It guides them in understanding basic through more advanced concepts in MariaDB. After completing this course, your firm foundation in MariaDB and level of expertise will allow you to begin developing and easily build on your knowledge.

The course assumes your familiarity with relational database management systems, querying languages, MySQL, and general programming. It also assumes familiarity with typical database operations in an application.

Who this course is for:

Database Administrators

Database Professionals

Software Engineers

Professionals and Students who want to start their careers with MariaDB