Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn MariaDB : A Beginner to Advanced Guide
Rating: 3.5 out of 5(41 ratings)
249 students

Learn MariaDB : A Beginner to Advanced Guide

Galera Cluster Building & Executing queries on MariaDB
Created byInflame Tech
Last updated 2/2019
English

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

Course content

1 section • 41 lectures • 2h 7m total length

  • 1.1 Introduction to the Course1:30
  • 1.2 What is MariaDB3:07

    Explore what MariaDB is as an open source relational database management system, including how tables, primary keys, and foreign keys establish relationships and ensure referential integrity.

  • 1.3 Features of MariaDB1:40

    Discover MariaDB features such as high performance storage engines and cross-platform support across multiple operating systems. Explore language compatibility, GPL or BSD licensing, and version history like 5.1.

  • 1.4 Download and Installation of MariaDB and HeidiSQL3:05
  • 1.6 Create Database1:18
  • 1.7 Select and Drop Database2:43
  • 1.8 Create Table5:30

    Learn how to create a table in MariaDB, specify a primary key, and define columns with appropriate data types.

  • 1.9 Drop Table1:34

    Learn how the drop table statement removes a table from a MariaDB database, its unrecoverable consequences, and use Management Studio to drop a table.

  • 1.10 Insert Records in Table2:26

    Learn how to insert records into a table using insert statements in MariaDB, and verify results with select queries on the students table, including fields like name, address, admission date.

  • 1.11 Select Data1:30
  • 1.12 Select Limit1:29
  • 1.13 Update Data2:22

    Learn how to update data in MariaDB by modifying existing fields, changing values like student names and birthdays, and reflecting these updates in records.

  • 1.14 Delete Data1:35
  • 1.15 Truncate Table0:54

    Explore how the truncate statement deletes all records in the same statement without a where clause, and understand that the deleted records cannot be ordered back.

  • 1.16 WHERE Clause3:03
  • 1.17 LIKE Clause2:34

    Explore the like clause in MariaDB, using pattern matching with wildcards in select statements to find data, including names starting with specific letters and single-character matches.

  • 1.18 ORDER BY Clause1:54

    Explore the order by clause to sort results in ascending or descending order. Retrieve student name and student id from the students table and view the ordered output.

  • 1.19 DISTINCT Clause1:40
  • 1.20 FROM Clause0:56
  • 1.21 COUNT () Function2:05

    Explore the MariaDB COUNT() function, learning how it counts expressions and rows, and how to count distinct student names to prevent duplicates in queries.

  • 1.22 SUM FUNCTION1:35
  • 1.23 MIN() FUNCTION1:06

    Learn how to use the min() function to retrieve the minimum value of an expression, and apply an order by clause in a MariaDB select query.

  • 1.24 MAX() FUNCTION0:35
  • 1.25 AVG () FUNCTION1:27

    Master the avg() function to compute the average salary across all students and apply a 50 percent increase to that average in MariaDB.

  • 1.26 JOIN - INNER JOIN2:30

    Master inner join concepts and the left and right join types to combine data from students and employees in MariaDB using select queries.

  • 1.27 JOIN- LEFT OUTER JOIN1:27

    Explore how a left outer join retrieves all student records and matches with employees where available.

  • 1.28 JOIN -RIGHT OUTER JOIN1:32

    Explore right outer join in MariaDB, using an on condition to combine students with employees and view student names, addresses, and employee salaries.

  • 1.29 UNION Operator1:40
  • 1.30 UNION ALL Operator1:41
  • 1.31 INTERSECT Operator1:58

    Explore the intersect operator in MariaDB by comparing student names and employee names to find common names and observe cases with no matches.

  • 1.32 Export Database1:22
  • 1.33 Create FUNCTION1:57
  • 1.34 Create PROCEDURE2:24

    Learn how to create and drop stored procedures in MariaDB, compare procedures with functions, and manage procedure names through practical examples.

  • 1.35 CONDITIONS Statement2:33
  • 1.36 COMPARISON Operator3:38

    Learn how the MariaDB comparison operator evaluates equality to filter data, enabling you to select results and understand how comparisons shape outcomes.

  • 1.37 Downloading Virtual Box1:52
  • 1.38 Download CentOS ISO Image1:11

    Download a CentOS ISO image by going to the link, then click the first link, and watch the download start.

  • 1.39 Set up a Machine add CentOS ISO Image3:21

    Learn how to set up a virtual machine in VirtualBox, enable virtualization, and attach a CentOS ISO image to the optical drive, configuring storage options.

  • 1.40 Start a Machine4:08
  • 1.41 Installation of MariaDB on CentOS6:58

    Install MariaDB on CentOS using yum, configure the system, and complete a secure setup by removing anonymous users and limiting remote login.

  • 1.42 Galera Cluster Installation39:36

    Set up a MariaDB Galera cluster across three servers by installing required packages, configuring services, and validating the clustered status.

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

Report abuse