Learn MariaDB : A Beginner to Advanced Guide

Learn MariaDB : A Beginner to Advanced Guide, available at $29.99, has an average rating of 3.5, with 41 lectures, based on 39 reviews, and has 244 subscribers.

You will learn about 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.. This course is ideal for individuals who are Database Administrators or Database Professionals or Software Engineers or Professionals and Students who want to start their careers with MariaDB It is particularly useful for Database Administrators or Database Professionals or Software Engineers or Professionals and Students who want to start their careers with MariaDB.

Enroll now: Learn MariaDB : A Beginner to Advanced Guide

Summary

Title: Learn MariaDB : A Beginner to Advanced Guide

Price: $29.99

Average Rating: 3.5

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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..

Who Should Attend

Database Administrators
Database Professionals
Software Engineers
Professionals and Students who want to start their careers with MariaDB

Target Audiences

Database Administrators
Database Professionals
Software Engineers
Professionals and Students who want to start their careers with MariaDB

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.�

Course Curriculum

Chapter 1: Introduction

Lecture 1: 1.1 Introduction to the Course

Lecture 2: 1.2 What is MariaDB

Lecture 3: 1.3 Features of MariaDB

Lecture 4: 1.4 Download and Installation of MariaDB and HeidiSQL

Lecture 5: 1.6 Create Database

Lecture 6: 1.7 Select and Drop Database

Lecture 7: 1.8 Create Table

Lecture 8: 1.9 Drop Table

Lecture 9: 1.10 Insert Records in Table

Lecture 10: 1.11 Select Data

Lecture 11: 1.12 Select Limit

Lecture 12: 1.13 Update Data

Lecture 13: 1.14 Delete Data

Lecture 14: 1.15 Truncate Table

Lecture 15: 1.16 WHERE Clause

Lecture 16: 1.17 LIKE Clause

Lecture 17: 1.18 ORDER BY Clause

Lecture 18: 1.19 DISTINCT Clause

Lecture 19: 1.20 FROM Clause

Lecture 20: 1.21 COUNT () Function

Lecture 21: 1.22 SUM FUNCTION

Lecture 22: 1.23 MIN() FUNCTION

Lecture 23: 1.24 MAX() FUNCTION

Lecture 24: 1.25 AVG () FUNCTION

Lecture 25: 1.26 JOIN – INNER JOIN

Lecture 26: 1.27 JOIN- LEFT OUTER JOIN

Lecture 27: 1.28 JOIN -RIGHT OUTER JOIN

Lecture 28: 1.29 UNION Operator

Lecture 29: 1.30 UNION ALL Operator

Lecture 30: 1.31 INTERSECT Operator

Lecture 31: 1.32 Export Database

Lecture 32: 1.33 Create FUNCTION

Lecture 33: 1.34 Create PROCEDURE

Lecture 34: 1.35 CONDITIONS Statement

Lecture 35: 1.36 COMPARISON Operator

Lecture 36: 1.37 Downloading Virtual Box

Lecture 37: 1.38 Download CentOS ISO Image

Lecture 38: 1.39 Set up a Machine add CentOS ISO Image

Lecture 39: 1.40 Start a Machine

Lecture 40: 1.41 Installation of MariaDB on CentOS

Lecture 41: 1.42 Galera Cluster Installation

Instructors

Inflame Tech

Rating Distribution

1 stars: 5 votes
2 stars: 4 votes
3 stars: 11 votes
4 stars: 11 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu