What you'll learn

Create Database
Select and drop database
CREATE TABLE IF NOT EXISTS
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